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

What are the things that we need to check when someone complaints that the system is slow ?. Expand / Collapse
Author
Message
Posted Saturday, August 10, 2013 10:47 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 1,538, Visits: 2,585
Hi All,

What are the things that we need to check when someone complaints that the system is slow ?. (Not an interview question) I understand that we need to run profiler to get a clear picture. But what are the other preliminary checks we can do ?

Thanks,
Smith.
Post #1483035
Posted Wednesday, August 14, 2013 2:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:04 AM
Points: 274, Visits: 1,468
Smith - if server is slow then we should go with below approach -
1) Check network latency
2) Check disk I/Os - can be checked with performance monitor toll in windows
3) Check CPU usage - can be checked with performance monitor toll in windows
4) Check memory usage - can be checked with performance monitor toll in windows

If it is related to any specific database -

we must at least check the below things
1) Blocking
2) Check processes using sys.sysprocesses
3) Check if any intensive query is running which can cause slowness for sometime until it finishes
4) Check if any database maintenance job is running

Let me know if you find something.
Post #1484133
Posted Thursday, August 15, 2013 3:05 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:59 AM
Points: 876, Visits: 2,419
Check what the user is actually calling "slow", and how often it's "slow".
Then check what the user considers "normal" for this process, and how often it's "normal".

Then start investigating, probably with the assistance of others in the cases where it looks like something outside of your area.
Post #1484924
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse