Monitoring - Logging Performance Monitor Counters to SQL Server

SignalQ Sites:
NetAdminTools - Coprolite - NoNIC - SpotBridge - NAW
RoboCoop - AreWeDown - SolarPower - SysAdminTools
Xfig - Gold Loaf - GeekPapa - FixGMC - MCJ - FixRambler

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 3
Topic: Monitoring Posted:2007-03-01
Printer Friendly:

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

Click Test Data Source, and if all is happy, a window showing the results of the ODBC connectivity test will pop up:

Another summary of the ODBC connection:

Let's use our perfmon database. In performance monitor, create new counter log settings:

On the general tab, add counters and choose other settings:

We used administrator. This will work with other accounts, and you probably should do this. Now, one thing that you need to keep track of is on the database side, different tables are created based on user. Pass-through via local accounts does also appear to work. On the Log Files tab, select a SQL Database Log file type and click configure to set the prefix used in the table for the various log sets:

Next

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

Created by:

MCJ CMS