How to approach for issue: SQL server is running slow
We have few SQL servers 2005 running on Win 2003 VM. Often they run sluggish.
What would be troubleshooting steps that we should follow to get into some conclusions?
Mostly we reboot the server and things become fine. We loss quite a bit of business due to this. We want to put set to best practices in place so that we get the solutions without doing any reboot or atleast minimum reboots.
Microsoft SQL Server 2005Windows Server 2003Microsoft SQL Server