Shulou(Shulou.com)06/02 Report--

After installing the client, I intend to monitor the performance counters on the sql server side, mainly monitoring the counters related to windows. The online writing is not detailed enough, as a beginner, I still found more information, and finally the test was successful.

First, to find the counter, you can execute it on the command line:

[plain] view plain copy

Typeperf-Q > D:\ counters.txt

You are now ready to monitor the following values:

[plain] view plain copy

\ SQLServer:Buffer Manager\ Buffer cache hit ratio

\ SQLServer:Buffer Manager\ Checkpoint pages/sec

\ SQLServer:Buffer Manager\ Lazy writes/sec

\ SQLServer:Buffer Manager\ Page life expectancy

\ SQLServer:Memory Manager\ Target Server Memory (KB)

\ SQLServer:Memory Manager\ Total Server Memory (KB)

\ Memory\ Available MBytes

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.