August 2, 2013 at 11:55 am
Hi guys,
For the last 4 days I've been working on setting up SQL Server monitoring jobs & passing the values to Oracle for them to be displayed on the Intranet. The result is as follows:
http://www.pasteall.org/pic/show.php?id=56700
I have this for the 13 databases so far as well as drill down pages (full growth history graph instead of most recent 5; all jobs & backups collected etc).
My next table I plan to include is an Alerts/Issues table containing things that may need to be looked at. Some ideas I have are:
- TLog > n% of the database
- No backup in n days
- db is in bulk_logged
- db is in full but no tlog backup for n days (we had one unknowingly in Full then a 120gb tlog for a 1.5gb db)
I can't remember if I jotted down more on my paper at work. Does anybody else have ideas of what could be included? My jobs currently run hourly (recent changes), daily (backup, job & file info) & weekly (the db size, it will be weekly soon at least).
Anyone have any other ideas of things that could be monitored? I plan to add more sp_config values for the top table (server info) and probably collect some stats like buffer cache hit ratio maybe which could be graphed.
Any ideas welcome 🙂
August 2, 2013 at 12:44 pm
Depending on the type of database, you should probably be monitoring Deadlocks, I/O Wait, CPU Usage, index fragmentation, etc. There are tons of things that you can monitor, it all depends on the database.
August 2, 2013 at 4:46 pm
We only tend to have locking issues on the one database so I don't see much urgency for this being used (rather than going to the server).
Will take a look into indexes ;o
August 6, 2013 at 3:13 pm
Do people monitor the transactions/sec counter? If so do you tend to do it as per second count or longer?
I'm currently thinking of taking it & doing transactions/min since I'll do collections every 10/15 minutes so even with t/m I would need 15 transactions to take place just to get a value of 1...and since I was planning on storing the value in small/tinyint anything below that would just appear as 0 :f
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply