October 20, 2009 at 1:09 pm
Hello everybody,
I have a question for you,
Is it possible to set priority to stored procedures in SQL Server
2005.
For example we have 2 stored procedures. SP1 and SP2.
I want to set high priority to SP1 and low priority to SP2.
When only Stored Procedure?
I have a sql server 2005 system but if you know a way in sql server 2008 it's seem.
(I want know a way for resolving my problem)
thank you in advancing.
October 20, 2009 at 1:50 pm
No way I know of to do that in 2005. Might be able to use the resource governor in 2008 for that, not sure.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 21, 2009 at 2:28 am
Many thank!
I have seen this way with sql server 2008, but wanted (hope) that I found a way also with 2005.
So,
Again thanks.
Cecco.
October 22, 2009 at 9:19 am
Note that you must have the (very expensive) Enterprise Edition of SQL Server 2008 to use the Resource Governor.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply