Monthly Archives: November 2009

SQL Trace Tools

You can use this tool. http://www.scalesql.com/cleartrace/ This gives output in the following format and it’s a very handy tool. SP / Function Count CPU Average CPU Reads    Average Reads  Writes   Average Writes Duration              Average Duration

Posted in SQL Server 2005/2008 | Leave a comment

Database diagram Tool – SQuirreL

One interesting open source tool SQuirreL that i have found to draw Database diagram, More comments later.    http://squirrel-sql.sourceforge.net/index.php?page=screenshots  http://squirrel-sql.sourceforge.net/screenshots/graph.png

Posted in SQL Server 2005/2008 | Leave a comment