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
337 stars 95 forks source link

Loaded_modules report shows is empty - need to update report query #313

Open asavioliMSFT opened 4 months ago

asavioliMSFT commented 4 months ago

In the latest version of Log Scout, the loaded modules have been moved to the MiscDiagInfo file. Because of that, the report on nexus will always return nothing. We must change the query accordingly to fix this.

Fix is simple. We just must to change the WHERE clause of the report on Nexus, since now the input file name has MiscDiagInfo and current filter " WHERE input_file_name LIKE '%Shutdown.out'" will no longer work.

image

PiJoCoder commented 4 months ago

@asavioliMSFT, we likely just need to remove the WHERE clause as this rowset is no longer collected 2 times on startup and shutdown. We could even modify the XML rowset and remove the "input_file_name" column as it was used to filter out startup vs. shutdown stuff. https://github.com/microsoft/SqlNexus/blob/31851147986212cb2e62d8edeaf0ee34773ffdb5/RowsetImportEngine/TextRowsets.xml#L228