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

  • 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.

  • 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.

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply