SQL Server DBA Ten essential tools make life easy

Source: Internet
Author: User
Tags dba

"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

  

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.