Team,
I am facing a problem with one of the customer due to SQL server, utilization keeps on increasing and even if there is no transaction or query to DB the utilization is still high and doesn't reduce and once the utilization reaches to 90% to 95%. Server hung also the application is not able goes to freeze mode. It doesnt response untilll we restart the server. Please let me know is there fine tuning we need to do on SQL server.
Hardware Spec: Server is having 4 GB., CPU: 2,80 GHZ, Windows 2008 r2.