February 15, 2008 at 11:37 am
Hey guys, first time poster here. I've got a web application that hits my database under a specific user that just hammers performance on the server. I'd like to limit the resources that user can take up while it does its duty without impacting other users. Is this possible in SQL 2000?
Thanks!
Deane
February 18, 2008 at 11:19 am
No, you need to wait for SQL2008 for a query governor.
First you need to determine if the queries need tuning (either by changing the query or adding/modifying indexes). If they are already tuned and they are for reporting purposes, you might want to have a copy of the database on a separate server and use that for the reports.
February 18, 2008 at 12:05 pm
Ahh, ok, so it's going to have to be done the hard way. That's what I thought. Thanks for your response!
March 8, 2010 at 7:09 am
What about SQL 2005? Is it possible here?
Kindest Regards,
David
** Obstacles are those frightening things that appear when we take our eyes off the goal. **
March 8, 2010 at 9:12 am
The resource governor was only introduced in SQL2008. You can limit resources to a degree in 2005 with processor affinity and server memory settings, but these only apply at the instance level - not the user. If it's only certain users that you are concerned with, you might be able to push them to a separate instance depending on how they login and how the database connection is established.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply