I want to create a new Data collector set to find out my Memory utilization in my PROD SQL Server for at least 2-3 weeks.
Can anyone let me know if this takes too much resource utilization which in turn reduces Performance.
Below are the performance counters I am planning to create as adviced :
Memory – Available M Bytes
SQL Server: Buffer Manager – Page Life Expectancy (Higher is good)
SQL Server: Memory Manager – Memory Grants Pending (Lower is good)
SQL Server: Buffer Manager, Buffer Cache Hit Ratio (higher is better)
SQL Server: Memory Manager – Target Server Memory
SQL Server: Memory Manager – Total Server Memory
SQL Server: SQL Statistics – Batch Requests/sec
SQL Server: SQL Statistics – Compilations/sec