New SQL Tools

I can't take credit for finding these but man they are the bees knees.

SQL Heartbeat
http://www.sqlsolutions.com/downloads/sql-heartbeat/Download.html

Searches the DB code for text
http://www.red-gate.com/products/SQL_Search/index.htm


I really LOVE SQL Heartbeat. It shows a stack graph of waits, a line graph of Seek Time (Reads and Writes) a line graph of Physical Reads and Writes, a line graph of Cache Hits

AND

The best feature, A bubble graph of active processes. The bubble has a red ring if it is inside a transaction, the bubble grows if it is using a bit of CPU, and if the process is 'stalled' within a transaction it shows up as a huge red bubble.

When you mouse over the bubble you get process information and all that jazz.

This replaces SP_who, SP_who2, my home rolled "SP_What" and the best part is it is FREE.

Second link is RedGate's SQL Search. I have a stored proc that does this, but not as fast and not as easy to read. It searches databases for key words (in all code). It is pretty good. Right now I'm loving Red Gate, and am checking out SQL Solutions very closely. These free tools are just what the over-worked DBA needs to keep on top of things!