THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kalen Delaney

Did You Know? Free SQL Server Troubleshooting Tools

I'm very excited about the new Management Data Warehouse coming in SQL Server 2008 (which was called Performance Studio at one point), but keep in mind there are lots of available tools in the current versions.

One of the students in my class last week put together this list of his favorites. Note that some of the tools can be used together. For example, the PSSDIAG collection utility output can be pumped into SQL Nexus for nice reporting and analysis.

 

RML Utilities for SQL Server

http://support.microsoft.com/kb/944837

http://www.microsoft.com/downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en

SQL Nexus

http://www.sqlnexus.net/

PSSDIAG Data Collection Utility

http://www.microsoft.com/downloads/details.aspx?FamilyId=5564386A-28C2-4483-8293-76FFF67B9EB3&displaylang=en

Description of the SQL Server Performance Analysis Utilities Read80Trace and OSTRESS

http://support.microsoft.com/kb/887057

SQL Server Health and History Tool (SQLH2)

http://www.microsoft.com/downloads/details.aspx?FamilyID=EEDD10D6-75F7-4763-86DE-D2347B8B5F89&displaylang=en

Performance Dashboard

http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

 

Have fun!

~Kalen

Published Saturday, May 17, 2008 9:47 PM by Kalen Delaney

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Linchi Shea said:

These existing SQL2005 tools are fine and useful. But one problem with them is that they are not a coherent bunch of tools--they are rather ad hoc, developed by different people, coming from different directions, targeting slightly differnt problems, and not systematically related to each other. In this respect, the SQL Server community can learn a lot from Oracle 10s' Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM). I'm not here to promote Oracle, but it would be a mistake not to learn from others' experience. These Oracle tools have been around for about 5 years, and have accumulated quite a bit of community experience. We can gain a lot from their experience--good, bad, and ugly.

I have not had a chance to study SQL2008 Management Data Warehouse in any depth, so I can't comment on where it is compared to Oracle 10g/11g. If anybody knows, I'd very much like to hear.

May 18, 2008 2:39 PM
 

Andy Ball said:

Hi Kalen,

I would add PAL which I've used a few times recently. Not a Silver Bullet but helps out when u get a little bogged down in a Perfmon.

Takes a perfmon and performs analysis / recommedations based on rule of thumb for various workloads (ie SQL Server / Exchange / Web etc)

http://www.codeplex.com/PAL

cheers,

Andy.

May 20, 2008 6:52 AM
 

sangeeth said:

sql server id not connecting in windows authendication itself what 2 do?

October 15, 2008 12:34 AM
 

Mike Lawrence said:

Does SQL Nexus still exist?  The link does not work for me...

January 23, 2009 11:29 AM
 

Kalen Delaney said:

Last May, I blogged about free troubleshooting tools for SQL Server and today I received a comment that

January 23, 2009 12:46 PM
 

Bob W. said:

The sqlnexus.net URL doesn't work any more, but you can find the SQL Nexus tool at CodePlex.

http://www.codeplex.com/sqlnexus/

December 6, 2009 4:50 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Favorite Non-technical Sites or Blogs

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement