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....
2010-04-27
7,533 reads
The DMV for Day 27 is sys.dm_tran_locks, which is described by BOL as:
Returns information about currently active lock manager resources....
2010-04-27
7,533 reads
Since SQL Server 2008 R2 has gone RTM, and will be available on MSDN Subscribers on May 3, I thought...
2010-04-27
1,920 reads
Well, we are on the final week of the DMV a Day series for the month of April. I will...
2010-04-26
1,608 reads
Since SQL Server 2008 R2 has gone RTM, and will soon be available for purchase, I am going to be...
2010-04-26
974 reads
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...
2010-04-25
1,692 reads
The DMV for Day 24 is sys.dm_exec_requests, which is described by BOL as:
Returns information about each request that is executing...
2010-04-24
953 reads
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...
2010-04-23
2,393 reads
The DMV for Day 22 is sys.dm_exec_query_memory_grants, which is described by BOL as:
Returns information about the queries that have acquired...
2010-04-22
1,748 reads
The DMV for Day 21 is sys.dm_os_ring_buffers, which is helpfully NOT described by BOL as:
The following SQL Server Operating System–related...
2010-04-21
2,580 reads
Microsoft’s Ted Kummert and Tom Casey are holding a public conference call this morning at 7:30AM Pacific time, where:
Microsoft...
2010-04-21
727 reads
At a recent conference I was asked how I executed code during my presentation....
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item Enable a Disabled Index
Comments posted to this topic are about the item Diving Deeper into the Import...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers