SQL Server Performance

Replication Status

Discussion in 'Performance Tuning for SQL Server Replication' started by TALAT, Apr 3, 2004.

  1. TALAT New Member

    Hi Folks, I need to query MSDB to check the status of Replication(Merge-Agent) to extract the last replication status(succeeded or failed, when did it start, how many inserts-updates and duration, etc) I want these details to be embedded in a VB application so that they could see the replication status rather to allow access them to enterprise-manager. I also need to facilitate the appication to start and stop the merge agent. Please post the details. Thanx in advance.
  2. Twan New Member

    I havent ever had to do this, but I'd look at WMI or SQL DMO as a possible way of achieving this rather than querying system tables...

    from BOL
    >>>>>>
    The SQL Server WMI support is not installed by SQL Server 2000 Setup. All of the WMI materials, including a separate setup and documentation, are included in the folder x86OTHERwmi on the SQL Server 2000 compact disc.
    >>>>>>

    Cheers
    Twan
  3. TALAT New Member

    I've tried lookin at it but couldn't..., too many gray areas. If anybody could guide more precisely plz!!!
    Thanx.
  4. satya Moderator

    Have you tried to instal WMi as referred by Twan.

    Refer to the books online for system supplied stored procedures on Replication process, rather querying the system database as suggested.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. TALAT New Member

    When i execute WMI setup a dialog-box appears saying please wait while windows configure WMI SQL Server provider.Then it disappears. Now what to do and where to start from. Sorry for little knowledge, so bear with me. Haven't use this before. Now where to start from.
    Thanx.[:I]
  6. satya Moderator

Share This Page