Embarcadero Technologies, a leading provider of software solutions for application and database development, today unveiled DB PowerStudio® 2016, a suite of award-winning database tools that provides database managers (DBAs) and data professionals with comprehensive administration, development, performance and monitoring capabilities across multiple platforms to increase productivity, boost database performance, and improve availability. DB PowerStudio 2016 features new performance insights and is fully integrated with the included DB Team Server, the industry’s first team-connected solution for database professionals with shared repositories, health statistics, and collaboration and communication between team members and roles.
The DB PowerStudio 2016 suite includes DBArtisan® 2016, a team-enabled, cross-platform solution for database administration, monitoring and performance; and Rapid SQL® 2016, the industry’s only intelligent SQL IDE that enables developers and DBAs to create high-performing SQL on all databases using a single interface. The new Performance IQ add-on brings performance management capabilities to DBArtisan 2016 and Rapid SQL 2016. Database professionals struggling with endless performance issues can now gain deep insights to proactively manage and troubleshoot performance bottlenecks.
“Simply seeing database performance metrics is no longer enough. Data professionals need insights in real-time in the tools they use everyday to help prevent performance and storage-related problems; highlight trends and object growth over time; and pinpoint performance bottlenecks,” says Michael Swindell, Senior Vice President of Products at Embarcadero. “DB PowerStudio 2016 takes database management and development further than ever with integrated SQL performance management, team-enabled collaboration, and monitored statistics such as database health to deliver the visibility that data professionals need to ensure their databases run fast, consistently, and without surprises. DB PowerStudio 2016 revolutionizes cross-platform database management performance by enabling operational integrity, data consistency, and team collaboration and awareness in the most complex environments.”
New SQL Optimization Technology for High-performance Database Management:
Available as an option for DBArtisan 2016 and Rapid SQL 2016, Performance IQ monitors database instances 24/7, determines the underlying cause of performance degradation and visually highlights the root cause for all major areas of DBMS performance. Benefits and features include:
• Deeper database insights: Embedded performance metrics and analytics enable users to quickly understand the top SQL statements impacting IO, table and index growth history and the effect of noisy neighbors, offering huge time savings.
• SQL analytics: A SQL editor shows how SQL has performed over time in its various revisions and why performance variances are occurring; constantly provides on-the-fly SQL hints (powered by Performance IQ) alerting a user as to how column cardinality or data skew may affect the performance of a SQL statement; and, suggests new indexes when SQL performance would benefit from such additions.
• 24/7 Wait-based monitoring and alerting: New 24/7 wait-based observations help DBAs proactively understand and manage their database environment. “Time travel” allows users to rapidly to dissect past issues as they occurred, as well as more fully understand deviations from the normal trends. A user-configurable alerting ensures there are no surprises.
Centralized Database Management, Collaboration and Alerting:
DB PowerStudio 2016 features DB Team Server, a revolutionary collaborative platform for DBAs that provides a holistic view of the enterprise database landscape to better manage and analyze corporate data assets. DB Team Server offers basic monitoring and alert notifications that improve responsiveness with instant insights into availability, performance and storage. Streamlined communication and access to various repositories such as shared data sources, basic health metrics and passwords, enhance knowledge sharing and improve communications by providing easy access to corporate database knowledge, including specialized scripts, notes and internal discussion topics.
“DBAs and SQL developers have typically worked with highly siloed tools which do not facilitate collaboration, and shared resources preventing enterprises from getting the most out of their data. DB Team Server is the link that’s been missing from database tools. Team Server is included and fully integrated into DBArtisan and Rapid SQL 2016, delivering team collaboration, resource sharing, and database health and performance awareness right in the tools DBA and SQL Developers use everyday,” adds Swindell.
DB Optimizer 2016, a SQL profiling and tuning utility for improved SQL code performance, and DB Change Manager® 2016, a schema and data synchronization toolset, are also featured in today’s roll out of DB PowerStudio 2016.
DBArtisan 2016, Rapid SQL 2016, DB Optimizer 2016, and Change Manager 2016 are available immediately from Embarcadero. Performance IQ is also now available as an add-on for DBArtisan 2016 and Rapid SQL 2016. Free trials can be found at: http://www.embarcadero.com/downloads