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 ««12

Deletes takes a long time, but CPU, Disk and RAM untroubled...why ? Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 5:28 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:49 AM
Points: 608, Visits: 1,027
greg.bull (9/24/2013)

3) How could it be being blocked, I wonder ?


If you have FK keys referencing this table then there are chances that you can experience blocking.

what is the value of maximum degree of parallelism defined?


Pramod
SQL Server DBA | MCSA SQL Server 2012

in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
Post #1498263
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse