DMV Comparison for SQL Server 2019 vs Azure SQL Database
What DMVs were added to Azure SQL Databases, and which DMVs are missing from Azure SQL Databases but still exist on SQL Server 2019 or other versions?
2025-06-02
What DMVs were added to Azure SQL Databases, and which DMVs are missing from Azure SQL Databases but still exist on SQL Server 2019 or other versions?
2025-06-02
2023-12-27
483 reads
2023-12-21 (first published: 2023-12-20)
494 reads
This is a great wrapper for your DMV's to automate a quick performance metric capture.
2016-01-12 (first published: 2016-01-06)
428 reads
Performance monitoring and optimization is an inseparable part of a DBA's activities. To optimize a poorly performing system/query or to troubleshoot the performance issues you need to know the root cause. Prior to SQL Server 2005, we had several system tables to monitor the state of the system.
2010-04-06
2,169 reads
2010-03-04
3,283 reads
Get a free green paper, an early access look at a new DMV book from longtime author Ian Stirk.
2010-02-02
3,224 reads
2009-06-30
3,200 reads
2009-06-22
2,873 reads
2009-06-15
3,132 reads
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
SQL Server 2025 introduces native support for vector data types and external AI models....
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
Comments posted to this topic are about the item How to Use SQL Server...
Comments posted to this topic are about the item Choosing an AI in Sept...
Comments posted to this topic are about the item The New SQL Server 2025...
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers