Will turning on performance Monitor affect server performance?
On a production server, after running for a period of time, performance the resources consumed by monitor in the task Management
Cite the SQL Server 2012 implementation and management guidelines to explain my doubts:
The default performance monitor is used to real-time the detection system, and in real-world problem analysis, it is more necessary to turn on performance counter data collection before the problem occurs, after some time, or after the problem is reproduced, Analyze the phenomena and causes of problems offline by collecting data.
Some DBAs worry that grasping so many counter will not affect the performance of the server, according to experience, Performance Monitor the overall performance of the system is almost not felt, so you can confidently collect some counter, time interval selection default value 15s More secure.
Performance Monitor Usage6:side Effect