Amazon Relational Database Service (Amazon RDS) for SQL Server now supports resource governor, a Microsoft SQL Server feature that enables customers to optimize database performance by managing how different workloads consume compute resources. Customers can use resource governor on RDS for SQL Server Enterprise Edition database instances to prevent resource-intensive queries from impacting critical workloads, implement predictable performance in multi-tenant environments, and efficiently manage resource allocation during peak usage periods.
RDS for SQL Server provides stored procedures that allow customers to implement resource governor configurations such as resource pools, workload groups, and classifier functions. Using these features, customers can allocate and control CPU, memory, and I/O resources for different database workloads within a single RDS for SQL Server instance. For more information about configuring and using resource governor, refer to the Amazon RDS for SQL Server User Guide. Resource governor is available with SQL Server Enterprise Edition in all AWS Regions where Amazon RDS for SQL Server is available.
Categories: general:products/aws-govcloud-us,general:products/amazon-rds-for-sql-server,marketing:marchitecture/databases
Source: Amazon Web Services
Latest Posts
- Durable Objects, Workers – New Asia-Pacific location hints: apac-ne and apac-se
- Durable Objects – Outbound connections keep Durable Objects alive
- (Updated) Upcoming change: Microsoft 365 Apps SAEC and MEC will unify [MC1274325]
- Dynamics 365 Customer Service – Policy strictness control for governance rules [MC1397526]
![Power Platform admin center – Manage agent security with enhanced admin controls [MC1188903]](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-pixabay-106144-150x150.webp "Power Platform admin center - Manage agent security with enhanced admin controls [MC1188903] 6")
