DB PowerStudio adds SQL Server Analysis

DB PowerStudio is an intuitive toolset that includes visual SQL optimization and tuning. It comes complete with support for all popular DBMS's, including Oracle, SQL Server, Sybase ASE and DB2. DB PowerStudio is the latest suite in a line of award-winning database tools for DBAs and database developers.

Updates in XE3.5

• Custom Data Source Categories - Create your own custom categories including category name, short name and identifying color for each.
• SQL Server Analysis - Table and column statistics now available when tuning against SQL Server data sources. The Table Statistics tab lets you view current table statistics settings as well as manually perform tasks such as updating statistics.
• DB2 9.7 Execution Statistics - When tuning against a DB2 9.7 datasource, the Generated Cases area of the Overview tab now includes an additional set of execution statistics gathered for the suggested cases.
• Oracle Database Links Support - Execute and generate cases for transformations, SQL rewrites and hints that do not rely on column, index, or primary key information.
• Oracle Procedures Load Details - When profiling against an Oracle (10g or higher) data source, the Top Activity and Profiling Details pane now have a dedicated tab that provides procedure information.
• Oracle Blocking Sessions Details - When profiling against an Oracle data source, the Top Activity and Profiling Details pane now have dedicated Blockers and Blocked Sessions tabs that provide information about sessions holding blocking locks.

About Idera

Idera creates application and server management software for physical and virtual server platforms. They produce award-winning solutions for server backup, SQL Server administration. performance monitoring, recovery, security and compliance. More than 12,000 customers around the world, including many Fortune 1,000 enterprises and government agencies, rely on Idera products to keep their data backed up and protected and their servers optimized for performance.