DB PowerStudio for SQL Server, DBA Edition is an intuitive, highly-visual toolset that helps DBAs and developers boost performance across all versions of SQL Server. Designed for SQL Server database professionals, DB PowerStudio complements SSMS with critical capabilities such as database change management and SQL optimization and tuning.
SQL Server data management professionals can take their database administration and development capabilities to the next level with visual diagnostics that not only help pinpoint problematic queries, but also determine the best solution. Unique capabilities such as a Visual SQL Tuner can save hours or days of time when tuning problematic SQL statements. Analytics not only provide insight into current database health, but also where each database is heading in the future. Deep change management functionality not only successfully coordinates database changes across the development lifecycle, but also enforces database configuration standards.
DB PowerStudio for SQL Server provides DBAs and developers with Embarcadero's industry-leading SQL Server database tools at an unprecedented price point. This DBA Edition includes:
-
DBArtisan Workbench - the industry's premier database administration tool with advanced Performance, Space and Capacity Analysts
-
DB Optimizer Professional visually profile key metrics inside the database and optimize SQL using the Visual SQL Tuner
-
DB Change Manager Enterprise simplify, automate, and report on database changes
-
Rapid SQL Professional - the fastest way to write quality SQL
DB PowerStudio for SQL Server, DBA Edition provides SQL data management professionals with everything they need to:
-
Develop, test, profile and tune SQL in an easy-to-use IDE
-
Eliminate performance bottlenecks in production databases and applications
-
Adopt reliable, repeatable and trackable database change management best practices
-
Ensure SQL Server database performance and compliance
Enjoy these DB PowerStudio for SQL Server, DBA Edition capabilities:
Simplify SQL Server Database Administration and Change Management with DBArtisan and DB Change Manager
-
Work with multiple SQL Server versions and databases from a single interface
-
Easily carry out complex actions such as schema extraction, schema migration, data load and unload, and backup and restore
-
Compare a live SQL Server database to a schema or configuration "snapshot" to quickly identify changes and correct problems
Maximize SQL Server Database Performance and Availability with DB Artisan and DB Optimizer
-
See detailed metrics that identify performance, capacity planning, and storage management issues before they become major problems
-
Eliminate performance bottlenecks by visually profiling key metrics inside the database (CPU, I/O, wait times), relating resource utilization to specific queries, and by helping you visually tune problematic SQL
-
Use powerful database monitors, intelligent diagnostic information and strong drill-down details to quickly find and fix performance issues
Write SQL Code Faster, Then Tune Against SQL Server with Rapid SQL and DB Optimizer
-
Simplify SQL scripting, query building, object management, project management, and version control in live SQL Server databases or offline source repositories
-
Analyze and tune complex SQL statements, including bind variables
-
Dive into specific procedures running in a session when profiling a SQL Server data source
Maintenance
DB PowerStudio for SQL Server, DBA Edition 1st Year Maintenance costing $450 will be added to your shopping cart when you purchase the license.
Maintenance entitles customers to:
-
Unlimited technical support
-
All product upgrades
-
Closed beta programs
-
Product answer books
DBMS Support
-
Microsoft SQL Server 2000 to 2008 R2 from a single user interface
System Requirements
-
Runs on standard workstation PCs
-
Windows 2003 - Windows 7, Internet Explorer 5.0 and above; see product pages of individual products for more detailed system requirements information
File Size