Tools for Sql server

Following are the very important tools which Microsoft uses and recommend for troubleshooting and performance improvement…. this will really help you to improve your system…
 
SQL Server troubleshooting tools PSSDiag, SQLDiag, SQLNexus, RML Utilities and ReadTrace: which one to choose?
1. SQLIOSim:  –by Bob Dorr
http://support.microsoft.com/kb/231619 
2. SQL Nexus — by Ken Henderson and Brad.

http://www.codeplex.com/sqlnexus
3. SQLdiag
http://msdn.microsoft.com/en-us/library/ms162833.aspx
4. PSSDiag
http://support.microsoft.com/kb/830232
5. RML (READTRACE80/IOSTRESS) Utilities for SQL Server 2005
http://support.microsoft.com/kb/887057
 
8.SQLIO Disk Subsystem Benchmark Tool
9. How to monitor blocking in SQL Server 2005 and in SQL Server 2000
sp_blocker_pss08

http://support.microsoft.com/default.aspx/kb/271509
 
10. IOMeter.
11. Sysinternals… it was www.sysinternals.com  now Microsoft owns it… it has some great tools… everything is FREE….cool.
 
12. some good tools written by great Jim Gray with  Peter Kukol
 
>> Hey found a great blog on this by Megan Keller on sqlmag.:
The Mega Guide to Free SQL Server Tools
 
Another one (Wolf’s Blog)… so many tools…. ooooo god.
 
(added -09302009) blog by sqlguychuck -Free SQL Server Tools
 
(added 11062009)
 (added 12152009) good tool for performance monitoring:
 
We should keep this handy…. 🙂
 
HTH
Vinay
 
[added 08/06/2012]
Advertisements
This entry was posted in Free Stuff, Tool. Bookmark the permalink.

Leave a Reply

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