Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Types of Wait do we see.. Query using Paralleism !!! Expand / Collapse
Author
Message
Posted Tuesday, September 3, 2013 7:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 3:18 AM
Points: 104, Visits: 401
Hi All,

Can i have to know while a query is getting executed then...What type of wait do we see ...

If the query is using parallelism ?...Is there any way we can forcibly use parallelism for a query?

If the query is not using Parallelism.. is there any way to know… why the Parallelism was not used for that query while running ?

Can any one please suggest...!!


Post #1490951
Posted Tuesday, September 3, 2013 7:32 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 2,345, Visits: 2,843
Take a llok at this article by Brent Ozar. It will answer most/all of your questions.
http://www.brentozar.com/archive/2013/08/what-is-the-cxpacket-wait-type-and-how-do-you-reduce-it/


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1490954
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse