Questions tagged [resource-governor]
The resource-governor tag has no summary.
37 questions
0
votes
0
answers
7
views
Do queries blocked by Resource Governor's GROUP_MAX_REQUESTS not consume threads?
Do queries blocked by Resource Governor's GROUP_MAX_REQUESTS not consume threads? My demo below seems to suggest so, but I find this impossible.
Take a fresh server (you really don't want these ...
- 1,398
1
vote
1
answer
20
views
How can I use Resource Governor purely as a monitoring tool?
It is clear that Resource Governor monitors how much work each group is doing. sys.dm_resource_governor_workload_groups makes this utterly obvious.
Suppose that:
I don't yet trust my ability to ...
- 1,398
1
vote
1
answer
21
views
What does the Dedicated Admin Connection offer that Resource Governor does not?
The Question
What resources does the Dedicated Admin Connection reserve that I cannot reserve myself with Resource Governor? If I were a genius with Resource Governor, could I turn the Remote DAC off ...
- 1,398
0
votes
1
answer
130
views
What does resource governor classify as CPU contention?
Suppose I have 8 CPUs, and therefore I will have 576 worker threads.
When multiple queries are executing, then each query can be assigned one or more threads. And each thread executes on a cpu.
On a ...
- 3,618
0
votes
1
answer
552
views
What properties are accessible in the resource governor classifier function?
I'm learning about the resource governor classifier function: https://learn.microsoft.com/en-us/sql/relational-databases/resource-governor/create-and-test-a-classifier-user-defined-function?view=sql-...
- 3,618
3
votes
1
answer
601
views
Resource Governor and Resource Pool CPU Utilization Configuration
I have been trying to understand more in-depth how the resource governor resource pool limits work in conjunction with multiple user defined pools.
I've been trying to follow along the table in this ...
- 164
0
votes
3
answers
936
views
Rollback a transaction using single thread/multi thread
Would it be possible to rollback a transaction using a single thread?
I tried to find an answer to this question, but I couldn't find one that provided references. I read about rollback mechanisms. ...
- 244
0
votes
0
answers
390
views
MSSQL Server Resource Governance alternative
I've been looking into solutions for managing CPU sharing over multiple apps accessing the same SQL server database engine.I found that Resource Governance is one perfect way for me to define those ...
- 185
1
vote
1
answer
1k
views
Best-practice use of Resource Governor in SQL Server 2017 [closed]
I am working on a server that houses both an OLTP workload and a data warehousing/reporting workload. The OLTP system requires sub-second (in the milliseconds) response time while the reporting ...
1
vote
1
answer
312
views
SQL Server Resource Pool and Workload Groups
Below is the scenario:
Scenario 1:
I got two workload groups assigned in the same resource pool with MAX CPU 20%. In the event of CPU bottleneck, the limit will come into effect with 10% each ...
- 13
5
votes
1
answer
662
views
Disabling Resource Governor in SQL Server
Should we restart SQL Server after disabling Resource Governor? What is the best practice?
Why I am asking this, because I am worried about the existing open sessions in SQL Server. Will their ...
0
votes
1
answer
1k
views
Using Resource Governor to limit query CPU usage for same user
I have a remote MS SQL Server and I have several types of queries.
I run some queries that are part of a low-latency production application, and need to ensure they get domne in a timely manner.
But ...
- 345
10
votes
2
answers
12k
views
Limit max CPU usage SQL SERVER with WSRM
I have a physical server running one instance of SQL Server.
I notice that quite often this server is running at 100% CPU usage.
My IT team is not happy about this, and suggested we reserve 2 of the ...
- 345
2
votes
1
answer
606
views
Using Resource Governor and allocate more memory to satisfy high Memory Grant request by queries?
On a SQL Server 2016 database server, I have few queries which are really slow and which ask for more memory (queries are not optimized). This is making the whole database slow as lots of users are ...
- 1,345
4
votes
2
answers
6k
views
Limiting the CPU/Memory utilization for a Query in SQL server 2008R2
We have an AD-HOC process from the application team which is fetching data from one of our heavily used OLTP databases in SQLserver to migrate the data into MongoDB.
During the performance measure we ...
- 2,230