Embarcadero delivers 24/7 performance insights and team capabilities with DB PowerStudio 2016

Embarcadero Technologies has 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 every day 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 revolutionises cross-platform database management performance by enabling operational integrity, data consistency and team collaboration and awareness in the most complex environments.”


New SQL Optimisation 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.


Centralised 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 analyse 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 specialised 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 every day,” adds Swindell.

First of its kind research, in partnership with Canalys, offers deep insights into some of the...
According to a recently published report from Dell’Oro Group, worldwide data center capex is...
Managed service providers (MSPs) are increasing their spending by as much as 70% to meet growing...
Coromatic, part of the E.ON group and the leading provider of robust critical infrastructure...
Datto’s Global State of the MSP: Trends and Forecasts for 2024 underscores the importance of...
Park Place Technologies has appointed Ian Anderson as Senior Director, Channel Sales, EMEA.
Node4 has passed the ISO 27017 and ISO 27018 audits, reinforcing its dedication to data security,...
Park Place Technologies has acquired Xuper Limited, an IT solutions provider based in Derby, UK.