WORKAROUND 1:
Spotlight will scan SQL Server Error Logs of the monitored connection for specific targeted messages. If something is written to an error log concerning the paging file, you can configure error log entries to raise an alarm.
To set this up:
Thusly, you'll be alerted if Spotlight found the log related to paging from your logs.
WORKAROUND 2:
Setup a SQL Server custom counter to raise alarm:
SELECT virtual_address_space_committed_kb/1024 AS sql_VAS_committed_MB FROM sys.dm_os_process_memory;
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center