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

    Microsoft Boosts Azure SQL Premium with In-Memory Technology

    By
    Pedro Hernandez
    -
    November 11, 2016
    Share
    Facebook
    Twitter
    Linkedin
      Azure SQL 2

      Azure SQL’s in-memory capabilities are now generally available, Microsoft announced this week, setting the stage for brisk and advanced cloud-based analytics.

      As the term suggests, in-memory processing relies on data stored in a RAM to accelerate database performance. Rather than wait for data to wend its way from storage components and arrays to a server’s processor, in-memory databases can access information much more rapidly courtesy of a server’s own memory bus and its comparatively faster data transfer speeds.

      Accordingly, in-memory database servers are often outfitted with massive amounts of RAM. For example, in a “scale-up” configuration, Hewlett Packard Enterprise’s (HPE) ConvergedSystem 900 systems for SAP HANA, the German business software maker’s in-memory database, can contain up to 16 TB of system memory.

      Microsoft is now offering in-memory support to Azure SQL customers with Premium database tier subscriptions. And those customers can expect a big performance boost, according to Rohan Kumar, general manager of Microsoft’s Database Systems group.

      “In-memory technology helps optimize the performance of transactional (OLTP), analytics (OLAP), as well as mixed workloads (HTAP),” wrote Kumar in a blog post. “These technologies allow you to achieve phenomenal performance with Azure SQL Database—75,000 transactions per second for order processing (11X [performance] gain) and reduced query execution time from 15 seconds to 0.26 (57X [performance gain]).”

      Further, customers can use Azure SQL’s in-memory features to blaze through database workloads at no extra cost, he added. For example, customers under a P2 database plan can achieve 9X and 10X improvements in transactions and analytics queries, respectively, without paying extra.

      A handful of features comprise Azure SQL’s newfound performance-boosting capabilities, including in-memory OLTP (online transaction processing). This latency-reducing technology increases data throughput, enabling high-speed trading and rapid data ingestion from internet of things (IoT) devices.

      Another feature, clustered columnstore indexes, slashes data storage footprints by up to 10X, accelerating reporting and analytics workloads, claimed Kumar. Used with Hybrid Transactional and Analytical Processing (HTAP), Azure SQL’s non-clustered columnstore indexes that forego the time-consuming extract, transform, load (ETL) process, enabe real-time analytics that query the operational database directly.

      Of course, the competition isn’t sitting still.

      On Nov. 8, SAP announced the impeding release of HANA 2, the follow-up to the company’s cloud-friendly, in-memory computing platform. HANA is a big moneymaker for SAP, growing into a near-$2 billion business since it was introduced in December 2010.

      On Nov. 30, the company plans to release a new version of the blisteringly fast database, complete with new artificial intelligence algorithms and bring-your-own-language capabilities intended to help developers build and deploy a new generation of intelligent applications.

      Mirroring the white-hot container development trend, customers can also expect new SAP HANA microservices in the cloud. They include a batch of text and natural language data processing features (Text Analysis Entity Extraction, Text Analysis Fact Extraction and Text Analysis Linguistic Analysis) along with a new Earth Observation Analysis service. The latter, available in beta, uses satellite data from the European Space Agency (ESA) enabling researchers to analyze historic information about the world’s vegetation, soil and water conditions.

      Pedro Hernandez
      Pedro Hernandez is a contributor to eWEEK and the IT Business Edge Network, the network for technology professionals. Previously, he served as a managing editor for the Internet.com network of IT-related websites and as the Green IT curator for GigaOM Pro.

      MOST POPULAR ARTICLES

      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
      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
      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
      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
      Cloud

      Yotascale CEO Asim Razzaq on Controlling Multicloud...

      James Maguire - May 5, 2022 0
      Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
      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.
      © 2021 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.

      ×