Click here to monitor SSC
SQLServerCentral is supported by Redgate
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 15, 2016 11:01 PM
Points: 120, Visits: 470
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 @ 8:03 AM
Points: 2,880, Visits: 3,375
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