The program may not be broken, but it does hurt.
Martin Fowler[1]
[1] Fowler, Martin. Refactoring: Improving the Design of Existing Code. Reading, MA; Addison-Wesley, 1999. Page 7.
In this chapter we'll talk about debugging and profiling Transact-SQL stored procedures. We'll also talk about how to stress test SQL Server using Transact-SQL queries and a free stress testing tool that you'll find on the book's CD.