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.
How to Track Data Platform Service Level and Performance Before and After Consolidation?
Planning data platform consolidation? Track service level and performance before and after consolidation, so you know how well the planning worked.
How to Prevent Common SQL Server Performance Problems Efficiently With Smart Capacity Planning
Many SQL Server performance problems come from poor capacity planning: slow storage, low memory, CPU spikes. Smart capacity planning helps prevent them.
SQL SERVER – Fix Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’
SQL SERVER – Fix Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’
SQL SERVER – Error – Disallowing page allocations for database ‘DB’ due to insufficient memory in the resource pool
My SQL Server 2016 error log kept saying ‘Disallowing page allocations for database due to insufficient memory in the resource pool’. What it means and the fix.
SQL SERVER – Resource Governor and Database Mapping
At SQLPass, an attendee asked how InMemory databases use memory. I show how Resource Governor and database mapping let you bind a database to a resource pool.