March 3, 2009 at 8:21 pm
Is it possible to set up Sql Server to utilize one processor for a purticular stored procedure and another processor for another stored procedure when executed parellelly in a dual processor machine? Pls let me know your feed back on how to do this or any alternative ways of doing this.
March 3, 2009 at 8:25 pm
The simple answer, no. You can't tell SQL Server which processor to use when a stored procedure is run.
March 4, 2009 at 6:38 am
Like Lynn says, you can't do it. SQL Server manages it's own sessions and threads and you can't direct them. If two processors are available and nothing but these two procs are running and neither of the procs is running under parallelism, SQL Server will likely use both processors available to it... assuming further that there are other processors available for the OS... Anyway, you don't really have any options in this area.
"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
March 4, 2009 at 2:24 pm
Well there are tricks that to can follow to try an use a separate UMS but is not worth the effort in the majority of the cases...
* Noel
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply