Question : I’ve googled this and so far, no luck so turning to all you awesome gurus for help. I’m […]
Tag: perfmon
SQL Server PerfMon: Compilations/sec > Batch Requests/sec
Question : I’ve been looking at various PerfMon metrics on one of our client’s SQL Server instances trying to get […]
How to measure Key Lookups per Second on SQL Server
Question : I am working on reducing the amount of transactions doing key lookups on our SQL Servers. First I […]
How to measure Key Lookups per Second on SQL Server
Question : I am working on reducing the amount of transactions doing key lookups on our SQL Servers. First I […]
Whether `SQL Server: Memory Manager: Target Server Memory (KB)` is ideal amount of memory based on recent workload OR the max memory setting?
Question : Link: https://docs.microsoft.com/en-us/sql/relational-databases/performance-monitor/monitor-memory-usage?view=sql-server-ver15 SQL Server: Memory Manager: Target Server Memory (KB) This counter indicates an ideal amount of memory […]
What does 0 memory grants pending, but low PLE, high lazy writes/sec and free list stalls/sec indicate?
Question : My server memory is 100GB, of which 90GB is allocated to SQL server via the max memory setting. […]
Why “Data File(s) Used Size (KB)” PerfMon counter doesn’t exist?
Question : I wanted to create my own SQL Server baseline by collecting data with the Performance Monitor. Among all […]
SQL Server – comparing PageSplits/sec with Batch Requests/Sec
Question : I read here (http://www.databasejournal.com/features/mssql/article.php/3932406/Top-10-SQL-Server-Counters-for-Monitoring-SQL-Server-Performance.htm) that having a high value of PageSplits/sec compared with that of BatchRequests/sec (in the […]
What perfmon metric will help me to monitor whether the SQL server memory is under pressure and resulting in usage of page file on disk?
Question : SQL server is assigned 110GB memory. It is consuming the entire memory. I want to understand whether there […]
Why is total and target server memory never reaching the configured memory value?
Question : I have sql server with 100GB ram, of which 90GB is allocated to sql server. 2 GB is […]