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.

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

sp_BlitzFirst passing invalid sort orders to sp_BlitzCache #1983

Closed
bmrazik opened this Issue Feb 20, 2019 · 1 comment

Comments

Projects
None yet
2 participants
@bmrazik
Copy link

bmrazik commented Feb 20, 2019

when running this as a part of blitzfirst, it errors out causing the agent job to error:
Invalid sort order chosen, reverting to cpu [SQLSTATE 42000]

@BrentOzar BrentOzar changed the title issue w/ issue #1945 (closed) sp_BlitzFirst passing invalid sort orders to sp_BlitzCache Feb 20, 2019

@BrentOzar BrentOzar self-assigned this Feb 20, 2019

@BrentOzar BrentOzar added this to the 2019-03 milestone Feb 20, 2019

BrentOzar added a commit that referenced this issue Feb 20, 2019

#1983 sp_BlitzCache sort order
Fixing error when calling sp_BlitzCache. Closes #1983.

BrentOzar added a commit that referenced this issue Feb 20, 2019

#1983 sp_BlitzCache sort order (#1984)
Fixing error when calling sp_BlitzCache. Closes #1983.
@BrentOzar

This comment has been minimized.

Copy link
Member

BrentOzar commented Feb 20, 2019

Sorry about that! Fixed in the dev branch. You can grab the updated version here:

https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/blob/dev/sp_BlitzFirst.sql

It was calling sp_BlitzCache @SortOrder = 'compilations', which should have been 'recent compilations'. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.