Add new XML rowsets for columns QS modifications

microsoft / SqlNexus

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.

MIT License

337 stars 95 forks source link

Add new XML rowsets for columns QS modifications #315

Closed PiJoCoder closed 3 months ago

PiJoCoder commented 3 months ago

Added new columns and table for QS modifications. Added columns force_failure_count, last_force_failure_reason_desc and plan_forcing_type_desc to table sys.query_store_plan. Also, added new table tbl_dm_db_tuning_recommendations to collect auto tune recommendations from new query in SQLLogScout for sys.dm_db_tuning_recommendations.

@jagriffin5 - I am creating an issue here as well so we can do the association of commits with a workitem.

PiJoCoder commented 3 months ago

Fixed via
5359a713ef479f935b013f051db1693cb75ae1d2 bc98661790c724b86ab423505e066ae6a6aa9344 b30471fb3f9fc8dc32d2eaee08696b48ee8880fa

https://github.com/microsoft/SqlNexus/pull/312/