Using “Verbose history agent profile.” while troubleshooting Replication

Using “Verbose history agent profile.” while troubleshooting Replication by Chris Skorlinski Microsoft SQL Server Escalation Services The “default” Agent Profile enables “-HistoryVerboseLevel 1” which provides limited detail in the Distribution database history tracking tables. Using Replication Agent Profile “Verbose history agent profile.” enables “-HistoryVerboseLevel 2” which provides additional diagnostic data while troubleshooting SQL Server Replication. …


TSQL Scripts to Analyze Merge Replication Filter Logic

TSQL Scripts to Analyze Merge Replication Filter Logic Provided by: Suresh B. Kandoth, SR Escalation Engineer, Microsoft SQL Escalation Services These 2 scripts are used by the SQL Server Replication Support team to help analyze the Filter Logic used in Merge Replication.  The first lists all defined Subset and Join filters.  The first listing shows…


Success Pattern for V-Teams

Note: This article is updated at 6 Success Patterns for V-Teams What is the success pattern for leading a successful v-team?  I asked one of my mentors, a seasoned softie for his take on what are the keys to a successful v-team.  Here is what he had to say: you’re building a coalition — not…


Workshop Planning Framework – The Six P’s

Note: This article is updated at The Six P’s Workshop Planning Framework. Workshops are one of the best ways to rapidly brainstorm ideas, capture scenarios, mine for patterns, etc.  The challenge can be designing an effective workshop. In the book Scenarios, Stories, Use Cases: Through the Systems Development Life-Cycle, Ian F. Alexander and Neil Maiden…


What is a PM?

Note: This article is updated at What is a Program Manager? What is a PM (Program Manager)?  While the Program Manager role seems unique to Microsoft, in general, when you map it to other companies, it’s a product manager, or a project manager, or a combination of the two.  At Microsoft, there are various flavors…


Merge Replication Capacity Planning

  Merge Replication Capacity Planning Chris Skorlinski Microsoft SQL Server Escalation Services I was recently asked for recommendations for Merge Replication capacity planning project.  While I spend most of my time tuning and troubleshooting Replication environments, I decided to post some thoughts on about stress testing and capacity planning.  I hope this posting helps as…


Key Questions for a PM at patterns & practices

Note: This article is updated at Program Manager Abilities at a Glance. I was looking for some of my old job descriptions for PM positions in patterns & practices to help out a colleague.  While I didn’t find them, I did find some of the questions that I have used to evaluate PM effectiveness: Project…


Replication Data Collection Scripts

Replication Data Collection Scripts Chris Skorlinski Microsoft SQL Server Escalation Services The Microsoft SQL Server Support team uses various scripts to collect Replication and Performance data from customer’s SQL Servers.  These scripts extract data into either text files or into temporary databases which are then backed up and sent to Microsoft SQL Engineer for analysis. …


Improve Snapshot Performance by changing MaxBcpThreads

  posted by: Chris Skorlinski, Microsoft SQL Server Escalation Services content provided by: Akbar Farishta, Technical Lead, Microsoft SQL Server Support I wanted to post an update to Snapshot Agent Performance –MaxBCPThreads blog posting.  We recently encounter a performance problem trying to push a 120gig snapshot down to a subscriber.  The Distribution Agent was taking…