sp_MSdistribution_counters RRS feed

  • Question

  • Hi, Can anyone please provide details about sp_MSdistribution_counters. I cant find this SP in bookonline though I can search it into non MS sources but why it is no documented into MS tech library.

    Kindly mark the reply as answer if they help
    • Edited by Sunil Gure Tuesday, January 17, 2012 3:04 AM typo
    Tuesday, January 17, 2012 3:03 AM


All replies

  • Hi,

    You cannot find any documentation as it looks like this is an undocumented proc. Sometimes these commands are in the product just for Microsoft's own internal use, other times there was simply not enough time to document them before the release.

    If you make use of them you do so at your own risk and you need to understand that MS may remove that proc at any time or make other changes to the proc that might break your scripts.

    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog or Twitter.
    Please click the Mark as Answer button if a post solves your problem!

    Tuesday, January 17, 2012 9:53 AM
  • It is an internal stored procedure that gives stats on current state of the distributor on a per publisher basis.

    What in specific are you curious about?

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Marked as answer by Sunil Gure Wednesday, January 18, 2012 1:36 AM
    Tuesday, January 17, 2012 12:04 PM
  • Thanks Hilary, I was using it for this purpose only for time being. I will writing a query using DMVs to find replication statistics.
    Kindly mark the reply as answer if they help
    Wednesday, January 18, 2012 1:37 AM