SQL Doctor

Complete SQL Performance Tuning

boxshot sqldoctor

KJØP VIDEO

SQL Doctor minimaliserer kostbar nedetid for din server gjennom å proaktivt varlse administratoren om problemer og tilby rask diagnose og løsning.

-Nye og bedre ekspertanbefalinger som bidrar til bedre ytelse
-Dashboard som viser resultater og statistikk i sanntid
-Rask lokalisering av problemer og umiddelbar lokalisering av SQL ytelsesproblemer
-Kjørbare script genereres for å optimalisere ytelse
-Lagret historikk av anayser for å se trender

 

Generelt

screenshot sqldoctorSee Detailed Performance Metrics
Analyze the performance of SQL Server databases and receive tuning recommendations for resolving them in minutes as opposed to hours. SQL Doctor targets some of the most common areas of SQL Server performance problems, such as queries, server configuration, security, database objects, memory, wait statistics, query plans, and much more.

Locate Issues via "Quick Findings"
SQL Doctor Instantly highlights where performance threatening issues are occurring, displaying metrics in real-time for processes, network interface cards, processor, processor cache, memory, disk, and system information.

Enhanced Expert Recommendations
Leverage the latest proven industry best practices endorsed by SQL Server MVPs to analyze the performance of SQL Server. Get expert recommendations including index usage, query syntax enhancements and configuration changes with a patented ranking system that shows the highest performance improvement options first. Expert recommendations have been developed against, and SQL Doctor has been tested to work with, pre-release copies of SQL Server 2016.

Executable Scripts Available
SQL Doctor provides executable scripts of the recommendations that can be reviewed and implemented directly in the tool. Generate “undo” scripts for quickly reversing any of the optimization scripts which have been previously implemented.

Historical Analysis
Store and easily retrieve historical data and recommendations for trending and comparison.

 

Detaljer

Discover Integrity Issues
Identifies SQL Server database integrity issues and highlights recovery methods which may leave the database in a potentially unrecoverable state.

Index Optimization
Diagnose indexes to determine possible performance optimizations.

Server Configuration
Examine Windows and SQL Server configuration settings.

Processor
Identify configuration settings that cause processor bottlenecks.

Security Settings
Uncover many of the most common holes in security settings.

Learn more


 

Tekniske Spesifikasjoner

Console and Services
-x86 and x64: Windows Server 2008 R2, Windows Server 2008, Windows Server 2003 SP3, Windows Vista SP1+, Windows 7 SP1+, Windows 8 and 8.1, Windows 10
-.NET 3.5

Supported SQL Server instances
-SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 ,SQL Server 2012, SQL Server 2014.
-Experimental support for SQL Server 2016

Lisensiering

SQL Doctor is offered per instance. A license is needed for each (per) SQL Server instance that is being monitored.  First year of maintenance is included in price.

Alfasoft offer a price guarantee for the IDERA products. If you find an IDERA product at a lower price before your purchase somewhere else we will match it.