1

From last few days I am getting this error every morning.

When I check SQL service in service manager, its status is "Started", but when i restart it, the problem gets resolved.

This is happening every day. What can be reason?

Below is a screenshot of our disk space for Database server: enter image description here

Currently All new data files goes in H drive and log files goes in G drive.

RAM for database server is 120 GB. It has around 500 Content DBs.

  • Could be lots of things. Like is the memory to low on your db-server? Does it have enough disk space? Can you see SQL do dumps? – Robert Lindgren Aug 18 '15 at 6:37
  • check service account for sqlservice it expire or not and it can be for many reasons, tell what in event viewer – adilahmed Aug 18 '15 at 6:51
  • Hi adil, service account might be not an issue as same account is used on another server and there it is working properly. – P S Aug 18 '15 at 7:14
  • Event Viewer Shows only two error in that time span: Event ID 1, Source: SQLVDI and Event ID: 18056, Source: MSSQLSERVER – P S Aug 18 '15 at 7:18
  • Hi Robert: I have updated my Question with screenshot. SQL Don't give error once i restart. – P S Aug 18 '15 at 7:20
0

The issue got resolved after adding one more core to CPU. Seems that performance was the issue.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.