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
356 stars 101 forks source link

Issue importing XEL files #96

Closed KlausLadegaard closed 3 years ago

KlausLadegaard commented 4 years ago

Keep getting this when importing files from my busy server (several source servers - same error)

08/24/20 09:39:04.688 [0X00001A54] Events Read: 2475000 Queued: 73 Processed/sec: 7671 08/24/20 09:39:06.273 [0X000004C8] ERROR: Event runtime check: Detected missing column [object_name] in event [sp_cache_remove] at event sequence 22056625 08/24/20 09:39:06.393 [0X000004C8] ERROR: Event sp_cache_remove 08/24/20 09:39:18.954 [0X00001A54] * ERROR: Reader encountered operating system error 0x8007000D (The data is invalid) State: 0 Global Seq: 0 08/24/20 09:39:18.956 [0X00001A54] Reads completed - Global Error Status 0xffffffe7 08/24/20 09:39:18.958 [0X00001A54] Signaling worker threads to complete final actions. 08/24/20 09:39:18.962 [0X00001A54] Waiting for the worker threads to complete final actions. 08/24/20 09:39:19.413 [0X00001A54] Performing general cleanup actions. 08/24/20 09:39:19.413 [0X00001A54] Total Events Processed: 2757638 08/24/20 09:39:19.415 [0X00001A54] Total Events Filtered: 29693 08/24/20 09:39:19.416 [0X00001A54] *****

Stopping PSSDIAG with ctrl+c

KlausLadegaard commented 4 years ago

I have now isolated it to file, I can open in SSMS and LINQ but not with SQLNexus

I tested with a simple READTRACE -I I will provide data file if RML team want it, but not to public

PiJoCoder commented 3 years ago

@KlausLadegaard thank you for reporting this! This is more an issue with ReadTrace than SQLNexus but let me see if we can take a stab. Based on the error message

08/24/20 09:39:19.419 [0X00001A54] ERROR: Unexpected outcome, cached XEL events still found on the set-aside list. Output may not be complete. This could be due to CTRL+C or other error conditon.

...it appears that while ReadTrace was trying to process the file it found some unexpected event occurred - like perhaps the XEL collection was interrupted suddenly. I can surmise that the "set-aside list" contains events that perhaps had a starting "part" and then a "finishing" part and the latter was not found due to an abrupt stop. Was the data collection done via PSSDIAG/SQLDIAG and was it interrupted suddently via multiple CTRL+C events?

@suresh-kandoth , do you have any other thoughts on this?

KlausLadegaard commented 3 years ago

No, just that it happenes often

Hent Outlook til Android

naveenrpendli commented 3 years ago

@KlausLadegaard are you using the 6.0.0.8 version ? or the current one. I'm having issue in importing the XEL files into the Nexus. When I go to the output folder Nexus don't recognize the files at all. If you have any documentation for the XEL file or something that will be a huge help to me to start using Nexus.

Thanks Naveen

suresh-kandoth commented 3 years ago

Are you capturing this event sp_cache_remove in the XEL files? _08/24/20 09:39:06.393 [0X000004C8] ERROR: Event sp_cacheremove

Does this event have the field [object_name] added to the collection? _08/24/20 09:39:06.273 [0X000004C8] ERROR: Event runtime check: Detected missing column [object_name] in event [sp_cacheremove] at event sequence 22056625

Several fields are marked as required for the processing and aggregation. So if those fields are missing, then ReadTrace will not import.

PiJoCoder commented 3 years ago

Closing for now. Please reopen if needed.

WinterIssue commented 2 years ago

Got the same problem. SQL Server 2016 SP2.

ERROR: Event runtime check: Detected missing column [object_name] in event [sp_cache_remove] at event sequence 155472 12/03/21 10:12:43.978 [0X0000428C] ERROR: Event sp_cache_remove

XML starts like this `

20816 PREPARED 6 973328245 1 Compplan Remove ...`