March 26, 2010 at 4:09 am
Morning chap,
I'm a server techie and I've recently moved to a small company that doesn't have the funding or need to employ a DBA.
So I'm rapidly learning SQL (reading books and I've been lurking on here and reading other excellent resources on the site) and actually really enjoy the learning and working with databases.
Anyway I've recently configured mail using Google's SMTP engine to send us alerts once back-up jobs are complete.
I have been also been trying to find what other functions I should monitor on our system and how. Rather than ask for individual support I'm wondering if you guys could point me at what to read or where to find what I should be monitoring and reporting on.
Thanks in advance,
Lee.
March 26, 2010 at 6:19 am
(a)You Create Daily Backup Information
Instance Name Hotbackup Starting Time Duration Media Backup(if any)
(b)OS Info
Average CPU Load
Max CPu Load
Total No of processes
Log verification for any errors/warnings
(C)Database Info
Database Status
Backup Verification
Database Growth
Cache Hit Ratio (shd be above 95%)
Any Locks or Dead Locks
Transactions
Temp Databse growth
Hope this helps you to start off.
March 26, 2010 at 6:48 am
I'm assuming you're using a lot of automatic settings, so your databases are probably on auto-grow. Nothing wrong with that, but now you need to monitor disk free space very closely because running out of room to grow a file causes problems.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 26, 2010 at 8:25 am
Chaps, thanks for the information so far it's appreciated.
Lee
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply