Category: Azure SQL Database
Below is a script I commonly use to check for the free space in every file of a SQL Server database. The column headings are self-explanatory. Note that this can also be used for Azure SQL Database and Azure SQL Managed Instance.
SQL Server Data Compression feature lets you compress tables and individual indexes. The compression does incur a few extra CPU cycles every time you read or write to that table or index, but this overhead is hugely compensated by much better IO performance. In most cases, increasing a little more work for the CPU for…
One of the very common topic for support cases which we receive at Microsoft is around customers trying to understand the cause of high DTU for their Azure SQL Database. In this blog, I want to share the steps we follow, almost always, to approach a high DTU issue. The most important thing to understand…
I have personally been a huge fan of Query Store ever since it was released with SQL Server 2016. It helps me simplify performance troubleshooting as it asynchronously captures a history of queries, plans and run time statistics, and stores this information within the database itself – which means that this data persists across server…
Below is a script you can use to update all statistics with a full scan in a SQL Server database. This comes in super-handy for Azure SQL Databases and SQL Server Express Editions, as we don’t support Maintenance Plans with both. Alternatively, if you wish to update only out-of-date statistics then consider implementing MSSQL Tiger…
Below is a script you can use to rebuild all indexes in a SQL Server database. This comes in super-handy for Azure SQL Databases and SQL Server Express Editions, as we don’t support Maintenance Plans with both. Alternatively, if you wish to rebuild only fragmented indexes then consider implementing MSSQL Tiger Team’s AdaptiveIndexDefrag solution to…