SQL Server DBA Ten essential tools make life easy

"IT168 technology" used to communicate with some DBAs and database developers about what kind of db tools they used, most of whom had not used other tools except SSMS and profile, and, admittedly, ssms and profile were powerful enough Most of the work is done by them, but MS, third-party companies and even individual developers provide SQL Server with a lot of other tools, and if you can fully master these tools, it will undoubtedly save us a lot of time and effort to manage, optimize, test and debug our database. Here are some useful tools, except for ssms and profile.

　NO1:PD (PowerDesigner)

Function: Sysbase Company provides the database design tool, the function is very powerful, is does the database design the necessary tool;

Download: http://www.3ddown.com/soft/14524.htm

　　

　　No2:log Explorer

Function: Database log reading tool, mainly used to recover the data of misoperation (currently only supported to 2005 version), see:

http://blog.csdn.net/jinjazz/archive/2008/05/19/2459692.aspx;

: http://www.pc6.com/softview/SoftView_57657.html

　　

　　No3:tuning Advisor

Function: Optimization consultant, according to the operation of the database, will prompt you to do the relevant optimization (reliability is not too high, you need to judge);

Download: SQL Server comes with

　　

　　No4:ssmstools

Features: A plugin for the SSMs tool that provides formatting code, traceability history and other functions (through which you may be able to develop your own plugins);

Download: http://www.ssmstoolspack.com/

　　

　　No5:dbdiff

Function: Compare the difference of two databases;

Download: http://opendbiff.codeplex.com/

　　

　　No6:pal Tool

Features: Performance analysis of Logs,perfmon log Analytics tool;

Download: http://pal.codeplex.com/

　　

　　

　　No7:rml

Function: This tool is very powerful and shows the four main functional components of the finished installation. The Readtrace tool can read the profile trace file of the database and generate the report, Ostress can replay the readtrace generated files, and also can stress test the database, Orca can guarantee the repeater, and play according to the sequence of events; Reporter can be readtrace after the content through the form of presentation, quite useful.

　　

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

　　

　　No8:sqlnexus

Function: Collect information first through SQL Server's SQLdiag.exe tool, and then analyze this information with Sqlnexus, which is the integration of some of the previous tools, providing the database manager with considerable support for finding the performance bottleneck and troubleshooting of SQL Server servers ( Ms Engineer many use this Oh, buy technical support friends have the wood has experienced MS requires you to open sqldiag, and then the collected data back to them; on-site support, is not also open sqldiag collect data, and then came out of the server performance report, there is wood there; so master it, 1k/. The regular server check technical support costs can be saved);

Download: http://sqlnexus.codeplex.com/

　　

　　

　　No9:sqlio and SQLIOSim

Function: Disk IO pressure test tool, Sqlio is mainly to simulate random or sequential way to test the performance of disk IO; SQLIOSim is a simulation of SQL Server behavior to test IO performance;

Download: http://support.microsoft.com/kb/231619

　　

　　No10:sqlmonitor & SSBDiagnose

Function: SQLMonitor is a necessary tool for monitoring replication and mirror, and Ssbdiagnose is a tool for testing SSB configuration;

Download: SQL Server comes with