Lesson Learned #8: Monitoring the geo-replicated databases.

We received multiple requests in order to have answered the following questions: Is there needed a maintenance plan for geo-replicated databases? How to monitor the geo-replicated databases Answering the question: “Is it needed a maintenance plan for geo-replicated databases?”, No, there is not needed because is you have a maintenance plan for rebuilding indexes and update statistics…


Lesson Learned #7: Monitoring the transaction log space of my database

In many support cases, our customers want to monitor the available space for the transaction log space for their database or to know what caused an error when the transaction is full. Unfortunately, there is not supported to use DBCC SQLPERF(LOGSPACE) nowdays. For this reason, I would like to share with you another view where you could find out…