•  
  • SQLTools

SQLTools

Comments: 7 Comments

SQL server best Tools

In this post I am going to share SQL server DBAs best free/trail tools which I am using and which will help day to day DBA activities.

 

1. 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.

You can download here: http://www.sqlsolutions.com/products/Heartbeat/index.html

 

2. 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.

You can download here: http://www.microsoft.com/download/en/details.aspx?id=22602

 

3. 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.

You can download here: http://www.microsoft.com/download/en/details.aspx?id=23864

 

4. 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.

You can download here: http://www.microsoft.com/download/en/details.aspx?id=11455

 

5. SQLIOSIM

SQLIOSIM is a Microsoft free tool. This will help you to determine the server I/O capacity.

You can download here:http://support.microsoft.com/kb/231619

 

6. 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

 

7. 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.

You can download 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

 

8. 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.

You can download here: http://www.brentozar.com/blitz/

 

9. 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.

You can download here: http://ola.hallengren.com/

 

This post will update occasionally whenever I find a new tool.

Muthukkumaran kaliyamoorthy

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

More Posts - Website

Share this
7 Comments - Leave a comment
  1. Arunkumar says:

    Good tools list. Thanks

  2. Alex says:

    Hi, another free SQL Server tool is SQL Hunting Dog from http://www.sql-hunting-dog.com – quick search addin for SSMS 2008 and 2012.

  3. Vandykish says:

    Hi,

    I am looking for some good SQL Server 2012 tutorials. I have tried this

    http://sqlserver2012tutorial.com/

    Can You suggest some more good video tutorials?

    Thanks

  4. valay says:

    Your comment is awaiting moderation.
    October 15, 2014 at 1:56 pm

    Hey Muthukkumaran,

    I have gone through http://www.textformat.in.

    Which is also a good tool for SQL Query formatting and textformatting (specifically “Replace newline with comma” as a developer i need it frequently)..

    Thanks

  5. Johnson says:

    Great list of SQL database tools, In addition to this, I have found some other helpful utilities Like SysTools SQL Log Analyzer which is helpful in analysing SQL database transaction logs. Tool is also capable of recovering deleted records from database tables.

Leave a comment

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="">


Welcome , today is Sunday, June 25, 2017