What are the things that we need to check when someone complaints that the system is slow ?.

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  August 10, 2013 at 10:47 am

  #395274

  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.

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  August 14, 2013 at 2:40 am

  #1641255

  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.

• Nadrek

  SSC-Insane

  Points: 20039

  More actions

  August 15, 2013 at 3:05 pm

  #1641934

  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.