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 - add @OutputTableNameBlitzCache parameter #1169

Closed
BrentOzar opened this issue Oct 15, 2017 · 0 comments
Closed

sp_BlitzFirst - add @OutputTableNameBlitzCache parameter #1169

BrentOzar opened this issue Oct 15, 2017 · 0 comments

Comments

@BrentOzar
Copy link
Member

Do you want to request a feature or report a bug?
Feature.

If @OutputTableNameBlitzCache is not null, run sp_BlitzCache with the new @CheckDateOverride parameter, passing in the @StartSampleTime that we're using for the rest of the BlitzFirst output tables. That way, all the samples are correlated to the same date/time, making it easier to show in Power BI.

If their version of sp_BlitzCache has the @QueriesRanInTheLastMinutes parameter, and if we have a prior sample in the sp_BlitzFirst output table (most recent one for the same server name), pass in that date/time.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant