Why Is This Powerful Tool For You?

For the DBA, the high performance levels of your queries are critical and knowing how the data is distributed allows you to address current issues. Now you can do that with:

• Data Distribution – Quickly view and alter the data distribution.
• Query Plan Analysis, Monitoring & Viewing – The ability to watch and monitor how a query parallism is distributed on the appliance with respect to resources and quickly relate this to the query plan.
• Reverse Engineer – Reverse engineer an MPP schema with complete syntactical support.
• Cross Platform Schema Migration – Compare a database schema within or across appliances and produce a script that will allow you to synchronize the schemas while retaining original data. Use the workbench to pull schema and data definition language (DDL) from source databases and translate this into your target system schema. Complete with recommendations on distribution and organization.
• Secure Shell (SSH) interface to server – Quick access to the appliances operating system shell commands for more advanced DBA operations.
• Space Use Diagnostics – Analyze space utilization and issues across the entire server in a way that clearly identifies where and how space is used – making it fast and easy to address capacity issues.
• Server Query History Analysis – Quickly view all query history over long periods of time to find slow running queries. Then quickly jump to detailed analysis of query plans and processing distribution.
• Grooming and Organizing Tools – Wizards and tools to rapidly groom and maintain space and organization to better optimize the appliance.