Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database
    • Storage

    Embarcadero Boosts Storage, Cross-Platform Capabilities of Database Admin Tool

    By
    Lisa Vaas
    -
    September 20, 2004
    Share
    Facebook
    Twitter
    Linkedin

      Embarcadero Technologies Inc. on Monday rolled out a version of its database administration platform that ups the ante in terms of storage, performance, backup and capacity management as well as adds backup and restore capabilities for Microsoft Corp.s SQL Server database.

      DBArtisan Workbench 8.0 has been fine-tuned to handle the latest database platforms, including IBMs “Stinger,” the codename for DB2 Universal Database 8.2, which became generally available earlier this month.

      /zimages/1/28571.gifClick here to read an interview with IBMs Jeff Jones, director of strategy for DB2, in which he explains the rationale behind freezing the price on Stinger.

      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.

      /zimages/1/28571.gifClick 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.”

      /zimages/1/28571.gifClick 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.

      /zimages/1/28571.gifCheck out eWEEK.coms Database Center at http://database.eweek.com for the latest database news, reviews and analysis.

      /zimages/1/77042.gif

      Be sure to add our eWEEK.com database news feed to your RSS newsreader or My Yahoo page

      Lisa Vaas
      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.

      MOST POPULAR ARTICLES

      Big Data and Analytics

      Alteryx’s Suresh Vittal on the Democratization of...

      James Maguire - May 31, 2022 0
      I spoke with Suresh Vittal, Chief Product Officer at Alteryx, about the industry mega-shift toward making data analytics tools accessible to a company’s complete...
      Read more
      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Applications

      Cisco’s Thimaya Subaiya on Customer Experience in...

      James Maguire - May 10, 2022 0
      I spoke with Thimaya Subaiya, SVP and GM of Global Customer Experience at Cisco, about the factors that create good customer experience – and...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×