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

Workingset Trimming Report not working #247

Closed asavioliMSFT closed 12 months ago

asavioliMSFT commented 1 year ago

Every time we try to open this report on Nexus, following errors are occurring:

image

image

hacitandogan commented 1 year ago

Field name "Indicators" does not exists , removing this from DataSet_MemClerks fixing this error as the field is not used in the report.

@PiJoCoder , @asavioliMSFT Correct fields are ,[IndicatorsProcess] ,[IndicatorsSystem] ,[IndicatorsPool] , should we add those to the grid ?

image
asavioliMSFT commented 1 year ago

Yes. These columns are the most important ones, that will show where the memory pressure is

PiJoCoder commented 1 year ago

Sure, we can add them to the grid. Thanks @hacitandogan!

PiJoCoder commented 12 months ago

Fixed