When was sys.dm_os_wait_stats last cleared?

The sys.dm_os_wait_stats DMV provides essential metrics for diagnosing SQL Server performance problems. Returning incrementally accumulating information about all the completed waits encountered by executing threads it is a useful way to identify bottlenecks such as IO latency issues or waits on locks. The counters are reset each time SQL server is restarted, or when the following command…

2

New SQLOS features in SQL Server 2012

Here’s a quick summary of SQLOS feature enhancements going into SQL Server 2012. Most of these are already in the CTP3 pre-release, except for the Resource Governor enhancements which will be in the release candidate. We’ve blogged about a couple of these items before. I plan to add detail. Let me know which ones you’d like…

4