search

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
348 stars 99 forks source link

dm_db_stats_properties did not pulled by the Nexus when import from logscout #249

Closed AtiyehDaghlas closed 10 months ago

AtiyehDaghlas commented 1 year ago

dm_db_stats_properties did not pulled by the Nexus when import from logscout or pssdiag The file is already collected by the logscout Nexus ver. 7.23.05.18

PiJoCoder commented 1 year ago

Hello @AtiyehDaghlas, the ability to import this rowset has been there since at least 2022 . See code here https://github.com/microsoft/SqlNexus/blob/7a86cbf3a1ea46de7c834a51d2fb74a63ac5d12e/RowsetImportEngine/TextRowsets.xml#L2022

  1. Can you try the latest build just in case - https://github.com/microsoft/SqlNexus/releases/tag/7.23.06.06
  2. Also, can you manually examine the raw data in the _PerfStatsSnapshotStartup.out file to see if there are some issues with it to prevent import. There must be an identifier tag -- sys.dm_db_stats_properties -- immediately followed by (no empty lines) the result set. Here is a sample output of what mine looks like from a successful import I just made.
-- sys.dm_db_stats_properties --
Database_Id Database_Name                                                                                                                    Schema_Name                                                                                                                      Object_Name                                                                                                                      object_id   stats_id    Statistics_Name                                                                                                                  last_updated                           rows                 rows_sampled         steps       unfiltered_rows      modification_counter persisted_sample_percent
----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------- -------------------- -------------------- ----------- -------------------- -------------------- ------------------------
          6 AdventureWorks2016                                                                                                               Sales                                                                                                                            SalesTaxRate                                                                                                                        14623095           1 PK_SalesTaxRate_SalesTaxRateID                                                                                                              2017-10-19 17:24:46.5000000                   29                   29          16                   29                    0                      0.0
          6 AdventureWorks2016                                                                                                               Sales                                                                                                                            SalesTaxRate                                                                                                                        14623095           2 AK_SalesTaxRate_StateProvinceID_TaxType                                                                                                     2017-10-19 17:24:48.0366667                   29                   29          22                   29                    0                      0.0
          6 AdventureWorks2016                                                                                                               Sales                                                                                                                            SalesTaxRate                                                                                                                        14623095           3 AK_SalesTaxRate_rowguid                                                                                                                     2017-10-19 17:24:48.0366667                   29                   29          28                   29                    0                      0.0
PiJoCoder commented 10 months ago

@AtiyehDaghlas, did you get your questions on this answered? I am closing for now. If you need to continue discusison, please reopen.

PiJoCoder commented 10 months ago

I understand downloading the latest version of SQL LogScout took care of the issue