SQL Server: When DBCC DROPCLEANBUFFERS fails, script to find dirty pages from Memory
In this post, I am sharing a script to check dirty pages or clean pages in SQL Server Memory area. Most of the DBAs know about DBCC DROPCLEANBUFFERS which clear the data or pages from the memory area. We need to execute DBCC DROPCLEANBUFFERS while testing the performance of queries. First time when you execute […]
About Me!
