Skip to content
SQL Server Consulting – Straight Path Solutions
  • Home
  • Services
    • DBA Services
    • Cloud
    • Upgrades
  • About
    • About Us
    • Referral Program
    • Speaking
    • Careers
  • Blog
  • Call: 888-775-3282
  • Contact

rollback

To Kill a SPID or Not To Kill a SPID

October 24, 2025 by Warren Departee
SQL Server case study of the week

Quick Summary We received an on-call call from a client who had noticed something was running slowly over the weekend and decided to issue a KILL command. The KILL command did what it does – it started the KILL/ROLLBACK process. They had done that once or twice before, they thought, and didn’t remember it taking … Read more

Categories Case of the Week Tags DBA, kill, on-call, rollback, SQL Server Leave a comment

Archives

For I am not ashamed of the gospel, for it is the power of God for salvation to everyone who believes, to the Jew first and also to the Greek.

- Romans 1:16

Image

PO Box 591
Sanbornville NH 03872

888-SQL-DATA (888-775-3282)

[email protected]

Services

DBA as a Service
Cloud
Upgrades

Recent Posts

  • SQL Server Case of the Week: The tempdb Data File That Couldn’t Be Removed
  • Introducing sp_CheckAG: Check Your SQL Server Availability Groups for Availability Issues
  • SQL Server Case of the Week: Windows Server 22 Update Possibly Breaking SQL Agent & SSIS Packages
© 2008-2026 Straight Path Solutions, LLC. All rights reserved.
Advertisement