OPTION(MAXDOP 1) in SQL Server

Question posted in Computer Software, Computer\IT Services on 10 2009
Rate question difficulty level 1 Votes
What can you do in order to improve SP execution time ?
You have improved you SP performance , add index to the right tables etc...
but you still getting time out , what will you next ?
 
 
2 Answers
 
One way I know is to use OPTION(MAXDOP 1).


It Sets the maximum number of processors the query processor can use to execute a single index statement. Fewer processors may be used depending on the current system workload.

check out See Rickie Lee's blog on parallelism and CXPACKET wait type.

code example :


SELECT *
FROM test t,
WHERE t.CourseID= 5
ORDER BY t.LessonWeekDay
option (MAXDOP 1)


10/27/2009
 
 
While people in South Korea set out and has a broad mass identity dragon boat sacrifice form, we actually should in order to these cultural heritage belonging and somebody else's noisy a blue in the face, or should be seriously reflect on, these this belong to himself, in his side's cultural heritage, what was his casual ignore and squandered?GHD Scarlet Collection Deluxe

11/10/2012
 
 
Add an answer*
 
Your name
Email
 

add a question

arrow_blue


Now hiring!
---------------------------
---------------------------
---------------------------
---------------------------
---------------------------
Hy-vee 
---------------------------
---------------------------