I recently got a customer call where the SQL 2008 Snapshot Agent appeared to hang when started from SSMS. As you can see, pop-up status window shows “Starting agent”. So, looks like its running, but it stays this way forever. Replication Monitor also shows as “Running”. If I double-click the I can zoom in on
Read More »
José Moreira Neto | SQL Server Escalation Services Automatic Identity Range Management Microsoft SQL Server automatically generates sequential numbers for new rows inserted in the table containing the identity column. Identity columns are normally included as part of Primary Keys, therefore the need to avoid duplicates. To use identity columns in a replication topology that
Read More »
Updated post on The process could not execute ‘sp_replcmds’
Transactional Replication Conversations When troubleshooting Transactional Replication performance break down the flow of data into 4 simultaneous conversation. Examine performance of each conversation. This will help verify where the bottleneck investigation should begin. 1) LogReader Reader thread is reading the Transaction Log via stored procedure sp_replcmds, a wrapper for xp_replcmds. It scans the transaction log
Read More »
Have you seen errors like these below when attempting to run SQL Replication Wizard or start a SQL Agent job? TITLE: Microsoft SQL Server Management Studio —————————— SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022) SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent
Read More »