SQL Server Performance

SQL Server Alright After Re-Boot

Discussion in 'Performance Tuning for Hardware Configurations' started by jyyoong, Jan 19, 2004.

  1. jyyoong New Member

    SQL server is slow but the read, write & processor times seems to be alright. I re-boot the SQL server and found that the performance of the server back to normal. Can anyone tell me what had happen.
    jyyoong, Jan 19, 2004
    #2

  2. Luis Martin Moderator

    Would you post:
    OS, SQL Version and SP?



    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
    Luis Martin, Jan 20, 2004
    #2

  3. satya Moderator

    And also take help from PROFILER for slow running queries and SYSMON (PERFMON) for H/w & SQL counters capture to assess the situation.


    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Feb 17, 2004
    #2

  4. gaurav_bindlish New Member

    quote:Originally posted by jyyoong

    SQL server is slow but the read, write & processor times seems to be alright.

    What do you mean by this statement?


    Also are you doing too many TempDB / cursor / temp tables operations?

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    gaurav_bindlish, Feb 27, 2004
    #2

Share This Page