Kalen Delaney : Troubleshootinghttp://sqlblog.com/blogs/kalen_delaney/archive/tags/Troubleshooting/default.aspxTags: TroubleshootingenCommunityServer 2.1 SP2 (Build: 61129.1)Did You Know? Troubleshooting Tools Updatehttp://sqlblog.com/blogs/kalen_delaney/archive/2009/01/23/troubleshooting-tools-update.aspxFri, 23 Jan 2009 17:44:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:11399Kalen Delaney0http://sqlblog.com/blogs/kalen_delaney/comments/11399.aspxhttp://sqlblog.com/blogs/kalen_delaney/commentrss.aspx?PostID=11399<P>&nbsp;</P>
<P>Last May,&nbsp; I blogged about <A href="http://sqlblog.com/blogs/kalen_delaney/archive/2008/05/17/free-troubleshooting-tools.aspx" target=_blank>free troubleshooting tools</A> for SQL Server and today I received a comment that one of the tools listed seemed to no longer be available.&nbsp; So I thought I would publish a refresh. </P>
<P>There are dozens of great tools available, and I'm not even pretending that I am going to list them all. This post is really just an update to the tools I listed previously.&nbsp; So here is the list from my May post, with additional comments.</P>
<P>----------------------------------------------------------------------------------------------------------------------------------------------------------------------</P>
<P><STRONG><FONT size=2>RML Utilities for SQL Server</FONT></STRONG>
<BLOCKQUOTE>
<P><A href="http://support.microsoft.com/kb/944837">http://support.microsoft.com/kb/944837</A>
<P><A href="http://www.microsoft.com/downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&amp;displaylang=en">http://www.microsoft.com/downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&amp;displaylang=en</A></P></BLOCKQUOTE>
<P>RML Utilities are still around and better than ever. You can read about the CU1 here:
<P>&nbsp;<A href="http://blogs.msdn.com/psssql/archive/2008/11/12/cumulative-update-1-to-the-rml-utilities-for-microsoft-sql-server-released.aspx">http://blogs.msdn.com/psssql/archive/2008/11/12/cumulative-update-1-to-the-rml-utilities-for-microsoft-sql-server-released.aspx</A>
<P>And some comments from the SQLCAT team here:
<P><A href="http://sqlcat.com/technicalnotes/archive/2008/02/01/precision-performance-for-microsoft-sql-server-using-rml-utilities-9-0.aspx">http://sqlcat.com/technicalnotes/archive/2008/02/01/precision-performance-for-microsoft-sql-server-using-rml-utilities-9-0.aspx</A>
<P><STRONG></STRONG>
<P><STRONG><FONT size=2>SQL Nexus</FONT></STRONG>
<BLOCKQUOTE>
<P><A href="http://www.sqlnexus.net/"><STRIKE>http://www.sqlnexus.net/</STRIKE></A>
<P><STRONG></STRONG>&nbsp;</P></BLOCKQUOTE>
<P>The SQL Nexus tools have moved to codeplex:
<P><A href="http://www.codeplex.com/sqlnexus">http://www.codeplex.com/sqlnexus</A>
<P>And if you want more free tools than the ones listed here, check out everything else available at Codeplex!
<P><STRONG><FONT size=2>PSSDIAG Data Collection Utility</FONT></STRONG>
<BLOCKQUOTE>
<P><A href="http://www.microsoft.com/downloads/details.aspx?FamilyId=5564386A-28C2-4483-8293-76FFF67B9EB3&amp;displaylang=en">http://www.microsoft.com/downloads/details.aspx?FamilyId=5564386A-28C2-4483-8293-76FFF67B9EB3&amp;displaylang=en</A></P></BLOCKQUOTE>
<P>(This one is still here.)
<P><STRONG></STRONG>
<P><STRONG><FONT size=2>SQL Server Performance Analysis Utilities Read80Trace and OSTRESS</FONT></STRONG>
<BLOCKQUOTE>
<P><A href="http://support.microsoft.com/kb/887057">http://support.microsoft.com/kb/887057</A></P></BLOCKQUOTE>
<P>Although the KB article is still available, the links it points to are broken.
<P>OSTRESS and Read%Trace are are incorporated into RML tools, so see the first link above!
<P><STRONG></STRONG>
<P><FONT size=2><STRONG>S</STRONG><STRONG>QL Server Health and History Tool (SQLH2)</STRONG></FONT>
<BLOCKQUOTE>
<P><A href="http://www.microsoft.com/downloads/details.aspx?FamilyID=EEDD10D6-75F7-4763-86DE-D2347B8B5F89&amp;displaylang=en">http://www.microsoft.com/downloads/details.aspx?FamilyID=EEDD10D6-75F7-4763-86DE-D2347B8B5F89&amp;displaylang=en</A></P></BLOCKQUOTE>
<P>The KB articles is still there, but you can also get the Health and History Tool from Codeplex:
<P><A href="http://www.codeplex.com/sqlh2">http://www.codeplex.com/sqlh2</A>
<P><STRONG></STRONG>
<P><STRONG><FONT size=2>Performance Dashboard</FONT></STRONG>
<BLOCKQUOTE>
<P><A href="http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&amp;displaylang=en">http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&amp;displaylang=en</A></P></BLOCKQUOTE>
<P>(This one is still here.)
<P>I started out that post by mentioning:
<BLOCKQUOTE>
<P>I'm very excited about the new <FONT size=2>Management Data Warehouse</FONT> 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.</P></BLOCKQUOTE>
<P>And now that I've had a chance to use the MDW a bit, I've even more excited. I think THIS is the reason to upgrade to SQL 2008 (if you haven't found another reason yet.)
<P>Have fun!
<P><FONT color=#ff00ff size=4>~Kalen</FONT></P><img src="http://sqlblog.com/aggbug.aspx?PostID=11399" width="1" height="1">SQLTraceToolsTroubleshootingDid You Know? Free SQL Server Troubleshooting Toolshttp://sqlblog.com/blogs/kalen_delaney/archive/2008/05/17/free-troubleshooting-tools.aspxSun, 18 May 2008 03:47:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:6845Kalen Delaney6http://sqlblog.com/blogs/kalen_delaney/comments/6845.aspxhttp://sqlblog.com/blogs/kalen_delaney/commentrss.aspx?PostID=6845<P>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. </P>
<P>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.</P>
<P>&nbsp;</P>
<P><STRONG>RML Utilities for SQL Server</STRONG>
<P><A href="http://support.microsoft.com/kb/944837"><FONT size=1>http://support.microsoft.com/kb/944837</FONT></A>
<P><A href="http://www.microsoft.com/downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&amp;displaylang=en"><FONT size=1>http://www.microsoft.com/downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&amp;displaylang=en</FONT></A>
<P><STRONG>SQL Nexus</STRONG>
<P><A href="http://www.sqlnexus.net/"><FONT size=1>http://www.sqlnexus.net/</FONT></A>
<P><STRONG>PSSDIAG Data Collection Utility</STRONG>
<P><A href="http://www.microsoft.com/downloads/details.aspx?FamilyId=5564386A-28C2-4483-8293-76FFF67B9EB3&amp;displaylang=en"><FONT size=1>http://www.microsoft.com/downloads/details.aspx?FamilyId=5564386A-28C2-4483-8293-76FFF67B9EB3&amp;displaylang=en</FONT></A>
<P align=left><STRONG>Description of the SQL Server Performance Analysis Utilities Read80Trace and OSTRESS</STRONG>
<P align=left><A href="http://support.microsoft.com/kb/887057"><FONT size=1>http://support.microsoft.com/kb/887057</FONT></A>
<P><STRONG>SQL Server Health and History Tool (SQLH2)</STRONG>
<P><A href="http://www.microsoft.com/downloads/details.aspx?FamilyID=EEDD10D6-75F7-4763-86DE-D2347B8B5F89&amp;displaylang=en"><FONT size=1>http://www.microsoft.com/downloads/details.aspx?FamilyID=EEDD10D6-75F7-4763-86DE-D2347B8B5F89&amp;displaylang=en</FONT></A>
<P><STRONG>Performance Dashboard</STRONG>
<P><A href="http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&amp;displaylang=en"><FONT size=1>http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&amp;displaylang=en</FONT></A>
<P>&nbsp;</P>
<P>Have fun!</P>
<P><FONT color=#ff00ff size=4>~Kalen</FONT></P><img src="http://sqlblog.com/aggbug.aspx?PostID=6845" width="1" height="1">Management ToolsPerformanceToolsTroubleshooting