Link to home
Start Free TrialLog in
Avatar of Alan Dala
Alan Dala

asked on

Limit application access to SQL server

I have a SQL server that hosts databases for multiple applications across the network. Some of the databases are related to SCCM 2012. This is the one that utilizes the SQL server the most. Is there a way to limit CPU usage for that specific database access? To be more clear, I want to make sure that the SCCM 2012 application doesn't take more than the fair share of the SQL server's CPU. I know you can manipulate it to some degree with the WSRM feature but all I can see over there is to control the entire sqlservr.exe process. I don't see any processes related specifically to SCCM


Thank you!
SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial