Tuning SQL Server with Aireforge Studio Advise

Aireforge Blog

Configuring SQL Server to run at peak performance is a skill that can take years to learn. But when you need to configure and maintain tens, hundreds or even thousands of instances, it’s a task that can overwhelm even the most seasoned DBA.

The Advise module for Aireforge Studio helps to combats this. Advise analyzes your SQL Server instances and provides suggestions for optimization and best practices. Here, we’ll take a look at some of its key features and how it can improve the performance, security and stability of your SQL Server estate.

Advise offers support for all versions of SQL Server, as well as Azure SQL Database. It combines expert database analysis with a focus on ease of use. At Aireforge, our extensive database management experience underpins Advise’s recommendations. We’ve taken fundamental operational checks, along with best practices from our experience working on mission critical and high-transaction databases, and…

View original post 768 more words

Is it “index create memory” or “index create memory (KB)”?

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)”?

PowerShell script for en-GB, UK locale and GMT timezone

Here's a quick PowerShell script (more of a personal reminder) to set everything for the current user to English-GB, UK locale and GMT timezone. Unfortunately, this doesn't override the settings for the welcome screen or new users but that's just one dialog after the restart. Change Current User #Set home location to United Kingdom Set-WinHomeLocation … Continue reading PowerShell script for en-GB, UK locale and GMT timezone

Comparing SQL Server configurations with Aireforge Studio

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

Testing WMI for Redgate SQL Monitor

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

SQL Server on Linux and transactional replication

Many companies use transactional replication to scale out their database reads; which can get quite large and very expensive. Costs can be reduced by moving to SQL Server Web Edition, which is extremely cheap for what you get, but after that you only really save money by reducing the server count. As SQL Server 2017 … Continue reading SQL Server on Linux and transactional replication

Replication wish list

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) Built in canary tables for monitoring latency. I created some scripts I call … Continue reading Replication wish list