We started collecting a count of all VLF across the enterprise and yes there were few with high counts. I know there are no SET guidelines on how many is too low or too high. After chatting with MVP Allen Kinsel (Blog|Twitter) and Kevin Conan (Twitter) I decided to fix using this threshold. You will […]
While troubleshooting unplanned SQL cluster failover few questions are asked commonly. When did the last failover occur? How frequently you failover (planned and unplanned)? Did this happen recently? All these questions can be answered by this query. Your output will depend on how frequently you recycle error log and retention of the error log. You […]
Database backup is one of the regular tasks DBA’s perform but few explore all the options that are built in the product. Instead of exploring and using built in switches I noticed DBA’s try writing custom scripts or buying third party tools. I explored some of the options and was able to do a full […]
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 […]