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

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

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

Postby Fingers88 » Tue Apr 01, 2014 6:48 pm

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
Fingers88
 
Posts: 3
Joined: Tue Dec 17, 2013 6:39 pm

Postby Adam » Wed Apr 02, 2014 9:09 am

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
Adam
 
Posts: 24
Joined: Tue May 27, 2008 1:40 pm
Location: Cambridge, England


Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests