Centralized SQL Server 2000 Monitoring

For doing trend analysis, you can query the data directly or export to Excel for charting, etc. I will leave this up to you as it’s often a matter of personal taste or specific work requirements how you analyze it or predict what’s going to happen in the future by extrapolating historical trends.

Summary Table Diagram

I have included this picture of a database diagram to illustrate how the tables used in these 2 schemes fit together.


The purpose of this article is to help you reduce time spent doing mundane, but highly important monitoring work as a DBA or system administrator. With a little work and initiative, you really can help yourself and your organization save time on routine tasks, and make your checking routines sleeker and more efficient.

Tom Pullen has been a DBA for 6 years. He currently works for Oxfam, a large UK charity. He has experience in SQL Server 6.5, 7.0 and 2000. He is married with two children. Contact him at: tpullen@oxfam.org.uk

Copyright 2005 by the author.

Pages: 1 2 3 4 5


No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |