MS-SQL Server - Amoraemon

Amoraemon

Well "Amorae" Monitoring in regards to SQL Server is nothing but ...

A - Always on Availability Groups

M - Memory

O - OS Perf

R - Resource

A - Active Connections

E - Extended Events

Additionally,

Log Space Monitoring

DBCC SQLPERF

https://share.google/35AAPt7KxtzplGY5w

Monitoring Page Splits

https://learn.microsoft.com/en-us/answers/questions/646652/sql-high-rate-page-split

Dormant Sessions Monitoring

sys.sysprocesses  

https://learn.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-sysprocesses-transact-sql?view=sql-server-ver17

sys.dm_exec_sessions https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-sessions-transact-sql?view=sql-server-ver17

T. Amit Vaid S.