According to Robin Schumacher, vice president of product marketing for Embarcadero, of Louisville, Ky., Stinger exposes a number of new metrics. DBArtisan Workbench 8.0 is enabled to exploit those new metrics in order to help DBAs (database administrators) troubleshoot the database engine by, for example, uncovering performance bottlenecks.
Workbench does the same for Oracle Corp.s latest database upgrade, Oracle Database 10g, which also exposes new metrics, such as those concerned with response and wait times.
"In 10g, theres a lot of things that help DBAs troubleshoot response-time analysis," Schumacher said. "There are historical metrics in 10g so a DBA can say, We had a big spike last night. Who was logged on, and what were they doing? We make use of [such metrics] so DBAs can look back in time."
DBArtisan 8.0 also supports Oracle RAC (Real Application Clusters). Schumacher said that this is in response to customers who requested the ability to monitor an entire cluster of database servers. "They want to see all the different nodes," said Schumacher. "Whats underutilized, whats overutilized, whos logged onto which nodes, which is performing well or poorly."
The new release supports the monitoring of Oracle RAC environments running on Oracle 8.0 and higher. Also, it supports Sybase Inc. databases.
The new version of Workbench introduces Backup Analyst for SQL Server. The technology applies up to 90 percent compression to backups. A built-in meter tells DBAs how much storage theyve saved with each backup. With the decreased physical I/O, the end result is faster backups, with response-time deductions in the range of 50 percent, according to Schumacher.
Backup Analyst also features encryption, applied during backup as a file wrapper. According to Schumacher, its Level RC5 encryption hasnt caused the performance dips that are typical with, for example, row-level encryption.
Click here for eWEEK.com Database Editor Lisa Vaas primer on database encryption.
One beta tester of Workbench 8.0, Alan Woodling, said that Embarcadero appears to have "really tuned up this backup and restore thing." Woodling is a DBA at a large restaurant chain that he declined to name. He uses DBArtisan Workbench to administer SQL Server databases, although hes sticking to Microsofts Enterprise Manager for backups.
"I use DBArtisan in a different perspective: Its my big troubleshooting tool," said Woodling, in Louisville, Ky. "It allows me to quickly get to the bottom of a problem, isolate it, see whats wrong, and in most cases, it lets me implement a fix quickly, efficiently and usually right the first time."
Click here for an archived version of eWEEK.coms recent eSeminar on Database Encryption.
In addition, the update delivers one improvement that Woodling asked for: the Data Monitor now lets users see threads when users access the database.
"You can see whats under the covers: Is it a Select or an Insert statement? How much CPU was used? How much memory? Is it taking too long?" Woodling said. "Initially, [the Data Monitor] was nothing more than seeing the truncated version of the syntax being run under the covers. Now it shows you the whole thing. Thats a big improvement to me."
Embarcadero will be hosting a free Webinar on the new product on Tuesday at 11 a.m. Pacific Time.
Check out eWEEK.coms Database Center at http://database.eweek.com for the latest database news, reviews and analysis.
Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.