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

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).

взято тут

Дополнение. Еще полезная инфа