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
XEL READER ERROR: Unable to obtain first event in file. The file was opened but appears to be damaged or empty. #206
Readtrace a SQL Server trace processing utility.Version 9.04.0098 built for x64.
Microsoft SQL Server 2016 (SP2-CU17) (KB5001092) - 13.0.5888.11 (X64) Mar 19 2021 19:41:38 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393: )
12/19/22 14:38:17.639 [0X00004444] INFO: Starting build of XEL sequence order index
12/19/22 14:38:17.647 [0X00004754] XEL READER ERROR: Unable to obtain first event in file. The file was opened but appears to be damaged or empty.
12/19/22 14:38:17.647 [0X000043E0] XEL READER ERROR: Unable to obtain first event in file. The file was opened but appears to be damaged or empty.
12/19/22 14:38:17.647 [0X00001E5C] XEL READER ERROR: Unable to obtain first event in file. The file was opened but appears to be damaged or empty.
12/19/22 14:38:17.647 [0X00004444] XEL READER ERROR: Unable to obtain first event in file. The file was opened but appears to be damaged or empty.
12/19/22 14:38:17.647 [0X00004754] XEL READER ERROR: Attempt to open file D:\test\output failed, see previous error(s) for more details.
12/19/22 14:38:17.647 [0X000043E0] XEL READER ERROR: Attempt to open file D:\test\output failed, see previous error(s) for more details.
12/19/22 14:38:17.648 [0X00001E5C] XEL READER ERROR: Attempt to open file D:\test\output failed, see previous error(s) for more details.
12/19/22 14:38:17.650 [0X00004444] XEL READER ERROR: Attempt to open file D:\test\output failed, see previous error(s) for more details.
12/19/22 14:38:17.653 [0X00004754] ERROR: Attempt to open D:\test\output failed.
12/19/22 14:38:17.653 [0X000043E0] ERROR: Attempt to open D:\test\output failed.
12/19/22 14:38:17.654 [0X00001E5C] ERROR: Attempt to open D:\test\output failed.
12/19/22 14:38:17.654 [0X00004444] ERROR: Attempt to open D:\test\output failed.
12/19/22 14:38:17.655 [0X00004754] WARN: D:\test\output does not appear as if the events contain event_sequence, you may have to consider trace flag 260 to process this trace.
12/19/22 14:38:17.655 [0X000043E0] WARN: D:\test\output does not appear as if the events contain event_sequence, you may have to consider trace flag 260 to process this trace.
12/19/22 14:38:17.656 [0X00001E5C] WARN: D:\test\output does not appear as if the events contain event_sequence, you may have to consider trace flag 260 to process this trace.
12/19/22 14:38:17.656 [0X00004444] WARN: D:\test\output does not appear as if the events contain event_sequence, you may have to consider trace flag 260 to process this trace.
12/19/22 14:38:17.659 [0X00004444] INFO: Indexing Progress: 0 (Rate: 0/sec)
12/19/22 14:38:17.660 [0X00004444] INFO: Total events indexed: 0 (Rate: 0/sec)
12/19/22 14:38:17.661 [0X00004444] ERROR: Attempt to determine list of .XEL files failed.
12/19/22 14:38:17.662 [0X00004444] * ERROR: Attempt to initialize trace file reader failed with operating system error 0x80070006 (The handle is invalid)
12/19/22 14:38:17.730 [0X00004444] Reads completed - Global Error Status 0xfffffffe
12/19/22 14:38:17.730 [0X00004444] Signaling worker threads to complete final actions.
12/19/22 14:38:17.733 [0X00004444] Waiting for the worker threads to complete final actions.
12/19/22 14:38:17.735 [0X00004444] Performing general cleanup actions.
12/19/22 14:38:17.739 [0X00004444] Total Events Processed: 0
12/19/22 14:38:17.743 [0X00004444] Total Events Filtered: 0
12/19/22 14:38:17.746 [0X00004444] ==============================================
12/19/22 14:38:17.748 [0X00004444] WARNING: A significant portion of the events where filtered.
12/19/22 14:38:17.750 [0X00004444] You may want to check the filtering criteria.
12/19/22 14:38:17.752 [0X00004444] ==============================================
12/19/22 14:38:17.754 [0X00004444] *****
ReadTrace encountered one or more ERRORS. An error condition typically *
stops processing early and the ReadTrace output may be unusable. *
PiJoCoder
commented
1 year ago
Readtrace a SQL Server trace processing utility.Version 9.04.0098 built for x64.
Microsoft SQL Server 2016 (SP2-CU17) (KB5001092) - 13.0.5888.11 (X64) Mar 19 2021 19:41:38 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393: )
12/19/22 14:38:17.639 [0X00004444] INFO: Starting build of XEL sequence order index 12/19/22 14:38:17.647 [0X00004754] XEL READER ERROR: Unable to obtain first event in file. The file was opened but appears to be damaged or empty. 12/19/22 14:38:17.647 [0X000043E0] XEL READER ERROR: Unable to obtain first event in file. The file was opened but appears to be damaged or empty. 12/19/22 14:38:17.647 [0X00001E5C] XEL READER ERROR: Unable to obtain first event in file. The file was opened but appears to be damaged or empty. 12/19/22 14:38:17.647 [0X00004444] XEL READER ERROR: Unable to obtain first event in file. The file was opened but appears to be damaged or empty. 12/19/22 14:38:17.647 [0X00004754] XEL READER ERROR: Attempt to open file D:\test\output failed, see previous error(s) for more details. 12/19/22 14:38:17.647 [0X000043E0] XEL READER ERROR: Attempt to open file D:\test\output failed, see previous error(s) for more details. 12/19/22 14:38:17.648 [0X00001E5C] XEL READER ERROR: Attempt to open file D:\test\output failed, see previous error(s) for more details. 12/19/22 14:38:17.650 [0X00004444] XEL READER ERROR: Attempt to open file D:\test\output failed, see previous error(s) for more details. 12/19/22 14:38:17.653 [0X00004754] ERROR: Attempt to open D:\test\output failed. 12/19/22 14:38:17.653 [0X000043E0] ERROR: Attempt to open D:\test\output failed. 12/19/22 14:38:17.654 [0X00001E5C] ERROR: Attempt to open D:\test\output failed. 12/19/22 14:38:17.654 [0X00004444] ERROR: Attempt to open D:\test\output failed. 12/19/22 14:38:17.655 [0X00004754] WARN: D:\test\output does not appear as if the events contain event_sequence, you may have to consider trace flag 260 to process this trace. 12/19/22 14:38:17.655 [0X000043E0] WARN: D:\test\output does not appear as if the events contain event_sequence, you may have to consider trace flag 260 to process this trace. 12/19/22 14:38:17.656 [0X00001E5C] WARN: D:\test\output does not appear as if the events contain event_sequence, you may have to consider trace flag 260 to process this trace. 12/19/22 14:38:17.656 [0X00004444] WARN: D:\test\output does not appear as if the events contain event_sequence, you may have to consider trace flag 260 to process this trace. 12/19/22 14:38:17.659 [0X00004444] INFO: Indexing Progress: 0 (Rate: 0/sec) 12/19/22 14:38:17.660 [0X00004444] INFO: Total events indexed: 0 (Rate: 0/sec) 12/19/22 14:38:17.661 [0X00004444] ERROR: Attempt to determine list of .XEL files failed. 12/19/22 14:38:17.662 [0X00004444] * ERROR: Attempt to initialize trace file reader failed with operating system error 0x80070006 (The handle is invalid) 12/19/22 14:38:17.730 [0X00004444] Reads completed - Global Error Status 0xfffffffe 12/19/22 14:38:17.730 [0X00004444] Signaling worker threads to complete final actions. 12/19/22 14:38:17.733 [0X00004444] Waiting for the worker threads to complete final actions. 12/19/22 14:38:17.735 [0X00004444] Performing general cleanup actions. 12/19/22 14:38:17.739 [0X00004444] Total Events Processed: 0 12/19/22 14:38:17.743 [0X00004444] Total Events Filtered: 0 12/19/22 14:38:17.746 [0X00004444] ============================================== 12/19/22 14:38:17.748 [0X00004444] WARNING: A significant portion of the events where filtered. 12/19/22 14:38:17.750 [0X00004444] You may want to check the filtering criteria. 12/19/22 14:38:17.752 [0X00004444] ============================================== 12/19/22 14:38:17.754 [0X00004444] *****
12/19/22 14:38:17.764 [0X00004444] ***** ReadTrace exit code: -2 12/19/22 14:38:17.765 [0X00004444] INFO: Max set-aside XEL event hash table entry count: 0
sqlnexus import pssdiag's output, and encountered this problem ?