Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to record system monitor data to SQLServer". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The steps for setting up are as follows:

1. Create a data source name (DSN) on the client

Click start, click Control Panel, and then double-click Administrative tools.

Double-click the data source (ODBC), click the system DSN tab, and then click add.

Double-click SQLServer, type a name for the DSN, and then type a description for the DSN.

Click the SQLServer computer where the database is located, and then click next.

Click WindowsNT Authentication for Network Login ID, and then click next.

Click to select the change default database as check box, click the SQL database you created to use as the system Monitor data repository, and then click next.

Click OK to accept the default settings, and then click finish.

Click the test data source. You will receive a message that the test has completed successfully.

Click OK, and then click OK again.

How to record system Monitor data to SQLServer

two。 Configure system Monitor to log to SQL

Click start, click run, type perfmon, and then press ENTER or click OK.

Double-click the performance logs and Alerts menu.

Right-click the counter log, and then click New Log Settings.

Type a name for the log, and then click OK.

Click add object to add the object you want to record, and then click add.

Enter the counters you want to monitor and click close.

Click the Log tab, click SQL Database in the Log File types section, and then click configure.

In the DSN box, click the DSN you want to connect to. If you want to rename the log group, type a new name in the log group name box. By default, the log group uses the name of the system log.

Click OK, and then click apply.

3. Give LogtoRunAs users the correct credentials

Click the General tab.

"in the run mode box, type the credentials of a user with the following permissions."

The correct permissions used to run system Monitor.

The correct permissions (create and read) to the SQL database.

With the above settings, we will be able to record the data in the system Monitor to the SQLServer database.

This is the end of "how to record system Monitor data to SQLServer". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.