"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