This will be a quick post about a script to find replication metadata in detail. You need to run this in your distributor (where distribution database resides) server and filter in various ways depending on your needs. Also, modify the order based on what you are looking for. Run where distribution database resides
This post will give a practical solution with complete code to monitor SQL server transactional replication latency in real-time. My solution assumes you are using a common distribution agent. With the minor change, you can also implement this for independent distribution agents. This solution is an implementation of Kendra Little’s blog post. The concept is […]
Issue: I installed sql2014 enterprise edition with cu3 in the following machine. Just as a disclaimer I have been running a SQL 2012 edition on the same host without any issue with WMI counters. I could not see any WMI counters for sql2014. I tried perfmon.exe and also querying: Then I snipped through SQL server […]
This is a continuation of the series about deadlock. The first part was how you detect deadlock in SQL Server and collect that information. This part will be about reporting from the collected information. On the 2nd step of the job the code below will parse the XML and send .xdl file along with information in tabular format. […]
This will be a 2 part series about deadlock. The first part will be about how you detect deadlock in SQL Server and collect that information. The second part will be about reporting from the collected information. A deadlock is a transient event until one of the processes becomes a victim. Unless you persist all […]
