CODEWITHSUNDEEP
sql-server-2008resources
Craig
Craig

Reputation: 1287

SQL Server 2008 Standard limit resource use per user or database

I need to limit the CPU time used by a single user on SQL Server 2008. Unfortunately this is for Standard Edition, so I can't use Resource Governor.

This user is running data-heavy queries via an Access database linked to one of the databases. This is causing high enough load on the server that other queries can timeout.

Is there any way to limit CPU usage by user or database in SQL Server 2008 Standard Edition, which is transparent to the queries being run?

What about on the connection from Access?

Upvotes: 0

Views: 4328

Answers (1)

Massimiliano Peluso
Massimiliano Peluso

Reputation: 26737

you could try looking at limiting the amount of cores used by affinity mapping or by the MAXDOP clause in queries if you want more granular control.

Bear in mind that Maxdop will restrict a query to use limited number processors but not the Usage of those processors.Affinity will also restrict the processors but not the usage . Only Resource governor can restrict the CPU usage

more info at :

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/9ed64e9a-0af0-4d4d-95e2-709dd9dc68d8/

Upvotes: 1

Related Questions