Stack Overflow
Stack Overflow

Questions tagged [resource-governor]

18 questions
9
votes
8 answers

SOA Governance Explained

Does anybody have an idea what SOA Governance is all about? What is the difference (or correlation) between SOA Governance and IT Governance? and How can it be applied using SOA platforms available in the market? Can a project built on SOA platform…
whiz
  • 1,063
  • 2
  • 11
  • 19
3
votes
1 answer

Does SQL Resource Governor re-allocate resources during execution of a query?

Say, I have two users (U1, U2) mapped to two resource pools (R1, R2) and with max values as 20% and 80%. U1 executes a time consuming query that runs for say 15 minutes. When it started execution it was the only process and hence SQL server…
Faiz
  • 5,331
  • 10
  • 45
  • 57
2
votes
1 answer

cpufreq governors : schedutil missing

In my linux machine, only only performance and powersave are avaliable. How I can enable schedutil? available cpufreq governors: performance, powersave
2017561-1
  • 149
  • 6
2
votes
1 answer

Alternative to SQL Server Resource Governor

I have a Report Server that runs SSRS 2008 R2 Standard. This server retrieves data from another SQL Server 2008 R2 (Standard again). I want to manage the query priority on these SQL Standard servers, in a manner similar to Resource…
CLU
  • 249
  • 2
  • 6
2
votes
1 answer

Error!: SQLSTATE[42000] [1226] ‘max_user_connections’ resource (current value: 30), but max_user_connections is configured to 1000

Visitors get a Mysql error when a mysql user has exceeded the max_user_connections, returning the current value as 30, but max_connections and max_user_connections are set to 1000. When the problem occurs, the CPU reaches almost 98 %. On mysql…
nandoC
  • 119
  • 3
  • 11
1
vote
0 answers

suspect database due to in-memory tables and resource governor(?)

Last night, both nodes on our Alwayson AG cluster went down at the same time. After a restart, only databases containing in-memory tables were marked as suspect. In the errorlog I see this message: (fragment) 2022-02-03 02:20:12.480 Resource…
Wilfred van Dijk
  • 89
  • 4
1
vote
0 answers

Can I change SQL Server resource pool settings at any time?

I have set up a custom resource pool TestResourcePool with the following values: MIN_CPU_PERCENT=50, MAX_CPU_PERCENT=80, CAP_CPU_PERCENT=100, MIN_MEMORY_PERCENT=0, MAX_MEMORY_PERCENT=100, MIN_IOPS_PER_VOLUME=500, MAX_IOPS_PER_VOLUME=2000…
SaranyaS
  • 11
  • 2
1
vote
2 answers

Prioritizing I/O for a specific query request in SQL server

Sorry for the long introduction but before I can ask my question, I think giving the background would help understanding our problem much better. We are using sql server 2008 for our web services as the backend and from time to time it takes too…
Ferhat
  • 63
  • 6
1
vote
1 answer

Resource Governor is not running correctly

I am using Resource Governor on my production database for restriction to maximum CPU usage. But it couldnt work efficiently. I am using same structure on different servers and it work correctly. Only difference between servers is CPU count. My OS…
user4547775
1
vote
1 answer

SQL Server Resource Governor on Single Database

I have a database for a piece of proprietary software that resides on a SQL Server 2005 instance shared with some databases for C# apps I developed. I'm having an issue with some of the proprietary software's stored procedures eating up resources.…
Beans
  • 329
  • 4
  • 16
1
vote
1 answer

Tracing or Logging Resource Governor classification function behavior in Sql Server 2008

I'm trying to use the Resource Governor in SQL Server 2008 but I find it hard to debug the classification function and figure out what the input variables will have, i.e. does SUSER_NAME() contain the domain name? What does the APP_NAME() string…
nganju
  • 720
  • 6
  • 16
1
vote
2 answers

Prevent SQL queries from unprivileged users from blocking critical processes

I have a system that allows users to log in and construct queries to run against a SQL 2012 server. The system needs to be pretty liberal in what queries it allows, so I'm just relying on SQL grants to prevent users from doing things they aren't…
p.s.w.g
  • 146,324
  • 30
  • 291
  • 331
0
votes
1 answer

SQL Server internal/default resource pool increasing over time

Problem I have an SQL Server 2017 database deployed on a customer VM with a single database installed. The database has a single web application that connects to it with around 100 active users at peak times. For the past few months the customer has…
Luke Langford
  • 164
  • 5
0
votes
1 answer

Prevent Machine Learning Services (R) on SQL Server taking up high levels of CPU

I have had Machine Learning Service installed on SQL Server to be able to run R scripts (called from Stored Procedures). There are now several of these Stored Procedures as part of a script to populate date into Power BI. Because we run these…
Brisbane Pom
  • 521
  • 7
  • 18
0
votes
0 answers

Is it possible to limit resources of SQL WITHIN query/connection at runtime?

Is it possible to limit the resources used NOT with Resource Governor, but with the C# connection statement, or the query itself. It would be nice to control resources at runtime. All web searches/ documention I have found so far points me to the…
ManInMoon
  • 6,795
  • 15
  • 70
  • 133
1
2