I have an instance of SQL Server running on my Live DB server. Lately i started receiving alerts stating a high CPU usage fluctuating between 70-100 %. The task manager shows that the sqlserver.exe process seems to consume a lot of memory and also
the I\O Read Bytes keeps increasing endlessly.
Restarting the service does'nt help.
Could you please suggest.
Thanks in advance.
View Complete Post