I have a SQL server 2005 instance installed on the server machine with two vm
Server Specification are *Processor:* Xeon Ram : 6GB OS: window server on vm ware
It is running asp.net application deployed on the IIS and sql server database instance . This application is used by around 500 users daily. after every 22 days the processors CPU Usage Reaches to 100% to 95% . and the most used process (in task manager) is the instance of the sql server that is taking the maximum(all) the processing of the processor. Ram is only used up to 3 - 4 GB
I executed the below task but of no use
- Recreated all the table indexes but of no use
- Restarted the sql server database engine instance but of no use
But when the server(machine) was restarted. The sql server was working fine and CPU Usage was back to normal.
WE DO NOT WANT TO RESTART THE SERVER MACHINE. is this possible to performance tune the sql server so that after 22 days it does not choke up the server processing or what can i do to avoid it.