This script will query across all databases, returning a result of objects recently created or modified.  Read more...

A lively comparison of Pascal's triangle to root cause analysis from David Poole.  Read more...

When healing a sick SQL Server, you must forget the idea that there could ever be a simple correspondence between symptom and disease: The art of troubleshooting is much more the art of discovering, and assembling, the various pieces of the puzzle so that you have a complete understanding of what is going on inside of a server.  Read more...

You can save a lot of time by using the SSIS Troubleshooting tools. These enable you to work with reduced data samples, monitor row counts, use data viewers, configure error-handling and monitoring package execution. Although you can develop SSIS packages without them, it is so much easier once you're familiar with these tools.  Read more...

A compatibility view for DBAs used to using sp_who2  Read more...

This script will email info about the longest running SPID in an HTML formatted table  Read more...

In the second part of the Resource Monitor series we conclude with a look using the Memory tab and Disk tab to diagnose performance issues.  Read more...

Windows Resource Monitor can be a very useful tool for initial diagnosis of performance issues. In this two part series we look at how to troubleshoot performance issues using Resource Monitor.  Read more...

Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.  Read more...

After seeing several cases in the past couple of months where I felt the basics of troubleshooting were violated, I...  Read more...

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...

SQLDIAG or PSSDIAG are excellent tools used to collect and analyze data in order to identify possible performance root causes. The issue is that the output produced by such utilities is sometimes convoluted, hard to read and hard to understand. In this tip, I will show you a tool that you can use to read and analyze the data collected by these tools.  Read more...

Returns records with errors from the default trace ordered by most recent first  Read more...

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...

Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.  Read more...

When diagnosing issues in SQL Server I've found that sometimes I need to be able to mimic a user's session state when attempting to repeat an error they may be receiving. The smallest differences can completely change the outcome, so I need to ensure all the session settings (QUOTED_IDENTIFIER, ANSI_NULLS, and so forth) are identical between the production session and my test session. Is there an easy way to determine these settings with a single query?  Read more...

This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.  Read more...

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.  Read more...

New author Mike Walsh brings us an interesting analogy on troubleshooting skills that might get you to think differently about how you attack problems.  Read more...

Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.  Read more...