Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
EitanBlumin opened this issue Mar 29, 2020 · 0 comments
Open

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

EitanBlumin opened this issue Mar 29, 2020 · 0 comments
Assignees
@EitanBlumin
Labels
enhancement New feature or request

Comments

@EitanBlumin
Copy link
Collaborator

EitanBlumin commented Mar 29, 2020 •
edited
Loading

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.
@EitanBlumin EitanBlumin added the enhancement New feature or request label Mar 29, 2020
@EitanBlumin EitanBlumin self-assigned this Mar 29, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@EitanBlumin EitanBlumin

Labels
enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@EitanBlumin