How to find Dirty Pages ? How Checkpoint working | SQL Server Checkpoint Behavior and Functionality

Hi Mate,
Welcome to my channel Tech & Art.

**STAY HEALTHY AND KEEP LEARNING***
***ALWAYS HAPPY AND CONNECTED ***

N/B:-- Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion.

In this session we are going to discuss about How to find Dirty Pages ? How Checkpoint working | SQL Server Checkpoint Behavior and Functionality

Stay tuned by clicking the subscribe button and clicking on bell icon for future notifications. Thanks 🙏
***********************************************************
****
QUERY:-
SELECT

DB_NAME(DM_OS_BUFFER_DESCRIPTORS.DATABASE_ID) DatabaseName,

Count(*) AS [Total Pages In Buffer],

count(*) * 8 / 1024 as [buffer size in MB],

when 1 then 1 else 0

End) as [Dirty Pages],

when 1 then 0 else 1

End) as [Clean Pages],

when 1 then 1 else 0

End) * 8 / 1024 as [Dirty Page (MB)],

when 1 then 0 else 1

End) * 8 / 1024 as [Clean Page (MB)]

order by [total pages in buffer] desc;

****

SQL ARCHITECTURE:-

SQL SELECT STATEMENT:-

SQL DML STATEMENTS PROCESSING:-

SQL AAG

Linked server

SQL MIRRORING

SQL REPLICATION

SQL LOGSHIPING

ORACLE INSTANCE AND DATABASE:-

ORACLE INSTANCE STARTUP SEQUENCE

ORACLE INSTANCE SHUTDOWN SEQUENCE:-

SQL SERVER BACKUP/RESTORE:-

SQL, SQL DATABASE, SQL BACKUP, RESTORE, RECOVERY, USERS, LOGINS, AGENT, SQL JOBS, SQL ARCHITECTURE, SQL INSTANCE, SQL UPGRADE, SQL PATCHING, SQL PERFORMANCE, SQL MANITINEMANC, SQL SLOWNESS, SQL HARDWARE, SQL LIFE CYCLE, SQL DR, SQL MIRRORING, SQL REPLICATION SQL ALWAYS ON, SQL LOGSHIPING, SQL CLUSTERING, SQL INSTALLATION, SQL MIGRATION, SQL TO AZURE,CLOUDE,AZURE,AMAZON,GOOGLE, SQL TO AWS,AWS,SQL MIGRATION TO CLOUDE,AZURE FUNDAMENTAL, AZURE CERTIFICATION, AZURE ARCHITECTURE, SQL ON LINUX, SQL LINIX INSTALLATION, SQL PERFORMANCE QUERY, SQL BLOCKING,SQL DEADLOCK,SQL DATABASE CRASHED, SQL DATABASE DOWN,SQL SERVICES , SQL SERVICES STOP, SQL INSTALLATION FAILED, SQL UPGRADE FAILED,

#sqlserver #sqlserverdba #techandart

[shubhamsarote]

Thanks alot for such a informative video. Waiting for more such conceptual videos

[arunkumarramagiri]

Sir, I have doubt we are checking dirty pages frequently ? and use the check point to remove dirty pages in real time work ..plz tell me

[sagarkashid]

When to use Checkpoint and how frequently use checkpoint.