Hello! Changes to dbatools Functions What I Wrote As the saying goes, it never rains but it pours. And there’s been a flurry of activity on a few of the functions that I initially contributed late last December to dbatools. Up to this point, there have been very few changes pushed and issues raised. However fom the middle of October to the beginning of November there’s been about 15 issues/pr’s. Extraordinary!
Earlier this year, I wrote a long post about log shipping. One of the key points I mentioned was how slow restoring can be for a read only log shipped database. If going and reading the whole thing is too much effort for you now, I’ll save you the effort (you child of the internet you) and tell you it’s because the database needs to be kept transactionally consistent in between restores when making it available for read-only. It creates a .tuf file (transaction undo file) to keep the progress of all the pages that have uncommitted transactions saved to them. The checking, creation, applying and re-applying of this can take some time where there is a significant amount of uncommitted transactions within a log backup.
So it’s been a while since I’ve worked on any SSAS, but today I am happy to announce that there is an up-to-date version of the SSAS Activity Monitor. The solution has had couple of changes to it.