Freebie: SQL Server performance tuning dashboard

Read about a free tool that's ideal for pulling together a great deal of SQL Server statistics in one single screen.

This Content Component encountered an error

You may already be working with the usual suspects for performance tuning tools, but are you using all the features available in each tool? The following is one of several must-have free tools, or go to the complete list of freebies.

  7. SQL Server performance tuning dashboard  Return to Complete List

The last freebie I would like to draw your attention to is a SQL Server dashboard: SQLcheck from Idera. It is a read-only interface that operates per SQL Server instance. It is ideal for pulling together a great deal of SQL Server statistics in one single screen. The main interface has the number of transactions, memory usage, percent processor time, disk transfers, network traffic, buffer cache hit ratio, user connections, lock time outs, etc. This single dashboard can serve as a great first step to monitor an environment that can't be captured natively in one screen with the SQL Server toolset.

Click for the complete list of featured performance tuning freebies.


About the author: Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also the SearchSQLServer.com Performance Tuning expert. Ask him a question here.

This was first published in July 2005

Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close