The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
19 views

Resource Governor on 2014 - CPU Not Being Throttled

We have a specific query ran from our platform that consumes a lot of CPU on a box that already has Enterprise, so Resource Governor seemed like a good solution. I'm working on configuring it on our ...
2
votes
1answer
34 views

Query Governor Cost Limit relationship with Time

Based on Technet, Query Governor Cost Limit refers to the estimated elapsed time, in seconds. This meets this excerpt from the Microsoft SQL Server 2008 Administrator's Pocket Consultant book. ...
1
vote
1answer
29 views

Troubleshooting Resource Governor / Classification Function [closed]

I've been trying to configure / troubleshoot the resource governor on a sql server 2014 instance. I can't get any work into anything but the default resource pool. I've been following this ...
1
vote
1answer
86 views

How to troubleshoot how resource governed query is being throttled in SQL 2012?

I have a parallelized query on SQL 2012 SP1 (ent) that is running in a user defined resource governor pool much much slower (2 seconds versus 125 to 140 seconds under user defined pool = ~75 times ...
1
vote
2answers
157 views

Assign maximum memory limit for a particular database in sql server

In my SQL-Server instance, there are many databases. I want to restrict the memory size of each database (for example 8 GB). When I tried using Resource Governor, there are options like ...
5
votes
2answers
2k views

Limit CPU usage without Resource Governor

We have an SQL Server 2008R2 Standard Edition with several databases belonging to different applications on a 16 core server. One recently introduced application is regularly executing expensive ...