MS-SQL Server - Checkpoint, PLE, Scheduler, RMO Concepts & Always On

Checkpoint, PLE, Scheduler, RMO Concepts & Always On

Checkpoint

https://learn.microsoft.com/en-us/sql/relational-databases/logs/database-checkpoints-sql-server?view=sql-server-ver16

Page Life Expectancy

https://learn.microsoft.com/en-us/answers/questions/858593/page-life-expectancy-perfmonance-counter

Scheduler

https://learn.microsoft.com/en-us/sql/ssms/agent/schedule-a-job?view=sql-server-ver16

RMO Concepts https://learn.microsoft.com/en-us/sql/relational-databases/replication/concepts/replication-management-objects-concepts?view=sql-server-ver16

Always on Availability Group

https://techcommunity.microsoft.com/t5/itops-talk-blog/step-by-step-creating-a-sql-server-always-on-availability-group/ba-p/648772

OS Waittypes

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql?view=sql-server-ver16

Imp. Errors

Any query will be considered.

T. Amit Vaid S.