Questions tagged [performance-counters]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
65 views

SQL Server - Find Memory ALLOCATED vs. Memory ACTUALLY USED

I want to find average Memory USED per day. SQL server caches as much data as possible in RAM (Buffer Cache) - this is ALLOCATED RAM But how much of this data does it actually read subsequently - this ...
user avatar
  • 1,086
0 votes
1 answer
119 views

Perfmon Thread Count vs SQL Workers

We are trying to monitor SQL Worker Threads and in the past we used the following query: SELECT SUM(current_workers_count) as [Current worker thread] FROM sys.dm_os_schedulers We are now considering ...
user avatar
0 votes
1 answer
76 views

Get current execution metrics from sys.dm_exec_sessions

I've got a pretty complex batch processing procedure that takes hours to run on real data. I've found that some CPU and I/O counters are stored in the master.sys.dm_exec_sessions table, and so thought ...
user avatar
  • 289
1 vote
1 answer
236 views

Sum of all Memory Clerks and Total Server Memory (KB)

I am trying to understand the memory management of SQL Server. I have a Windows Server 2019 on virtual environment with 64 GB of RAM. I also have SQL Server 2019 installed with Max Server Memory 59776 ...
user avatar
  • 1,163
0 votes
1 answer
1k views

SQL Server Stolen Server Memory - what it consists of?

Below what my server's performance counters show: Questions: 1) What "Stolen Server Memory" consists of ? I can assume "Plan Cache", "Lock Memory", "SQL Cache", "Connection", "Optimizer" are ...
user avatar
1 vote
2 answers
335 views

How to query SQL Server Memory Manager performance counters in DMV?

Is there any system catalog views or DMVs that can be used to query (in SSMS for example) below performance counters from SQL Server:Memory Manager ? Free Memory (KB) Target Server Memory Total ...
user avatar