We have a Windows SQL Server: Intel Xeon E3-1240 Quad Core, 8GB RAM, 500GB 7200 RPM SATA hard drive.
The Server becomes unresponsive once every 2-3 days. But nothing "unusual" shows up in Windows logs. We even set up Performance Monitoring Scripts: but our resource usage is no more than 10%.
Is there any way we can check out from the Server on what is bringing it down?
Sometimes, when we approve outgoing email alerts, which go to some 1200 people via mailenable installed on the Server, the Server becomes unresponsive. But the server of this capacity should be able to handle these emails. Is there something which we are overlooking?