SQL Server Best Tools

Below are the most useful and the best free/trail tools for SQL Server. These tools are getting used by SQL Server DBAs over the world.

SQL Tools

SQL Server Upgrade Advisor
SQL server upgrade advisor is a Microsoft free tool. This will be useful for SQL server upgrade. Download the right SQL UA edition.
Download this tool from here: http://www.microsoft.com/download/en/details.aspx?id=11455

SP_BLITZ
“SP_BLITZ” is a stored procedure written by Brent Ozar. The script will give you about the fast health check on your SQL Server.
Download this tool from here: http://www.brentozar.com/blitz/

Instant SQL Formatter
Instant SQL Formatter is a free web tool. This will be useful to the developers and DBAs to organize their codes.
You can use your codes here: http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz

SQL Heartbeat
SQL heartbeat is a free tool. This will give you about the server wait, cache graph and each user SPID (transaction) details etc.
Download this tool from here: http://www.sqlsolutions.com/products/Heartbeat/index.html

Who Is Active
Who Is Active is a stored procedure written by Adam Machanic. By using this script you can easily find your current transaction activity.
Download this tool from here: http://sqlblog.com/blogs/adam_machanic/archive/2011/04/27/who-is-active-v11-00-a-month-of-activity-monitoring-part-27-of-30.aspx

SQL Server 2005 Performance Dashboard
SQL server 2005 performance dashboard is a Microsoft free tool. This will give you about the overall server status like CPU, IO, wait and recent expensive query detail graphs etc.
Download this tool from here: http://www.microsoft.com/download/en/details.aspx?id=22602

SQLIOSIM
SQLIOSIM is a Microsoft free tool. This will help you to determine the server I/O capacity.
Download this tool from here: http://support.microsoft.com/kb/231619

SQL Server Maintenance Plan Script
SQL Server Maintenance Plan Script is a stored procedure written by Ola Hallengren. By using this script you can automate all your database maintenance.
Download this tool from here: http://ola.hallengren.com/

SQL Server 2005 Best Practices Analyzer
SQL Server 2005 Best Practices Analyzer is a Microsoft free tool. This will give you about the SQL server best practices reports like Log on account recommendation, CheckDB outdated, Backup outdated etc. Download the right SQL UA edition.
Download this tool from here: http://www.microsoft.com/download/en/details.aspx?id=23864

 


<<Click here to see all posts>>

 

1 comment on “SQL Server Best Tools”

Leave a Reply

Your email address will not be published. Required fields are marked *

Prove You Are Human Time limit is exhausted. Please reload CAPTCHA.