Replication – Snapshot is not getting generated

Replication issues and resolutions Today I have encountered very strange issue – Scenario – Snapshot is not getting generated for newly added articles or Error when setting up Transactional Replication via SQL scripts. Msg  14100, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 533 Specify all articles when subscribing to a publication using concurrent snapshot processing. Step performed to… Read More Replication – Snapshot is not getting generated

Configuring deadlock and Storing Deadlock events in a table

Configuring deadlock and Storing Deadlock events in a table SQL Server 2012 and above. Verification – Ensure Extended Event “system_health” is running. SSMS, checking Management -> Extended Events -> Sessions. These should be green arrow which indicate its running.   The system_health session writes to two targets, both an event file and the ring buffer:  … Read More Configuring deadlock and Storing Deadlock events in a table