SQLTools

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 Server Sentry Plan Explorer

“SQL Server Sentry Plan Explorer” is a tool that will give you awesome and quick overview of query plan usage and problem. It is a free tool given to SQL community. Just install and play it. It will not give you any query result only show you the plan, but it will run the real code, before run check the DML and convert or remove it.

You can download here: https://www.sentryone.com/plan-explorer

How to use: Need to write

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

How to use: Need to write

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

How to use: https://www.sqlserverblogforum.com/2016/07/whoisactive-capturing-a-sql-server-queries-performance-tuning/

4. 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 and you can schedule it a job to store the historical data of performance baseline.

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

How to use: Need to write

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

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

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

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

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

11. Instant SQL Formatter

Instant SQL Formatter is a free web tool. This will be useful to the developers and DBAs to organise their codes.

You can use your codes here: http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz

 

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

7 Comments

Leave a Reply

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