After incorrectly setting max server memory to 14 MB instead of 145000, a client could not start SQL Server. Here is how we got it back online.
SQL SERVER – Brief Note About RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Type Resource
Today we will see Brief Note About RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Type resource. I wrote a blog post about Enable Lock Pages in Memory LPIM.
SQL SERVER – Enable Lock Pages in Memory LPIM
In this particular case, we had memory issue and after careful investigation, we found the troublemaker as a Lock Pages in Memory settings.
SQL SERVER – Query Specific Wait Statistics and Performance Tuning
After a quick research we figured out the issue was with memory requirement for their query and we used to query specific wait statistics.
SQL SERVER – Enable or Disable Resource Governor
Resource governor which was accidentally enabled by one of their database administrators. Let us learn how to disable resource governor in this blog post.
SQL SERVER – Using Memory-optimized Tables and Native Stored Procedures – Video Course
SQL Server Performance Tuning video course on Pluralsight on the topic – Using Memory optimized Tables and Native Stored Procedures.
Impact of DBCC DROPCLEANBUFFERS on Memory – SQL in Sixty Seconds #085
Based on the request of many DBAs, In this SQL in Sixty Seconds video, I will show you the Impact of DBCC DROPCLEANBUFFERS on Memory