Stored procedure: Kill all processes

You're a SQL Server DBA, and you notice that *something* is hogging your system's resources. You don't want to take the time to wade through dozens of processes and individually kill the ones you think might be causing the problem. Ever wish SQL Server had a "panic button" for terminating all user processes, without stopping/restarting the server? This stored procedure I created does exactly that.

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server Stored Procedures Top tips and tricks for SQL Server database development Top 10 SQL Server development tips of 2008 SQL Server trigger vs. stored procedure to receive data notification SQL Server errors, failures and other problems fixed from the trenches SQL Server and data manipulation in T-SQL How to use SQL Server 2008 hierarchyid data type SQL Server stored procedures tutorial: Write, tune and get examples Check SQL Server database and log file size with this stored procedure SQL Server source code analysis and management adds database security Configure SQL Server Service Broker for sending stored procedure data Database Development Top tips and tricks for SQL Server database development Managing the development lifecycle with Visual Studio Team System 2008 Processing XML files with SQL Server functions A first look at Visual Studio Team System 2008 Database Edition How to create a SQL inner join and outer join: Basics to get started New datetime data types in SQL Server 2008 offer flexibility Using DATEADD and DATEDIFF to calculate SQL Server datetime values SQL Server database design disasters: How it all starts SQL Server database design disasters: What not to do Secure SQL Server from SQL injection attacks

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary library  (SearchSQLServer.com) trigger  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

p>

Note that when you run it, it may return several error messages. That's because, as it cycles through the numbers representing process IDs, many of the numbers may not be valid user process IDs. This does not prevent the stored procedure from doing its job; it will still terminate all user processes (except your own), thus freeing up system resources.

For More Information