Monitoring - Logging Performance Monitor Counters to SQL Server

Categories:
·GNU/Linux
·Homebrew designs
·Perl
·Administration
·Backup/Recovery
·Bugs/Fixes
·Certification
·Database
·Email
·File/Print
·Hardware
·Information Grab Bag
·Interoperability
·GNU/Linux ABCs
·Monitoring
·Name Resolution
·Network Services
·Networking
·Remote Control
·Security
·Desktop
·Web
·BSD
·Solaris
·GIAGD
·REALbasic
·All Categories

Logging Performance Monitor Counters to SQL Server - Part 4
Topic: Monitoring Posted:2007-03-01
Printer Friendly:

There are 4 parts to this article:
Part 1 - Part 2 - Part 3 - Part 4

After you close out the settings, the counter log should be started. If not, then start it:

Add the counters from the database by clicking on the log icon from System Monitor and selecting the database via the System DSN we created earlier:

Add counters from the log set:

We can now monitor performance counters from a database:

Here is what the database structure looks like:

The real value of this is that multiple machines can point at the same database so that you can consolidate your counters in one place.

First

There are 4 parts to this article:
Part 1 - Part 2 - Part 3 - Part 4

Please read our Terms of Use
Microsoft, Windows, Windows XP, Windows 2003, Windows 2000, and NT are either trademarks or registered trademarks of Microsoft Corporation. NetAdminTools.com is not affiliated with Microsoft Corporation. Linux is a registered trademark of Linus Torvalds, and refers to the Linux kernel. The operating system of most distributions that contain the Linux kernel is GNU/Linux. All logos and trademarks in this site are property of their respective owner. Copyright 1997-2008 NetAdminTools.com