Close
  • Latest News
  • Artificial Intelligence
  • Video
  • 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
Subscribe
Logo
  • Latest News
  • Artificial Intelligence
  • Video
  • 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
    Subscribe
    Home Database
    • Database

    Microsoft Boosts Azure SQL Premium with In-Memory Technology

    Written by

    Pedro Hernandez
    Published November 11, 2016
    Share
    Facebook
    Twitter
    Linkedin

      eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

      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
      Pedro Hernandez is a writer for 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.

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      MOST POPULAR ARTICLES

      Artificial Intelligence

      9 Best AI 3D Generators You Need...

      Sam Rinko - June 25, 2024 0
      AI 3D Generators are powerful tools for many different industries. Discover the best AI 3D Generators, and learn which is best for your specific use case.
      Read more
      Cloud

      RingCentral Expands Its Collaboration Platform

      Zeus Kerravala - November 22, 2023 0
      RingCentral adds AI-enabled contact center and hybrid event products to its suite of collaboration services.
      Read more
      Artificial Intelligence

      8 Best AI Data Analytics Software &...

      Aminu Abdullahi - January 18, 2024 0
      Learn the top AI data analytics software to use. Compare AI data analytics solutions & features to make the best choice for your business.
      Read more
      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Video

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      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.
      © 2024 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.