Skip to content

Try to rewrite the detailed query to not use sys.dm_db_page_info #2

@EitanBlumin

Description

@EitanBlumin

The sys.dm_db_page_info function was only introduced in SQL Server 2019.
Try to use the alternative sys.dm_db_database_page_allocations so that older SQL versions would be supported.
This means we won't have the used_bytes column, and we won't get visibility into the system pages, but maybe it's not too bad.

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions