Think of a SQL Server instance that hosts a mission-critical OLTP application which runs smoothly. Running a poorly written ad-hoc query, ETL jobs, maintenance operations, or one noisy tenant in a multi-tenant environment may suddenly consume excessive CPU and memory resources, causing full workloads to slow down. What if you can classify the incoming requests and based on priority assign valuable resources (CPU and memory) accordingly. In today's article, we will explore how to accomplish this. Let's fasten your seat belt.
[More]