April 28, 2009 at 3:51 am
Hi,
How can I achieve/implement parallel processing in a Store Procedure in Sql server 2005?
I searched net for a long time, I didn't get any good articles/examples explaining parallel processing.
Are there any good examples/Articles explaining this, Please send me. ?
Thanks
nRk
April 28, 2009 at 6:07 am
Have you read through the topics in the Books Online (documentation included with SQL Server). I think it explains parallel query execution pretty well.
By and large, there's little that you need to do for parallel query processing implementation. You need to first have a server with multiple processors where SQL Server is installed. The install defaults to using all the processors on the box and a parallelism threshold of 5 (that means when the optimizer thinks a query might take more than 5 seconds it will tag the execution plan and the query engine may, or may not, implement a parallel query). Usually, in an OLTP system, you need to reduce the number of processors use by default and increase the parallelism threshold, a lot, say to 25, to prevent unnecessary implementation of parallelism.
"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
April 28, 2009 at 8:51 am
Why exactly do you want to do this?
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply