Skip to content

sp_WhatsupQueryStore
Compare
Choose a tag to compare
@Evdlaar Evdlaar released this 06 Dec 08:38
· 2 commits to master since this release
1.1
e37a7f1

Version 1.1 of the sp_WhatsupQueryStore Stored Procedure.

In this release I added many new optional parameters that influence the output of the stored procedure:

  • @return_store_config : show or hide the Query Store configuration window.
  • @return_forced_plans : show or hide the Forced Query Store plans window.
  • @return_top_duration : show or hide the Top queries based on avg. duration window.
  • @return_top_cpu : show or hide the Top queries based on avg. CPU time window.
  • @return_top_log_read : show or hide the Top queries based on avg. logical read IO.
  • @return_top_log_write : show or hide the Top queries based on avg. logical write IO.
  • @return_top_phys_read : show or hide the Top queries based on avg. physical read IO.
Assets 3