Friday, February 19, 2010

Cool SQL tool - SQL Heartbeat

I have lived many a days watching performance of SQL queries using SQL Profiler (Claims Inquiry??? - for people who knew about it) . Finding ways to improve the time taken and optimizing the same was a fun exercise; I always hate the idea of using SQL profiler, I always thought it was probably one of the worse Microsoft tools without good user interaction, I agreee that it was one of the powerful tools available to monitor SQL Server but not the best tool in terms of user interaction.

Anybody who feels the same way should try (free) tool SQL Heartbeat, it gives the information of your database in a visual way so it makes it easy to grasp the data.
Processes grow larger as they use more resources. Red balloons appear when locking occurs. Download it from: sqlsolutions