Get flash to fully experience Pearltrees
By Jonathan Kehayias, SQL Server MVP. You can view Jonathan’s blog at http://sqlblog.com/blogs/jonathan_kehayias/ . As SQL Server matures with time, the diagnostics tools available to administrators to troubleshoot problems when they arise have also matured.
For those fighting with all the Extended Event terminology, let's step back and have a small overall introduction to Extended Events. This post will give you a simplified end to end view through some of the elements in Extended Events.
March 29, 2010 by pinaldave
The 64-bit versions of Microsoft Windows Server 2003 and Microsoft Windows XP can support more RAM than the 32-bit versions of these products.
Understanding SQL server memory grant - Tips, Tricks, and Advice from the SQL Server Query Processing TeamThis article describes how query memory grant works in Microsoft SQL Server.
The DMV for Day 23 is sys.dm_os_process_memory , which is described by BOL as:
SQL Server Architecture We have already mentioned that SQL Server is quite easy to use, but this can also be one of its drawbacks when it comes to peopleâ€™s perceptions of this product. As long as you understand what it does and when it behaves in a wrong way, we argue that there is no value in having to tune a database server manually when you can let the built-in logic do it.
Microsoft SQL Server performs dynamic memory management based on the memory requirements of the current load and activities on the system. On a Windows Server 2003 or a Windows XP or later version system, SQL Server can use the memory notification mechanisms that are provided by the QueryMemoryResourceNotification Windows API.
Background The official Microsoft 70-450 exam is intended for the professional level SQL Server 2008 Database Administrator.
With Performance Data Collector in SQL Server 2008, you can now store performance data from a number of SQL Servers in one central location. This data is collected by a collection set on each server and stored in a shareable management data warehouse (MDW). Reports can be generated from this data using the built-in reports or generating your own with reporting Services.
Published: June 26, 2006 SQL Server Technical Article
Takeaway: Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth properly, and what can be done to correct the problems.
When you use database mirroring in Microsoft SQL Server 2005, SQL Server automatically propagates any changes on the principal database to the mirror database. However, if you run the DBCC SHRINKDATABASE statement or the DBCC SHRINKFILE statements to shrink the principal database, the shrink operation is not duplicated on the mirror database. Database mirroring will change the physical file sizes only after a checkpoint.
The transaction log is used to guarantee the data integrity of the database and for data recovery. The topics in this section provide the information about the physical architecture of the transaction log. Understanding the physical architecture can improve your effectiveness in managing transaction logs.
Log truncation frees space in the log file for reuse by the transaction log.