Browse by Tags

• blocking
• databases
• dirty
• dmv
• sql server

How to find dirty buffer pages and clear them - SQL Server
21 May 07 08:22 AM | SQL Master | 0 Comments   

Dirty buffer pages are nothing but consuming more memory for even smaller queries on the SQL Server. By default the DBA shouldn't worry about these dirty pages in the buffer pool as they are taken care by the system using Write Ahead Logging ( WAL )method. Read More...

Filed under: sql server, dmv, blocking, memory, databases, buffer, dirty