July 24, 2008 at 2:40 am
Hi all,
is there any tool that will monitor and generate daily report of my database servers about last database backup; database size and hd free space?
or atleaset please share ideas on how i can lessen my work load monitoring this servers.. i have 20-30 database server and has average of about 8-10 databases.
thanks,
July 24, 2008 at 7:49 pm
This is what I used for monitoring the servers
1. Data and Logs
DBCC SQLPERF(logspace) - For Logs
DBCC SHOWFILESTATS - For Data
2. Database Backups
You can use the data in msdb database, backupset table
3. HD Report
There are lots of scripts you can find here for this matter.
4. Multiple Server Monitoring
I used linked server to monitor multiple servers
I handle 45 (and counting) branch servers not to mention other production databases. This kind of monitoring helps me a lot. There are lots of ways you can do monitoring, different ways for different types of DBAs.
"-=Still Learning=-"
Lester Policarpio
July 24, 2008 at 10:31 pm
there are a few tools that can do this, however it's pretty simple to write this as mentioned above. Lots of scripts here on this site as well that can help you build your own reports. A small database will store all this stuff.
If you want, you can check out Quest Software and sqlSentry for some tools that might help if you want to buy something.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply