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

TableSize_Get performance issue #943

Closed
DavidWiseman opened this issue Jul 18, 2024 · 0 comments
Closed

TableSize_Get performance issue #943

DavidWiseman opened this issue Jul 18, 2024 · 0 comments
Labels
Completed DEV work completed. To be included in next release if issue is still open.

Comments

@DavidWiseman
Copy link
Collaborator

This issue was observed running the TableSize collection for a specific instance despite the SP running fast at root level. The nested loops join means we are running the "oldest" query against the TableSize table 640x.

image

If we add in a HASH JOIN hint we can avoid this and improve performance from over 16 seconds to 300ms.
image

New Plan:
image
DavidWiseman added a commit that referenced this issue Jul 18, 2024
@DavidWiseman
TableSize_Get performance fix
c4e1b78 
#943
@DavidWiseman DavidWiseman mentioned this issue Jul 18, 2024
Merged
@DavidWiseman DavidWiseman added the Completed DEV work completed. To be included in next release if issue is still open. label Jul 18, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Completed DEV work completed. To be included in next release if issue is still open.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@DavidWiseman