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
Posted Tuesday, September 3, 2013 7:30 AM


Group: General Forum Members
Last Login: Wednesday, June 17, 2015 3:08 PM
Points: 110, Visits: 429
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



Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 2,714, Visits: 3,207
Take a llok at this article by Brent Ozar. It will answer most/all of your questions.

** 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