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