Azure SQL Database and Azure SQL Managed Instance both are Azure’s PaaS implementations whereby Microsoft takes care of all management tasks of underlying systems. Automatic
Starting from scratch on cloud platform is quite easier when you need to setup a database say on Azure but the moment discussions start happening
Note: Practical guide here doesn’t mean a step-by-step approach to setup the service/feature but to mention the important points which are critical to understand for
Active Geo Replication is a database-level feature specific to Azure SQL Databases. It creates a secondary replica of your primary database which can be used
In the previous post we saw number of queries to analyze data captured by Query Store. In this post, we will present the data model
We have seen so far in the previous posts about the key concepts of Query Store and its configuration. Let’s now look at the queries
In the previous post we learnt about some basic concepts of SQL Server query store and some of the usage scenarios. In this post we
SQL Server’s Query Store is generally considered as its flight recorder i.e. that black box which records everything about each query you execute on SQL
More significant for Azure SQL Database to determine who all are connected from which IP address and how many connections sys.dm_exec_sessions and sys.dm_exec_connections
This is similar to what we saw in SQL Script to Check Most Executed Queries in a SQL Server Database post with the difference that
sys.dm_exec_query_stats sys.dm_exec_sql_text to fetch the exact query sys.dm_exec_query_plan to fetch the query plan And again Thanks to Glenn Berry for sharing the script.
sys.indexes, sys.objects and sys.dm_db_index_usage_stats Checks where writes are greater than the reads i.e. index maintenance is higher than the benefit it is serving during read
sys.partitions and sys.objects Consider ONLY Heap or Clustered Index that gives you the count Thanks to Glenn Berry for sharing the script.
When was the last time statstics were updated for a particular index You can filter it as per you needs to run it faster or
This may take some time to get executed if the database size is large You may filter it for some specific cases to run it