Monthly Archives: April 2010

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 →

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 →

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 →

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 →

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 →

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 →

The DMV for Day 25 is sys.dm_os_memory_cache_counters, which is described by BOL as: Returns a snapshot of the health of a cache. sys.dm_os_memory_cache_counters provides run-time information about the cache entries allocated, their use, and the source of memory for the … Continue reading →

The DMV for Day 24 is sys.dm_exec_requests, which is described by BOL as: Returns information about each request that is executing within SQL Server. This DMV is useful for getting a quick snapshot of currently executing requests on your instance … Continue reading →

The DMV for Day 23 is sys.dm_os_process_memory, which is described by BOL as: Most memory allocations that are attributed to the SQL Server process space are controlled through interfaces that allow for tracking and accounting of those allocations. However, memory … Continue reading →