Question: How Much Memory is in Locked Pages? Answer: Before we see the answer to this question, I suggest you read the blog post here first.
SQL SERVER – Detecting Database Isolation Level MEMORY_OPTIMIZED_ ELEVATE_TO_SNAPSHOT
Customer reached out me with a very simple but very interesting question related to Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT.
How to List All Memory Optimized Tables in SQL Server? – Interview Question of the Week #227
Question: How to List All Memory Optimized Tables in SQL Server? We will see two different scripts here: One for Database and Second for Tables.
Dirty Pages – How to List Dirty Pages From Memory in SQL Server? – Interview Question of the Week #223
Question: How to List Dirty Pages From Memory in SQL Server? Answer: I received question today during my SQL Server Performance Tuning Practical Workshop.
SQL SERVER – Audit Script to Get CPU and Memory Information with MAXDOP Guidelines
If you are reading this blog regularly the name of Dominic Wirth may not be new for you. He has in the past sent some very interesting scripts for audit for our blog and I am including his new script in this blog which is about how to Get CPU and Memory Information with MAXDOP Guidelines.
How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server? – Interview Question of the Week #216
Question: How to Know When Memory Constraints are Negatively Impacting CPU in SQL Server?
What is Clean Buffer in DBCC DROPCLEANBUFFERS? – Interview Question of the Week #215
Question:Â What is Clean Buffer in DBCC DROPCLEANBUFFERS?