Question: What is Read Ahead Read in SQL Server?
Answer: This is SQL Server’s feature which brings data pages into the buffer cache.
SQL SERVER – Event ID: 2004 – Resource Exhaustion Diagnosis Events
Recently I was working with a client where they were having an issue with SQL Server memory usage. They received below warning message in System Event log – Resource Exhaustion Diagnosis Events.
What is Lock Pages In Memory? – Interview Question of the Week #186
Question: What is Lock Pages In Memory?
SQL SERVER – Script to Identify Memory Used By Each Database
During the last SQL Server Performance Tuning Practical Workshop, I was asked a very interesting question by an attendee. The question goes like if there is any script available which users can use and figure out if how much memory used by each of the databases. Fortunately, I was lucky that I have a script handy which exactly does the same task.
PowerShell – Get Maximum Memory of Server with dbatools
Yesterday I blogged about the very famous Powershell free community tool dbatools. After writing this blog post, I received some interesting emails. I think lots of people confused this with native PowerShell. Well, actually dbatools is build using PowerShell scripts and runs under the hood script of PowerShell. The biggest advantage of the PowerShell is that it helps us to do multiple operations like finding the maximum memory of the server.
SQL SERVER – Fix – Error – Property MemoryAllocatedToMemory OptimizedObjectsInKB is not available for Database. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
The other day when I was presenting my popular training SQL Server Performance Tuning Practical Workshop, during the demonstrations, I received following error. It was bit embarrassing for me as I was presenting in front of over 25 extremely smart DBAs and the error MemoryAllocatedToMemoryOptimizedObjectsInKB showed up on the screen.
How to List Queries With Memory Grant and Execution Plan? – Interview Question of the Week #154
Question: How to List Queries With Memory Grant and Execution Plan?