Released: Azure SQL DB Management Pack (7.0.26.0)

Published Oct 20 2020 06:44 AM 1,412 Views
Microsoft

We released a new version of SCOM Management Pack for Azure SQL DB. The biggest change is that it now supports vCore-based pricing tier for Azure SQL DB. This model was introduced after the last Azure SQL DB MP release so the previous MP (7.0.4.0) doesn't work with it.

 

Please download at:

Microsoft System Center Management Pack for Microsoft Azure SQL Database

 

What's New

  • Added support of vCore-based pricing tier
  • Added filtering list for SQL Servers and Databases to "Add Monitoring Wizard" template
  • Updated the token renewal algorithm to get rid of 401 responses
  • Updated Core Library MP and the “Summary” Dashboard
  • Removed deprecated workflows
  • Updated display strings

Issues Fixed

  • Fixed an issue with Elastic Pool performance data on vCore-based pricing tiers
  • Fixed an issue with an unnecessary slash symbol in some requests to Azure REST API
  • Fixed monitoring issues for databases that are replicated by failover groups and elastic pools
  • Fixed issue: datediff used for Long-Running Transactions monitoring results in overflow in some environments

We are looking forward to hearing your feedback.

 

1 Comment
Occasional Visitor

Tried importing this into new SCOM 2019 UR2 environment with SQL 2019 UR9 and getting this error:   Database error. MPInfra_p_ManagementPackInstall failed with exception:
[MP ID: 19f0a584-8bde-2a36-e607-05060e04959a][MP Version: 7.0.26.0][MP PKT: 31bf3856ad364e35] Database error. MPInfra_p_ManagementPackInstall failed with exception:
Conversion failed when converting from a character string to uniqueidentifier.

%3CLINGO-SUB%20id%3D%22lingo-sub-1799488%22%20slang%3D%22en-US%22%3EReleased%3A%20Azure%20SQL%20DB%20Management%20Pack%20(7.0.26.0)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1799488%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%224%22%3EWe%20released%20a%20new%20version%20of%20SCOM%20Management%20Pack%20for%20Azure%20SQL%20DB.%26nbsp%3B%3CSPAN%3EThe%20biggest%20change%20is%20that%20it%20now%20supports%20vCore-based%20pricing%20tier%20for%20Azure%20SQL%20DB.%26nbsp%3B%3C%2FSPAN%3EThis%20model%20was%20introduced%20after%20the%20last%20Azure%20SQL%20DB%20MP%20release%20so%20the%20previous%20MP%20(7.0.4.0)%20doesn't%20work%20with%20it.%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3EPlease%20download%20at%3A%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D38829%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CFONT%20size%3D%224%22%3EMicrosoft%20System%20Center%20Management%20Pack%20for%20Microsoft%20Azure%20SQL%20Database%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%3EWhat's%20New%3C%2FFONT%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EAdded%20support%20of%20vCore-based%20pricing%20tier%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EAdded%20filtering%20list%20for%20SQL%20Servers%20and%20Databases%20to%20%22Add%20Monitoring%20Wizard%22%20template%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EUpdated%20the%20token%20renewal%20algorithm%20to%20get%20rid%20of%20401%20responses%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EUpdated%20Core%20Library%20MP%20and%20the%20%E2%80%9CSummary%E2%80%9D%20Dashboard%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3ERemoved%20deprecated%20workflows%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EUpdated%20display%20strings%3C%2FFONT%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%3EIssues%20Fixed%3C%2FFONT%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20an%20issue%20with%20Elastic%20Pool%20performance%20data%20on%20vCore-based%20pricing%20tiers%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20an%20issue%20with%20an%20unnecessary%20slash%20symbol%20in%20some%20requests%20to%20Azure%20REST%20API%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20monitoring%20issues%20for%20databases%20that%20are%20replicated%20by%20failover%20groups%20and%20elastic%20pools%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20issue%3A%20datediff%20used%20for%20Long-Running%20Transactions%20monitoring%20results%20in%20overflow%20in%20some%20environments%3C%2FFONT%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%3EWe%20are%20looking%20forward%20to%20hearing%20your%20feedback.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1799488%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%224%22%3EWe%20released%20a%20new%20version%20of%20SCOM%20Management%20Pack%20for%20Azure%20SQL%20DB.%26nbsp%3B%3CSPAN%3EThe%20biggest%20change%20is%20that%20it%20now%20supports%20vCore-based%20pricing%20tier%20for%20Azure%20SQL%20DB.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1799488%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLReleases%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2202690%22%20slang%3D%22en-US%22%3ERe%3A%20Released%3A%20Azure%20SQL%20DB%20Management%20Pack%20(7.0.26.0)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2202690%22%20slang%3D%22en-US%22%3E%3CP%3ETried%20importing%20this%20into%20new%20SCOM%202019%20UR2%20environment%20with%20SQL%202019%20UR9%20and%20getting%20this%20error%3A%26nbsp%3B%20%26nbsp%3BDatabase%20error.%20MPInfra_p_ManagementPackInstall%20failed%20with%20exception%3A%3CBR%20%2F%3E%5BMP%20ID%3A%2019f0a584-8bde-2a36-e607-05060e04959a%5D%5BMP%20Version%3A%207.0.26.0%5D%5BMP%20PKT%3A%2031bf3856ad364e35%5D%20Database%20error.%20MPInfra_p_ManagementPackInstall%20failed%20with%20exception%3A%3CBR%20%2F%3EConversion%20failed%20when%20converting%20from%20a%20character%20string%20to%20uniqueidentifier.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Oct 20 2020 06:44 AM
Updated by: