Correlating IO Wait with Queries

Have you ever looked at sys.dm_os_virtual_file_stats and saw horrible latency for your database files? Generally speaking, you want to see latency below 20 ms on your database files.  much above that and there are some problems somewhere that need some tuning. But, how do you know what queries are causing your issue? What’s causing those … Continue reading Correlating IO Wait with Queries

Finding Failed Jobs

How would you go about finding jobs that have failed and why would you want to look for these?  You might want to do this to ensure that you are being notified appropriately of job failures. For instance, after reviewing failed jobs, you may realize that there are job failures that no one knew about. … Continue reading Finding Failed Jobs

Retiring sp_who and sp_who2

  Sp_who and sp_who2 have been some very popular T-SQL commands. What if I told you that you could get more and better information from DMVs that have been around since SQL Server 2005? With the advent of SQL Server 2005 came along new objects called Dynamic Management Views, also known as DMVs. One of … Continue reading Retiring sp_who and sp_who2

>