How To Log System Monitor Data to SQL Server in Windows XP (296222)

SUMMARY

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

The new functionality in System Monitor enables you to log data to a SQL 2000 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, 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 in a description for this DSN.
4. Click the SQL Server computer 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 database that you created to be 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, and then click OK again.

back to the top

How to Configure System Monitor to Log to SQL 2000 Server

1. Click Start, click Run, type perfmon, and then press ENTER or click OK.
2. Double-click the Performance Logs an Alerts menu.
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 Logs tab, click SQL Database in the Log File Type section, and then click Configure.
8. In the 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 the General tab.
2. In the Run As box, type the credentials of a user who has the following rights:
   • The correct rights to run System Monitor.
   • The correct rights to the SQL database (create and read).

back to the top