Microsoft's SQL Server development team learned a hard lesson from its work on SQL Server 2005: Customers do not want to wait five years for an upgrade. From now on, a new development regime called ...
The resource waits monitor shows all of the server-level resource wait types and gives you stats about each one. Similarly, data file I/O puts all of the important info at your fingertips, though it ...