Ad Widget

Collapse

To receive undistributed commands value in MS SQL Server.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cancer_zern
    Member
    • Apr 2015
    • 36

    #1

    To receive undistributed commands value in MS SQL Server.

    It is necessary to receive undistributed commands value in MS SQL Server.

    Through ODBC there are not enough rights.

    Code:
    USE DISTRIBUTION
    GO
    EXECUTE sp_replmonitorsubscriptionpendingcmds  
      @publisher ='publisher', -- Put publisher server name here
      @publisher_db = 'publisher_db', -- Put publisher database name here
      @publication ='publication',  -- Put publication name here
      @subscriber ='subscriber', -- Put subscriber server name here
      @subscriber_db ='subscriber_db', -- Put subscriber database name here
      @subscription_type ='1' -- 0 = push and 1 = pull


    For some reason did not find this counter in perf_counter.
    Whether there is still a way to receive value?

Working...