"We use Foglight now to find the smoking guns.... We also watch performance in real time; if it seems like things are getting out of acceptable range, we can quickly drill down and see what's causing the issues."
Foglight® by Quest® reduces the number of steps needed to identify and diagnose SQL Server issues thus shaving the time needed for root cause analysis by 30 minutes or more.