We would like to keep you up to date with the latest news from Digitalisation World by sending you push notifications.
Digital Newsletter
Each week our editor Phil Alsop rounds up the most popular articles, videos and expert opinions. We compile this into a Digital Newsletter and send it straight to your inbox every week.
Digital Magazines
We'll let you know each time a new edition of Digitalisation World is released so that you're always kept up-to-date with the latest and greatest news and press releases.
Video Magazines
The Digitalisation World Video magazine contains the latest Zoom interviews with experts in the industry.
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.
