Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL server performance troubleshoot using performance counters Expand / Collapse
Author
Message
Posted Saturday, April 06, 2013 1:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, February 22, 2014 6:35 AM
Points: 257, Visits: 1,678
I am having sql server 2008 r2 server. I saw that yesterday the server so slow. When i see performance counters some of the values are so high . So how to troubleshoot sql server performance according to the data below.I have taken the average value and maximum value of each counter for a day.


Post #1439548
Posted Tuesday, May 28, 2013 9:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 11, 2014 8:47 AM
Points: 7, Visits: 150
This is SQL Express, a free version. There are some limitations.
I see a manchine with 7 GB RAM available. Yet I get the idea SQL is not using a lot of it. Can you confirm? Is memory usage limited in any way?
Can you post the output of this statement?

SELECT * FROM sys.dm_os_wait_stats;

Post #1457399
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse