Manage Workloads with Resource Governor in SQL Server 2014
Resource Governor is a mechanism built into SQL Server that helps you control resource utilization by different workloads. You can specify limits on CPU, memory and IO consumption for different applications or users. This feature allows you to better exploit server resources and also to provide more predictable performance. It can also serve as a powerful monitoring tool that allows you to monitor resource utilization for specific workloads.
This session will present Resource Governor from the ground up, including the new enhancements in SQL Server 2014. We will demonstrate how Resource Governor can be used to control resources and to monitor workloads in several use cases, such as a multitenancy environment and a single database serving multiple applications.
Sorry, there are no downloads available for this session.
Guy Glantser is the leader of the Israeli SQL Server user group and also the CEO of Madeira SQL Server Services. His career has been focused on SQL Server for the past 17 years, performing various database roles as either an on-site DBA, an external consultant or an instructor. Guy is involved in many activities in the SQL Server community. He occasionally speaks at community events, such as Tech-Ed, product launches and user groups around the world. He also co-hosts the Israeli SQL Server radio show.
The video is not available to view online.