SQL Server Blog

I recently came across this message in the SQL Error Logs. This message indicates that another process, such as OS or another application on the database server is taking memory away from SQL Server.

Thankfully, finding the problem was a simple process for me (you may not be so lucky!). The error only occured out of hours and the times were relatively consistent. A quick call to the infrastructure team and I discovered they had turned on a replication process (HP StorageWorks Storage Mirroring) without letting me know. A quick rant and the process was disabled. I checked the logs the following morning and the errors had gone.
Read more…

I’ve seen a few posts about daily checks recently and thought I’d chip in.

What do I check and a very brief explanation why I perform this check.

Backups
- Have they all succeeded?
Disk Space
- Do we have plenty of space available for normal operations during business hours?
Database Size
- Have we seen a major increase in size (I monitor this because we manage client databases)
Read more…