SQL Server Performance Forum – Threads Archive
SQL Server Alright After Re-Boot
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
]]>