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 ?
 
 
1 Answer
 
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
 
 
Add an answer*
 
Email
Now hiring!
Software Development Engineer (SDE) Job
Microsoft 
Redmond, WA
Category: Software Engineering: Development Location: United States, WA, Redmond Job ID: 722492 18325 Division: ... Our software is responsible for managing hardware and software from the time it is ordered until it is retired.
---------------------------
Senior IT System Analyst
UnitedHealth Group 
Basking Ridge, NJ
Group, Enterprise Technology Services Group and the IT Business Services Group, UnitedHealth Group IT has over ... with MQ * 1+ year experience with DB2 * 3+ years Development experience * 2+ years QA or Operations...
---------------------------
Software Development Engineer 2
Microsoft 
Redmond, WA
of the Developer Division, which is chartered with making it easy for developers and domain experts to use Microsoft ... in developing debuggers required. Demonstrated passion for developer experience a plus. Prior experience with high...
---------------------------
Senior Software Development Engineer
Microsoft 
Redmond, WA
We are looking for a strong and independent Software Development Engineer to work in a position to help us ... Qualifications include: 7+ years of strong experience in software design and development. Demonstrated ability and...
---------------------------
IT Software Development Engineer (SDE) 2 Job
Microsoft 
Issaquah, WA
Category: Software Engineering: Development Location: United States, WA, Issaquah Job ID: 727018 21522 Division: IT ... Management, Engineering, Software Engineer, Engineer, Test Engineer, Technology, SQL, Database, Developer, .NET,...
---------------------------
Senior IT Project Manager
UnitedHealth Group 
Philadelphia, PA
IT Project Management ... PowerPoint and Visio) - 6 years * Software application development experience (internet, intranet, infrastructure, networks, applications) - 6 years * Healthcare industry experience - 4 years Assets: * PMP...
---------------------------
Sr. IT Software Development Engineer (SDE) Job
Microsoft 
Issaquah, WA
Category: Software Engineering: Development Location: United States, WA, Issaquah Job ID: 723798 19797 Division: IT ... able to experience with writing automation for API or UI development, data management, SQL reporting. Candidates...
---------------------------
Senior IT Quality Manager
UnitedHealth Group 
Hartford, CT
processes are carried out through all phases of the Software Development Lifecycle * Work with business partners, systems analyst, designers and programmers to create/analyze required project documents and ... IT Quality Assurance...
View all jobs