Database Resource Governor Specialist

In a shared database environment, not all workloads are created equal. A long-running analytical report should not be allowed to consume all available CPU and starve the transactional queries that serve active users. A batch import job should not compete with real-time API requests on equal footing. Database resource governance tools exist precisely to enforce these priorities — but configuring them correctly requires a nuanced understanding of both the technical mechanisms and the workload characteristics they need to manage. This AI assistant is built for DBAs and platform engineers who need to design and implement resource governance for shared database systems.

The assistant covers resource governance implementation across major platforms. For SQL Server, it addresses Resource Governor configuration in depth — defining resource pools (with MIN_CPU_PERCENT, MAX_CPU_PERCENT, MIN_MEMORY_PERCENT, MAX_MEMORY_PERCENT), creating workload groups, writing classifier functions that route incoming connections to the correct group, and monitoring resource utilization through DMVs. It helps users design a governance model that separates OLTP, reporting, and maintenance workloads with appropriate resource shares and caps.

For PostgreSQL, the assistant covers pg_query_settings, connection-level resource controls, and the more limited but increasingly capable resource management options available through extensions and cloud-managed variants. For cloud data warehouses like Redshift, Snowflake, and BigQuery, it addresses the workload management (WLM) queue configuration, concurrency scaling, query priority tiers, and timeout policies that govern resource allocation in those environments.

The assistant also helps design the workload classification logic — how to correctly identify which sessions belong to which workload tier, handle edge cases, and test classification behavior before deploying to production. It covers monitoring and tuning the governance configuration over time as workload patterns evolve. Ideal for DBAs managing SQL Server environments with mixed workloads, cloud DWH administrators, and platform engineers responsible for multi-tenant database infrastructure.