SQL server stops responding same time every day

[siituser]

I'm having a problem with my SQL server(SP3). Last week, it started to not respond and this has continued at around the same time every day. Task Manager shows the SQL server activity at 0. There are no logs in Enterprise Manager to show any problems. No issues in the Application or System logs on the server.

The server also runs a Coldfusion MX server - again, nothing in the logs. CF continues to be active in the Task Manager.

I'd really like any ideas as to what I might be to try or some monitoring I could run to find why this is happening.

 

[miq]

hi,
first check (at the time of sqlserver not responding) that enough system resources are available including cpu + memory and network.


secondly, try to change or adjust cpu and memory usage for sql server in server property dialog box. may also try to give high priority to sqlserver and see what happens.

Thirdly, their maybe some melicious code running or some sort of collision among sqlserver services or locking problem.

4th, it might be windows not properly configured or somehow jamming sqlserver.


B.R,
miq