SQL Server Performance Forum – Threads Archive
SQL Server Alright After Re-BootSQL 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.
And also take help from PROFILER for slow running queries and SYSMON (PERFMON) for H/w & SQL counters capture to assess the situation.
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
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard