Performance tuning free tools to add to your SQL Server favorites

You may already be working with the typical SQL Server performance tuning tools, but are you using all the features available in each tool? Don't miss out on these must-have tools, stored procedures and functions.

I recently spoke on SQL Server performance tuning at CFUNITED, a conference focusing on Cold Fusion, where I found a large number of developers who use SQL Server every day. In my presentation, I offered a variety of free tuning tools that attendees were not aware of. Here I'll share the list with you and provide more detailed tips in the future.

TABLE OF CONTENTS
   1. Enterprise Manager's Current Activity
   2. SQL Server Profiler
   3. Enterprise Manager's Index Tuning Wizard
   4. System Monitor
   5. Query Analyzer's Query Plans
   6. Stored procedures and functions
   7. SQL Server performance tuning dashboard


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.


More information from SearchSQLServer.com

  • Tip: Optimize SQL Server hardware performance
  • Tip: SQL Server performance tuning worst practices
  • Checklist: Load testing -- the magic bullet for SQL Server performance tuning


  • 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