• Management Pack:  SQL Server 2012
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

Stolen Server Memory Monitor

  • ID:  Microsoft.SQLServer.2012.DBEngine.StolenServerMemoryMonitor
  • Description:  Stolen Server Memory for 2012 DB Engine
  • Target:  SQL Server 2012 DB Engine
  • Enabled:  Yes

Operational States

Name State Description
DB Engine Stolen Server Memory is ok Success DB Engine Stolen Server Memory is ok
DB Engine Stolen Server Memory is too high Error DB Engine Stolen Server Memory is too high

Overridable Parameters

Parameter Name Default Value Description Override
Interval (seconds) 300 The recurring interval of time in seconds in which to run the workflow.
Timeout (seconds) 200 Specifies the time the workflow is allowed to run before being closed and marked as failed.
Threshold 70 If the ratio between Stolen Server Memory and SQL Server max memory is greater than this threshold alert will be generated
Number of samples 6 Number of samples to average before compare it with threshold
Synchronization Time   The synchronization time specified by using a 24-hour format. May be omitted.

Alert Details

Monitor State Message Priority Severity Auto Resolution
DB Engine Stolen Server Memory is too high (Error) SQL DB 2012 Engine Stolen Server Memory is too high Medium Critical Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

Stolen Server Memory monitor for SQL 2012 DB Engine

Monitors amount of memory the server is currently using for the purposes other than the database pages.

Causes
  • Invalid memory configuration

  • SQL Server memory pressure outside of the buffer pool.

Resolutions

SQL Server memory pressure external to the buffer pool can be caused by many things, run DBCC MemoryStatus or query sys.dm_os_memory_clerks to identify the problem.

An in-depth look at SQL Server Memory

http://go.microsoft.com/fwlink/?LinkId=789185

External References
This monitor does not contain any external references.

See Also for SQL Server 2012 Management Pack


Downloads for SQL Server 2012 Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED