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

Kill The Sessions Expand / Collapse
Author
Message
Posted Thursday, April 21, 2011 7:04 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 23, 2015 2:40 AM
Points: 1,242, Visits: 1,549
Comments posted to this topic are about the item Kill The Sessions



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1097312
Posted Monday, May 16, 2016 7:24 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, May 26, 2016 7:20 AM
Points: 7,816, Visits: 753
Don't know why I didn't find this sooner. Thanks.
Post #1786528
Posted Monday, May 16, 2016 3:50 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 11:02 PM
Points: 40,549, Visits: 37,791
Iwas Bornready (5/16/2016)
Don't know why I didn't find this sooner. Thanks.



Ooooo.... be really careful here. Yes, it avoids killing things that are "Runnable" but it does not avoid killing things that are running but have simply been suspended to "wait their turn".

Further, killing any spid should be an absolute resort never mind killing them en masse`. You can leave a whole lot of spids in a "0% rollback status" that sometimes consumes much CPU trying to figure out that it has nothing to do. Actual rollbacks can take a whole lot longer than you ever thought, as well. It can also mess with connection pooling and more.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #1786686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse