Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning

Organizations may have many concerns about performance when migrating databases to Azure. Fortunately, Microsoft provides some great tools to help improve performance and save money. In this article, Monica Rathbun explains how to take advantage of these features.

Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning

Organizations may have many concerns about performance when migrating databases to Azure. Fortunately, Microsoft provides some great tools to help improve performance and save money. In this article, Monica Rathbun explains how to take advantage of these features.

Automatic Query Performance Tuning in SQL Server Database

In this article Anoop Kumar discusses Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.

Azure Defaults

Automatic tuning options

Enabling Automatic Tuning

Automatic Plan Correction

SQL Server 2017 lets you solve parameter sniffing problems - Automatically!

Fixing Plan Issues in the Middle of the Night

Do you hate when someone wakes you up in the middle of the night and tells you that some query is slower and you need to investigate it? With SQL Server 2017 you might easily do this, or even let SQL Server do this job for you.

RE: SQL Server Maintenanace Plans

I wrote my own. For the simple reason that the maintenance plans are not sufficient enough. You need to create different maintenance plans for different kind of databases etc.I created some scheduled job's for dumping the database, dumping the logs for databases that have the 'Full' option, re-indexing the databases, checking the databases and update […]

RE: AWE and MaxMem settings for SQL2K on WS2003-OS Clustered

From MSDN:On 32-bit versions of Windows, PAE is disabled by default. You must use the /pae boot parameter to enable PAE. However, PAE is automatically enabled when the computer is configured for hot-add memory devices in memory ranges beyond the 4 GB region, as defined by the Static Resource Affinity Table (SRAT). Hot-add memory supports memory […]