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: Thursday, December 10, 2015 2:40 AM
Points: 110, Visits: 430
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: Today @ 1:46 PM
Points: 2,807, Visits: 3,297
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