I was updating an Aireforge Advise fix script and as it's important that we're using the correct syntax, I double check everything. Including commands that I've been using for 18 years as they can change between versions. I checked a few articles including TechNet, Microsoft Docs and some popular forums. All of them referenced index create … Continue reading Is it “index create memory” or “index create memory (KB)”?
Like any issue, the cause of replication problems could be one of many, but checking what commands are being passed through the distributor is always worthwhile.
Indexes to improve the performance of SQL Server replication
For ease of maintenance and performance reasons, we always aim to standardised our SQL Server estates (some of which contain over 100 instances). Everything is synchronised for their specific workload pools, so all search servers and all reporting servers are identical etc. Not only do we standardise the hardware or the VMs, but we ensure … Continue reading Comparing SQL Server configurations with Aireforge Studio
I tend to use Redgate SQL Monitor when diagnosing hard to find issues or when helping teams to better understand their estates. Sometimes, we run into issues with the network during the installation which is usually down the Windows Management Instrumentation (WMI) ports. SQL Monitor uses WMI calls to get all the non SQL Server … Continue reading Testing WMI for Redgate SQL Monitor
I've worked on a few system that use replication and the same issues tend to crop up. There's a discussion on SQL Server Central about what needs to be improved, so I thought I'd share my experiences Better default indexes (See blog) Vote | Improve replication latency monitoring (built-in canary tables). Vote | QueryStore for … Continue reading Replication wish list
Scripts to create pull subscriptions, the pull jobs, start them and the code required to add them to the publication on the publisher.
I'm writing an article covering common SQL Server configuration issues and as I write about how Microsoft have addressed some of these in SQL Server 2016, I started thinking about what they've missed or what they should include in the next release, be it SQL Server 2018 or version 14. RCSI as the default isolation level … Continue reading Simple things SQL Servers is missing
OmniCompare CLI is a free application which enables users to run OmniCompare comparisons from 3rd party applications.