Monthly Archives: April 2010

A DMV A Day – Day 30

The DMV for Day 30 is sys.dm_os_buffer_descriptors, which is described by BOL as: Returns information about all the data pages that are currently in the SQL Server buffer pool. The output of this view can be used to determine the … Continue reading

Posted in SQL Server 2008 | 1 Comment

A DMV a Day – Day 29

The DMV for Day 29 is sys.dm_exec_connections, which is described by BOL as: Returns information about the connections established to this instance of SQL Server and the details of each connection. This DMV can be used to help identify who … Continue reading

Posted in SQL Server 2008 | Leave a comment

A DMV a Day – Day 28

The DMV for Day 28 is sys.dm_io_pending_io_requests, which is described by BOL as: Returns a row for each pending I/O request in SQL Server. That is a pretty straightforward, if terse description.  This DMV works with SQL Server 2005, SQL … Continue reading

Posted in SQL Server 2008 | Leave a comment

SQL Server 2008 and 2008R2 Diagnostic Information Queries

Since SQL Server 2008 R2 has gone RTM, and will be available on MSDN Subscribers on May 3, I thought it was time to post an updated version of the Diagnostic Information queries. This has updated build lists for SQL … Continue reading

Posted in SQL Server 2008 R2 | 1 Comment

A DMV a Day – Day 27

The DMV for Day 27 is sys.dm_tran_locks, which is described by BOL as: Returns information about currently active lock manager resources. Each row represents a currently active request to the lock manager for a lock that has been granted or … Continue reading

Posted in SQL Server 2008 | Leave a comment

SQL Server 2005 Diagnostic Information Queries (April 2010)

Since SQL Server 2008 R2 has gone RTM, and will soon be available for purchase, I am going to be spending even less time talking about SQL Server 2005 in the future. If you are on SQL Server 2005, you … Continue reading

Posted in SQL Server 2005 | 3 Comments

A DMV a Day – Day 26

Well, we are on the final week of the DMV a Day series for the month of April. I will be posting a recap of the series on May 3, that will have links and a summary for each post … Continue reading

Posted in SQL Server 2008 | Leave a comment