Buffer Cache Hit Ratio for DB Engine
Buffer Cache Hit Ratio monitor for SQL Managed Instance
Percentage of pages that were found in the buffer pool without having to incur a read from disk.
Zero value indicates memory bottleneck - SQL Managed Instance cannot efficiently cache the data pages in memory; reads from disk are relatively high.
Increase available memory on the server.
Increase 'Max memory'.
Provide index optimization.
Name | Description | Default Value |
Alert Priority | Defines Alert Priority. | Normal |
Alert Severity | Defines Alert Severity. | Error |
Enabled | Enables or disables the workflow. | Yes |
Generates Alerts | Defines whether the workflow generates an Alert. | Yes |
Interval (seconds) | The recurring interval of time in seconds in which to run the workflow. | 300 |
Number of samples | Indicates how many times a measured value should breach a threshold before the state is changed. | 6 |
Synchronization Time | The synchronization time specified by using a 24-hour format. May be omitted. |
|
Threshold | The collected value will be compared against this parameter. | 0 |
Timeout (seconds) | Specifies the time the workflow is allowed to run before being closed and marked as failed. | 200 |
Timeout for database connection (seconds) | The workflow will fail and register an event, if it cannot access the database during the specified period. | 15 |
Target | Microsoft.Azure.ManagedInstance.DBEngine | ||
Parent Monitor | System.Health.PerformanceState | ||
Category | PerformanceHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.BufferCacheHitRatio | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.Azure.ManagedInstance.Monitor.DBEngine.BufferCacheHitRatio" Accessibility="Public" Enabled="true" Target="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine" ParentMonitorID="Health!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="Microsoft.Azure.ManagedInstance.MonitorType.DBEngine.BufferCacheHitRatio" ConfirmDelivery="false">
<Category>PerformanceHealth</Category>
<AlertSettings AlertMessage="Microsoft.Azure.ManagedInstance.Monitor.DBEngine.BufferCacheHitRatio.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/InstanceName$</AlertParameter1>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="Normal" MonitorTypeStateID="Normal" HealthState="Success"/>
<OperationalState ID="Error" MonitorTypeStateID="Error" HealthState="Error"/>
</OperationalStates>
<Configuration>
<InstanceName>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/InstanceName$</InstanceName>
<Tier>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/Tier$</Tier>
<HardwareGeneration>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/HardwareGeneration$</HardwareGeneration>
<ReadScaleOutReplicaType>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/ReadScaleOutReplicaType$</ReadScaleOutReplicaType>
<ConnectionString>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/ConnectionString$</ConnectionString>
<AuthType>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/AuthType$</AuthType>
<AuthorityDetails>$Target/Property[Type="MngdInstD!Microsoft.Azure.ManagedInstance.DBEngine"]/AuthorityDetails$</AuthorityDetails>
<IntervalSeconds>300</IntervalSeconds>
<SyncTime/>
<Threshold>0</Threshold>
<NumSamples>6</NumSamples>
<TimeoutSeconds>200</TimeoutSeconds>
<SqlTimeoutSeconds>15</SqlTimeoutSeconds>
<PerformanceCounterObject>SQLSERVER</PerformanceCounterObject>
</Configuration>
</UnitMonitor>