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

Server Name and version information fields exists on the header of some reports but it is always empty. #263

Closed hacitandogan closed 8 months ago

hacitandogan commented 8 months ago
image

Noticed this while working on an another issue, this is related to the data we fill into the dbo.tbl_SCRIPT_ENVIRONMENT_DETAILS table. Report datasets are using different where clauses then the current data. Most likely we changed the source of this data / script where we imported.

Modifying report dataset queries with the new where clause is the fix. Since I am currently touching all reports, I will modify these as well.

image