I am looking for some advise on SQL Server troubleshooting....
Basically I have SQL Server 2005 on a windows 2003 server. We have a customised program which is developed in .NET and uses .NET framework on this server. We also have 3 other SQL database servers on this server.
The issue is that the server is peaking at 100% CPU usage intermittantley. I get an alert from VMware and the applciation itself often displays a timeout error, however it does not indicate what request caused the timeout. I know its within the SQL database but how do i find out which application or which specific request is causing it to peak?
I need to be able to determine which transaction and system is causing the SQL Server to peak at 100%.
Also, what are the limitations on running several SQL databases on one Server? We have 4 different databases, 3 of the applications are on the server and the fourth application is on a seperate server.