By using Resource Governor we can manage SQL Server workload and system resource consumption. It enables us to specify limits on the amount of CPU, I/O, and memory that incoming application requests can use.
In this session, we'll take a look at how it does that using various classifiers and how to use it to our advantage.
Mladen Prajdić is a Data Platform MVP from Slovenia. He's been programming for 20 years, developing different types of applications in .Net (C#), SQL Server, and Swift, ranging from standard line-of-business image-processing applications to high-performance and IoT applications. He's a regular speaker at various conferences and user group meetings and really likes optimizing slow SQL statements, analyzing performance, and finding unconventional solutions to complex SQL Server problems. In his free time, he also develops a very popular add-in for SSMS, called the SSMS Tools Pack (www.ssmstoolspack.com).
