SQLSERVERDBA Ten essential tools---make life easier.

Overseas consolidation and Expansion: http://weblogs.sqlteam.com/mladenp/archive/2007/11/20/Free-SQL-Server-tools-that-might-make-your-life-a.aspx

When I was talking to some DBAs and database developers, I asked them what kind of db tools they used, and most of them didn't use any other tools except SSMs and profile.

Admittedly, ssms and profile are strong enough to work with most of the content, but MS, third-party companies and even individual developers provide SQL Server with many other tools if you

The full mastery of these tools will undoubtedly save us a lot of time and effort in managing, optimizing, testing, and troubleshooting the database, and here are some useful tools that are available in addition to 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 & TableDiff

Function: The first is to compare the differences between the two database structures and the second to compare the differences in the data in the table (and to generate related scripts);

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

NO6 : PAL Tool

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

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

NO7 : RML

Features: This tool is very powerful, showing the completion of the installation of its four main functional components, the Readtrace tool can read the database profile tracking file, and generate reports; Ostress can Readtrace

The generated file replay, but also can do stress test the database; Orca can ensure the repetition of the timekeeping, in accordance with the sequence of events to play, reporter can be readtrace after the content through the form of the report, quite

The useful.

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

NO8 : Sqlnexus

Function: Collect information first through SQL Server's SQLdiag.exe tool, then analyze the information with Sqlnexus, which is the integration of some of the previous tools, looking for SQL Server servers for database administrators

Performance bottlenecks and troubleshooting provides considerable support (MS engineers use this Oh, buy technical support friends have wood have experienced MS ask you to turn on sqldiag and then send 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; so master it, 1k/when the regular server check technical support costs can be saved);

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

NO9 : SQLIO & 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 simulating 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

SQLSERVERDBA Ten essential tools---make life easier.