Don't laugh -- "The Sql Server is slow...."

Fingers88

I just got that statement from a user this morning. How would you use Sql Monitor to see if they are correct or not? (What counters would you look at first? Or maybe history... or...?)

Thanks,

Fingers

P.S It's sql 2008. SP3

Adam W

Hi,

Here are a couple of videos that walk through examples of using SQL Monitor to identify why servers might be running slow:

How to monitor SQL Server with wait statistics
SQL Monitor and deadlocks

I hope these are helpful.

Adam