Embarcadero DB PowerStudio for SQL Server PVB000ELEWWX1 Folheto
Códigos do produto
PVB000ELEWWX1
D
A
T
A
S
H
E
E
T
DB PowerStudio
™
for SQL Server 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.
Take your SQL Server database administration and development
capabilities to the next level with visual diagnostics that not only
help you pinpoint problematic queries, but also determine the
best solution. Unique capabilities such as a Visual SQL Tuner
can save you hours or days of time when tuning problematic
SQL statements. You’ll also enjoy deep change management
functionality for coordinating database changes across the
development life cycle, or for enforcing database configuration
standards across your entire enterprise.
DB POWERSTUDIO MAKES IT EASY
WITH DEVELOPER AND DBA EDITIONS
DB PowerStudio for SQL Server, Developer Edition
includes everything you
need to improve quality and performance at each stage of the application development life cycle.
Write High Quality SQL Code Faster with Rapid SQL
®
•
Simplify SQL scripting, query building, object management, project management, and version control in live
SQL Server databases or offline source repositories
•
Debug programmable objects such as stored procedures, functions and triggers
•
Pinpoint performance problems with SQL code by performing detailed response time analysis on the
execution of stored procedures and functions
Visually Tune SQL against SQL Server with DB Optimizer
™
•
Relate resource utilization to specific
queries, and visually tune the
problematic SQL using Visual SQL
Tuning Diagrams
•
Analyze and tune complex SQL
statements, including bind variables
•
Access robust reporting with
execution statistics, profiling details,
predicate analysis and explain plans
Simplify SQL Server Database
Change Management with
DB Change Manager
™
•
Work with multiple SQL Server
versions and databases from a single toolset
•
Compare your development and test servers to quickly identify changes
and generate the synch scripts to correct any problems
•
Mask test data in order to comply with privacy laws
DB PowerStudio for SQL Server, DBA Edition
gives you everything in the Developer
Edition plus DBArtisan
®
for advanced database administration, as well as a command
line interface to schedule your change management jobs anytime, day or night.
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 toolset
•
Easily carry out complex actions such as schema extraction, schema migration, and data load and unload
•
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 DBArtisan 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),
by 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
DB PowerStudio for SQL Server
Simplify database development, administration, and performance tuning
DB Optimizer Professional
gives you a unique Visual SQL
Tuner to quickly understand
the relationships in a SQL
query, spot design flaws, and
determine the best execution
path for the query.
Developer Edition Includes
Rapid SQL
®
Professional
•
The fastest way to write
quality SQL
DB Optimizer
®
Professional
•
Visually profile key
performance metrics and
optimize SQL using Visual
SQL Tuning (VST)
DB Change Manager
™
Professional
•
Simplify, automate, and
report on database changes
DBA Edition Includes
Everything in the Developer
Edition plus:
DBArtisan
®
Workbench
™
•
The industry’s premier
database administration tool
with advanced Performance,
Space and Capacity Analysts
DB Change Manager Enterprise
•
DB Change Manager
Enterprise includes a
command-line generation
wizard to generate batch
or ANT scripts so you can
schedule and run multiple
change management jobs at
any time