Close
  • Latest News
  • Artificial Intelligence
  • 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
  • Artificial Intelligence
  • 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 Cloud
    • Cloud

    Improved Performance Monitoring Comes to Azure SQL Data Warehouse

    By
    Pedro Hernandez
    -
    April 12, 2018
    Share
    Facebook
    Twitter
    Linkedin
      Microsoft

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

      Azure SQL Data Warehouse, Microsoft’s elastic, cloud-based data warehousing offering for big data workloads, is now offering its customers more detailed performance insights.

      The service supports Azure Monitor, revealed Kevin Ngo, program manager of SQL Engineering at Microsoft, in an April 12 announcement. As its name suggests, Azure Monitor is a performance monitoring tool that allows customers to keep track of resource utilization and determine the health of their cloud resources.

      The integration “not only enables you to monitor your data warehouse within the Azure portal, but its tight integration between Azure services also enables you to monitor your entire data analytics solution within a single interface,” Ngo added.

      Providing up-to-the-minute metrics, Azure Monitor allows users to view CPU consumption and IO (input/output) in near real time, revealing potential bottlenecks that affect performance. Users can also track DWU (data warehouse unit) utilization statistics, including the number of DWUs used for a given workload, or analyze historical data. By default, Azure Monitor retains data warehouse metrics for 90 days.

      Azure SQL Data Warehouse also features tighter integration with Azure Analysis Services, a cloud-based analytics engine. Using the Azure Portal management hub, users can simply click on the Model and Cache Data button in the Task view to build semantic models based on information stored in the service.

      Finally, Microsoft rolled out a new feature that can help organizations trim their cloud costs during times of low activity.

      Azure SQL Data Warehouse includes a pause feature that shuts down the service’s compute functionality. An alert will appear in the Azure Portal if it detects active queries before pausing the service, which can cause interruptions to end-user applications, explained Ngo.

      Database Backup Flexibility, New Purchasing Model

      Microsoft has steadily been bulking up its cloud data platform ecosystem, including some recent changes to Azure SQL Database’s long-term backups.

      The service’s backup retention allows customers to manage database backups for up to 10 years. Now, instead of requiring users to deploy and manage a Backup Service Vault for this purpose, SQL Database will now use Azure Blob storage, Microsoft’s object storage solution.

      “This new design will enable flexibility for your backup strategy, and overall more control over costs,” noted Alexander Nosov, principal program manager of Azure SQL Database at Microsoft, in a blog. The switch to Blob Storage will allow organizations in all Azure regions to access the service’s long-term retention and data protection capabilities and enable users to configure policies that support weekly, monthly, yearly and “week-within-a-year backups,” he added.

      Finally, Microsoft is giving customers a new way to configure and pay for their Azure SQL Databases. Organizations can use the company’s new vCore-based purchasing model for their Azure SQL Database elastic pools or single database deployments.

      Under v-Core, users can select between two tiers of service, General Purpose and Business Critical, both of which allow organizations to independently configure the underlying compute and storage resources to strike a suitable balance between price and performance. Microsoft will continue to support the existing DTU (Database Transaction Unit) model and its preconfigured bundles.

      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.

      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

      10 Best AI 3D Generators 2023

      Aminu Abdullahi - November 17, 2023 0
      AI 3D Generators are powerful tools for creating 3D models and animations. Discover the 10 best AI 3D Generators for 2023 and explore their features.
      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
      Applications

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

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      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.

      ×