3

Released: SQL Server Replication Management Pack (7.0.28.0)

 3 years ago
source link: https://techcommunity.microsoft.com/t5/sql-server/released-sql-server-replication-management-pack-7-0-28-0/ba-p/2019871?WT_mc_id=DOP-MVP-4025064
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Released: SQL Server Replication Management Pack (7.0.28.0)%3CLINGO-SUB%20id%3D%22lingo-sub-2019871%22%20slang%3D%22en-US%22%3EReleased%3A%20SQL%20Server%20Replication%20Management%20Pack%20(7.0.28.0)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%3EThis%20release%20brings%20support%20for%20older%20SQL%20Server%20versions%20(2012%2C%202014%2C%202016)%20into%20the%20version%20agnostic%20MP.%20That%20is%2C%20going%20forward%20just%20like%20SQL%20Server%20MP%2C%20we%20will%20have%20version-agnostic%20Replication%20MP%20that%20can%20monitor%20all%20SQL%20Server%20versions%20in%20support.%20This%20is%20the%20last%20MP%20in%20SQL%20Server%20MP%20family%20to%20move%20to%20full%20version-agnostic%20mode.%26nbsp%3B%3C%2FSPAN%3E%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%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%20color%3A%20%23333333%3B%22%3E%3CFONT%20size%3D%224%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D56204%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20System%20Center%20Management%20Pack%20for%20SQL%20Server%20Replication%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%20color%3A%20%23333333%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%20color%3A%20%23333333%3B%22%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%3EUpdated%26nbsp%3BMP%26nbsp%3Bto%26nbsp%3Bsupport%26nbsp%3BSQL%26nbsp%3BServer%26nbsp%3B2012%26nbsp%3Bthrough%26nbsp%3B2019%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EUpdated%26nbsp%3B%22Replication%26nbsp%3BAgents%26nbsp%3Bfailed%26nbsp%3Bon%26nbsp%3Bthe%26nbsp%3BDistributor%22%26nbsp%3Bunit%26nbsp%3Bmonitor%26nbsp%3Bto%26nbsp%3Bextend%26nbsp%3Bit%26nbsp%3Bfor%20Log%26nbsp%3BReader%26nbsp%3Band%26nbsp%3BQueue%26nbsp%3BReader%26nbsp%3Bagents%26nbsp%3Bdetection%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EAdded%26nbsp%3Bnew%26nbsp%3Bproperty%26nbsp%3B'DiskFreeSpace'%26nbsp%3Bfor%26nbsp%3B%22Publication%26nbsp%3BSnapshot%26nbsp%3BAvailable%26nbsp%3BSpace%22%26nbsp%3Bunit%26nbsp%3Bmonitor%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3ERemoved%26nbsp%3B%22One%26nbsp%3Bor%26nbsp%3Bmore%26nbsp%3Bof%26nbsp%3Bthe%26nbsp%3BReplication%26nbsp%3BAgents%26nbsp%3Bare%26nbsp%3Bretrying%26nbsp%3Bon%26nbsp%3Bthe%26nbsp%3BDistributor%22%26nbsp%3Bmonitor%26nbsp%3Bas%26nbsp%3Bnon-useful%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3ERemoved%20%E2%80%9CAvailability%20of%20the%20Distribution%20database%20from%20a%20Subscriber%E2%80%9D%20monitor%20as%20deprecated%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EUpdated%26nbsp%3Bdisplay%26nbsp%3Bstrings%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%20discovery%20issue%20on%20SQL%20Server%202019%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20issue%20with%20the%20incorrect%20definition%20of%20'MachineName'%20property%20of%20DB%20Engine%20in%20some%20discoveries%20and%20replication%20agent-state%20unit%20monitors%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20issue%20with%20wrong%20property-bag%20key%20initialization%20on%20case-sensitive%20DB%20Engine%20in%20some%20unit%20monitors%20and%20performance%20rules%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20issue%20with%20the%20critical%20state%20of%20%22Replication%20Log%20Reader%20Agent%20State%20for%20the%20Distributor%22%20and%20%22Replication%20Queue%20Reader%20Agent%20State%20for%20Distributor%22%20unit%20monitors%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20wrong%20space%20calculation%20in%20%22Publication%20Snapshot%20Available%20Space%22%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20duplication%20of%20securable%20detection%20for%20monitor%20%22Subscriber%20Securables%20Configuration%20Status%22%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20issue%20with%20the%20incorrect%20definition%20of%20'InstanceName'%20property%20in%20%22Replication%20Database%20Health%22%20discovery%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%26nbsp%3Bissue%26nbsp%3Bwith%26nbsp%3Ban%20incorrect%26nbsp%3Balert%26nbsp%3Bmessage%26nbsp%3Bfor%26nbsp%3Bmonitor%20%22Pending%26nbsp%3BCommands%26nbsp%3Bon%26nbsp%3BDistributor%E2%80%9D%3C%2FFONT%3E%3C%2FLI%3E%0A%3CLI%3E%3CFONT%20size%3D%224%22%3EFixed%20issue%20with%20incorrect%20condition%20detection%20for%20monitor%20%22Total%20daily%20execution%20time%20of%20the%20Replication%20Agent%22%3C%2FFONT%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2019871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20size%3D%224%22%3E%3CSPAN%3EThis%20release%20brings%20support%20for%20older%20SQL%20Server%20versions%20(2012%2C%202014%2C%202016)%20into%20the%20version%20agnostic%20MP.%20That%20is%2C%20going%20forward%20just%20like%20SQL%20Server%20MP%2C%20we%20will%20have%20version-agnostic%20Replication%20MP%20that%20can%20monitor%20all%20SQL%20Server%20versions%20in%20support.%20This%20is%20the%20last%20MP%20in%20SQL%20Server%20MP%20family%20to%20move%20to%20full%20version-agnostic%20mode.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2019871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLReleases%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E

This release brings support for older SQL Server versions (2012, 2014, 2016) into the version agnostic MP. That is, going forward just like SQL Server MP, we will have version-agnostic Replication MP that can monitor all SQL Server versions in support. This is the last MP in SQL Server MP family to move to full version-agnostic mode. 

Please download at:

Microsoft System Center Management Pack for SQL Server Replication

What's New

  • Updated MP to support SQL Server 2012 through 2019
  • Updated "Replication Agents failed on the Distributor" unit monitor to extend it for Log Reader and Queue Reader agents detection
  • Added new property 'DiskFreeSpace' for "Publication Snapshot Available Space" unit monitor
  • Removed "One or more of the Replication Agents are retrying on the Distributor" monitor as non-useful
  • Removed “Availability of the Distribution database from a Subscriber” monitor as deprecated
  • Updated display strings

Issues Fixed

  • Fixed discovery issue on SQL Server 2019
  • Fixed issue with the incorrect definition of 'MachineName' property of DB Engine in some discoveries and replication agent-state unit monitors
  • Fixed issue with wrong property-bag key initialization on case-sensitive DB Engine in some unit monitors and performance rules
  • Fixed issue with the critical state of "Replication Log Reader Agent State for the Distributor" and "Replication Queue Reader Agent State for Distributor" unit monitors
  • Fixed wrong space calculation in "Publication Snapshot Available Space"
  • Fixed duplication of securable detection for monitor "Subscriber Securables Configuration Status"
  • Fixed issue with the incorrect definition of 'InstanceName' property in "Replication Database Health" discovery
  • Fixed issue with an incorrect alert message for monitor "Pending Commands on Distributor”
  • Fixed issue with incorrect condition detection for monitor "Total daily execution time of the Replication Agent"

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK