A DMV a Day – Day 14
The DMV for Day 14 is sys.dm_os_wait_stats, which is described by BOL as:
Returns information about all the waits encountered by...
2010-04-14
783 reads
Glenn Berry
Microsoft Changing Their Lifecycle Support Policy
Microsoft’s Bob Ward has a new post up on the CSS SQL Server Engineers blog about a change in their...
2010-04-14
1,726 reads
A DMV a Day – Day 13
The DMV for Day 13 is sys.dm_io_virtual_file_stats, which is described by BOL as:
Returns I/O statistics for data and log files....
2010-04-13
1,194 reads
Visual Studio 2010 Ultimate RTM Available and Installed
Microsoft’s Scott Guthrie had a good post up yesterday that highlights some of the new features in Visual Studio 2010....
2010-04-13
508 reads
A DMV a Day – Day 12
The DMV for Day 12 is sys.dm_db_partition_stats, which is described by BOL as:
Returns page and row-count information for every partition...
2010-04-12
844 reads
Visual Studio 2010 Download Interruptus
Microsoft has made the RTM bits for the various versions and components of Visual Studio 2010 available on MSDN Subscribers...
2010-04-12
335 reads
2010-04-11
1,577 reads
A DMV a Day – Day 10
Just in case you’ve just joined me, I decided on April 1 to post a different DMV query every day...
2010-04-10
1,827 reads
A DMV a Day – Day 9
The DMV for Day 9 is sys.dm_os_schedulers, which is described by BOL as:
Returns one row per scheduler in SQL Server...
2010-04-09
961 reads
A DMV a Day – Day 8
We have two related DMVs for Day 8. The first one is sys.dm_fts_active_catalogs, which is described by BOL as:
Returns information...
2010-04-08
1,250 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers