Browse by Tags

All Tags » sql server » dmv » databases » dirty (RSS)
How to find dirty buffer pages and clear them - SQL Server
Published 21 May 7 10:22 AM | SSQA.net
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...
Filed under: , , , , , ,