Max Query Cost per User?

Question

Max Query Cost per User?

aaa121

SSCertifiable

Points: 5902
More actions
February 2, 2012 at 6:11 am

#263900

I know you can set it at a server level but does anyone know if it is possible to restrict certain user queries by maximum query cost?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398911 More actions · Answer 1

Have you taken a look at the Resource Governor?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

aaa121 SSCertifiable Points: 5902 More actions · Answer 2

Yes, I currently have this set up. I guess I'll just look at changing the existing classifier function to cater for the users/groups I am interested in

Paul White SSC Guru Points: 150468 More actions · Answer 3

aaa-322853 (2/2/2012)
I know you can set it at a server level but does anyone know if it is possible to restrict certain user queries by maximum query cost?

Resource Governor does give you quite a bit of control, and it's certainly much, much better than the old query governor cost limit option and the per-connection SET QUERY_GOVERNOR_COST_LIMIT.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

johnitech.itech Hall of Fame Points: 3252 More actions · Answer 4

ok check below link pls

http://stackoverflow.com/questions/71022/sql-max-of-multiple-columns

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

johnitech.itech (2/6/2012)

ok check below link pls

http://stackoverflow.com/questions/71022/sql-max-of-multiple-columns%5B/quote%5D

What exactly does the link have to do with the question? The question is about restricting query costs, the link is about finding the max of multiple columns. About the only similarity I could see is that the word 'max' appears in both.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Paul White SSC Guru Points: 150468 More actions · Answer 6

GilaMonster (2/6/2012)

johnitech.itech (2/6/2012)
ok check below link pls
http://stackoverflow.com/questions/71022/sql-max-of-multiple-columns%5B/quote%5D
What exactly does the link have to do with the question? The question is about restricting query costs, the link is about finding the max of multiple columns. About the only similarity I could see is that the word 'max' appears in both.

This is hilarious: it is the first Google match for the stack overflow site and the title of the thread...:

site:stackoverflow.com Max Query Cost per User?

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi