Dynamic management view
A dynamic management view (DMV) exposes server and database state for diagnosing performance and health. DP-300 covers identifying performance issues using DMVs.
All DP-300 Terms
Azure SQL Database
Azure SQL Database is a fully managed platform-as-a-service relational database.
Azure SQL Managed Instance
Azure SQL Managed Instance is a managed deployment option with near-complete SQL Server compatibility.
Transact-SQL
Transact-SQL (T-SQL) is Microsoft's SQL dialect used to query and administer SQL databases.
Transparent Data Encryption
Transparent Data Encryption (TDE) encrypts SQL database files at rest without application changes.
Always Encrypted
Always Encrypted protects sensitive column data so it is never revealed in plaintext to the database engine.
Dynamic data masking
Dynamic data masking obscures sensitive data in query results for non-privileged users without changing stored data.
Row-level security
Row-level security restricts which rows a user can access based on their identity or role.
Query Store
Query Store captures query execution plans and runtime statistics over time to diagnose performance regressions.
Dynamic management view
A dynamic management view (DMV) exposes server and database state for diagnosing performance and health.
Execution plan
An execution plan shows how the SQL engine executes a query, used to find inefficiencies.
SQL Server Agent
SQL Server Agent is a service that schedules and runs automated administrative jobs.
Elastic job
An elastic job runs scheduled T-SQL tasks across many Azure SQL databases.
Always On availability group
An Always On availability group provides high availability and disaster recovery by replicating databases across replicas.
Active geo-replication
Active geo-replication creates readable secondary replicas of an Azure SQL database in other regions for disaster recovery.