TroubleshootingSQL

Explaining the bits and bytes of Azure SQL

Menu

Skip to content
  • Home
  • WhoAmI
  • Facebook
  • LinkedIn
  • Twitter
  • Events
  • Videos

Tag Archives: Merge Replication

Monitoring Merge Agent performance using T-SQL

Posted on March 17, 2010 by Amit Banerjee

I have always loved writing T-SQL scripts and am ever-ready to write a T-SQL script when the opportunity presents itself. I just wrote another one for monitoring Merge Agent performance and spewing out some legible English to track the slow performing Merge Agents in your Replication Topology.

Read about it on:

http://blogs.msdn.com/repltalk/archive/2010/03/16/tracking-merge-agent-performance-using-distribution-database-system-tables.aspx

The script can be downloaded from either the above blog post or from the Script Center Gallery:

http://gallery.technet.microsoft.com/ScriptCenter/en-us/20467f5a-99f1-4313-9f12-6ac24346da14

Share this post:

  • Share on LinkedIn (Opens in new window) LinkedIn
  • Share on Facebook (Opens in new window) Facebook
  • Share on Threads (Opens in new window) Threads
  • Share on X (Opens in new window) X
  • Share on Reddit (Opens in new window) Reddit
  • Email a link to a friend (Opens in new window) Email
  • Share on WhatsApp (Opens in new window) WhatsApp
  • Share on Tumblr (Opens in new window) Tumblr
  • Share on Pinterest (Opens in new window) Pinterest
  • Share on Bluesky (Opens in new window) Bluesky
  • More
  • Print (Opens in new window) Print
  • Share on Pocket (Opens in new window) Pocket
  • Share on Telegram (Opens in new window) Telegram
Like Loading...
Posted in Replication, Scripts, TSQL | Tagged Merge Agent, Merge Replication, T-SQL

Search

Seek Count

  • 1,186,535

Facebook Page

Facebook Page

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1,354 other subscribers

Linked Servers

Facebook Fan Page Twitter RSS Feeds Feedburner Feeds LinkedIn Networked Blogs Google+

IAM

  • AI (1)
    • Perplexity (1)
  • Availability Group (3)
  • Azure (26)
  • Azure SQL Database (10)
  • Backup (24)
  • BigData (1)
  • Change Tracking (1)
  • Data Recovery (6)
  • Debugging (11)
  • Did you know (25)
  • Excel (11)
    • Power View (8)
  • IaaS (16)
  • Memory (9)
  • Microsoft (3)
  • Mirroring (4)
  • PaaS (9)
  • Performance (20)
    • Disk (2)
    • Query Tuning (8)
  • Power View (5)
  • PowerBI (2)
  • PowerPivot (7)
  • Replication (6)
  • Reporting Services (6)
    • PowerView (2)
  • Screencasts (1)
  • Scripts (73)
    • Monitoring (13)
    • Powershell (17)
    • TSQL (36)
    • WMI (11)
  • Security (1)
  • SQL Agent (1)
  • SQL How To (13)
  • SQL Myths (3)
  • SQL Server (52)
    • Best Practices (17)
  • SQL Server 2012 (14)
  • SQL Server 2014 (4)
  • SQL Server 2016 (7)
  • SQL Setup (12)
  • T-SQL Tuesday (10)
  • Tools (68)
    • Data Analysis (10)
    • Data Collection (20)
    • Monitoring (20)
      • System Health Session (9)
    • Troubleshooting (7)
  • Tools Tips and Tricks (13)
  • Troubleshooting SQL Issues (48)
  • Twost (13)
  • Webcasts and Events (38)
  • Wikis (15)

Spatial Map

Locations of visitors to this page

Transaction Log

February 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
232425262728  
« Oct    

Professional SQL Server 2012: Internals and Troubleshooting

Ghosted Posts

Category Azure

Azure Azure SQL Database Backup Best Practices Data Analysis Data Collection Data Recovery Debugging Did you know Excel IaaS Memory Monitoring PaaS Performance PowerPivot Powershell Power View Query Tuning Replication Reporting Services Scripts SQL How To SQL Server SQL Server 2012 SQL Server 2016 SQL Setup System Health Session T-SQL Tuesday Tools Tools Tips and Tricks Troubleshooting Troubleshooting SQL Issues TSQL Twost Webcasts and Events Wikis WMI

Creative Commons License
TroubleshootingSQL by Amit Banerjee is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.

Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • TroubleshootingSQL
    • Join 281 other subscribers
    • Already have a WordPress.com account? Log in now.
    • TroubleshootingSQL
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
%d