How To Log System Monitor Data to SQL Server in Windows Server 2003 (323354)

SUMMARY

In Windows Server 2003, you can log data directly to a Microsoft SQL Server database. This article describes how to prepare a client computer to log data to a SQL Server database. This article does not describe how to set up and configure SQL Server or how to work with the data from SQL Server.

The new functionality in System Monitor permits you to log data to a SQL Server database by using an Open Database Connectivity (ODBC) data connection. However, this functionality is not an open ODBC adapter that you can use to log to any ODBC-compliant database.

back to the top

How to Create the Data Source Name (DSN) on the Client

1. Click Start, point to Settings, click Control Panel, and then double-click Administrative Tools.
2. Double-click Data Sources (ODBC), click the System DSN tab, and then click Add.
3. Double-click SQL Server, type a name for this DSN, and then type a description for this DSN.
4. Click the computer running SQL Server that the database resides on, and then click Next.
5. Click With Windows NT authentication using the Network Login ID, and then click Next.
6. Click to select the Change the Default Database to check box, click the SQL Server database that you created to function as the repository for the System Monitor data, and then click Next.
7. Click OK to accept the defaults, and then click Finish.
8. Click Test Data Source.
   
   You receive a "Tests completed successfully" message.
9. Click OK two times.

back to the top

How to Configure System Monitor to Log to SQL Server

1. Click Start, click Run, type perfmon, and then press ENTER or click OK.
2. Double-click Performance Logs and Alerts.
3. Right-click Counter Logs, and then click New Log Settings.
4. Type a name for this log, and then click OK.
5. Click Add Objects to add the objects that you want to log, and then click Add.
6. Enter the counters that you want to monitor, and then click Close.
7. Click the Log Files tab, click SQL Database in the Log file type list, and then click Configure.
8. In the System DSN box, click the DSN that you want to connect to. If you want to rename the logset, type a new name in the Logset name box.
   
   By default, the logset uses the name of the System log.
9. Click OK, and then click Apply.

back to the top

How to Give the Correct Credentials to the Log by Using the "Run As" Option

1. Click Start, click Run, type perfmon, and then press ENTER or click OK.
2. Double-click Performance Logs and Alerts.
3. Double-click Counter Logs, and then double-click the logset that you created.
4. Click the General tab.
5. In the Run As box, type the credentials of a user who has the following:
   • The correct rights to run System Monitor
   • The correct rights to the SQL Server database (create and read)

back to the top