Useful Tools & Utilities

Following are some of the tools which I found useful and pretty handy.

Query Formatting Tools

Data Generation Tools

Productivity Tools/Plug-Ins

  • BIDS Helper – BIDS Helper is a powerful add-in for Visual Studio containing a rich set of features which enhance the BI Development Process in SQL Server (SQL Server BIDS 2005/2008/2008 R2 & SQL Server 2012 Data Tools [SSDT]).

Monitoring Tools

  • SQL Live Monitor – SQL Live Monitor is a stand-alone .NET application which provides real-time performance data about an instance of SQL Server. It’s a great tool and provides a lot of valuable information about any instance of SQL Server thereby helping you View/Monitor performance and to help you identify the performance bottlenecks on the SQL Server instance (SQL Server 2000/2005/2008).

Testing Tools

Stress/Load/Performance Testing

  • SQL Load Generator – SQL Load Generator is used to Generate Load on an instance of SQL Server by firing multiple queries against the instance concurrently.
  • SQLQueryStress – SQL Query Stress is used to test the Performance of SQL Queries, Stored Procedures, and Functions etc. by putting additional stress/load on the instance of SQL Server. SQLQueryStress in Action.
  • Eye on SQL (EOS) – Load Test – EOS is a Load/Stress Test Tool for SQL Server and is a good fit for simple scenarios and perform first level of Load/Stress Testing. It allows us to fire multiple queries against SQL Server so as to put Load/Stress on SQL Server.

Other Tools

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: