Daily/Weekly Checks - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Daily/Weekly Checks

Author

Topic

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2008-06-24 : 14:13:50

What daily/weekly checks do you guys currently perform on your servers and databases?

I recently ran across with an article from SQLServerCentral that listed a couple of daily checks that I'm thinking about implementing on my environment, and some of them are:
DB Missing Recent Backup - Report
DB Missing Recent Log Backup - Report
Drives Low on Disk Space - Report
Error Log Messages Report - Report
Instance Recently Restarted - Report
Job Failures - Report
Large Databases Log File - Report

I already have in place:
Verify is SQL Agent Service is running
Check Disk Space Available

Since I'm going to spend some time on this, I was wondering if there's anything else that you guys have in place or any other 'nice to have' that you guys also might have, so I don't leave anything behind...

Thanks!

---
http://www.ssisdude.blogspot.com/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-24 : 14:22:37

We don't produce reports for this type of stuff, rather we let MOM notify us when an exception occurs such as a failed job or disk space threshold passed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2008-06-24 : 14:38:12

We have MOM monitoring some stuff, but we still want to have something that we can look everyday to find any inconsistencies.

---
http://www.ssisdude.blogspot.com/

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2008-06-24 : 16:53:12

We just installed MOM, Interesting the Ops guys sent me this

Alert description: Operations Manager operational database percent free space is 11.49%. Ops DB Server Name: servername Ops DB
Name: SCOM

So i looked at my results:
USED FREE
1505.21 (60.21 %) 994.79 (39.79 %) = 2500.00

DATA 2000.00 (1462.31, 73.12%)
LOG 500.00 (42.90, 8.58%)

I cannot determine where this 11.49% would be referencing
I cannot determine where the 11.49 would come from ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-24 : 16:58:19

TRACEYSQL, check the MOM rule.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-24 : 17:17:28

That's correct, Will not see anything on the server level. Well we have differnet Monitoring Tools from 3rd party and setup the necessary counters and it alerts us when it pass out to the given threshold.

Manoj
MCP, MCTS

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources