Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are stored inside the SQL Server Query Store through an easy to use stored procedure.

In version 1.1 many new optional parameters are added that influence the output of the stored procedure:

– @return_store_config : show or hide the Query Store configuration window. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

– @return_forced_plans : show or hide the Forced Query Store plans window. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

– @return_top_duration : show or hide the Top queries based on avg. duration window.  A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

– @return_top_cpu : show or hide the Top queries based on avg. CPU time window. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

– @return_top_log_read : show or hide the Top queries based on avg. logical read IO. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

– @return_top_log_write : show or hide the Top queries based on avg. logical write IO. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

– @return_top_phys_read : show or hide the Top queries based on avg. physical read IO. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

You can download the lates version of sp_WhatsupQueryStore from the GitHub page at https://github.com/Evdlaar/sp_WhatsupQueryStore.