===== 1. TRUY VAN DANG CHAY ===== spid|bi_chan_boi|status|command|wait_type|tai_nguyen_cho|cho_giay|cpu_giay|chay_giay|doc_logic|doc_dia|ram_MB|tran_mo|db|may|chuong_trinh ----|-----------|------|-------|---------|--------------|--------|--------|---------|---------|-------|------|-------|--|---|------------ 55|0|suspended|SELECT|ASYNC_NETWORK_IO||2.0|16.2|753.8|14531852|33673|105|0|KETOAN_2026|DESKTOP-DEDB54H|Mashup Engine 62|0|suspended|SELECT|CXPACKET||585.4|.1|585.4|0|0|57|0|KETOAN_2026|DESKTOP-DEDB54H|.Net SqlClient Data Provider 60|59|suspended|SELECT|LCK_M_S|KEY: 15:72057596920004608 (3e9f12923100)|136.1|.1|136.2|3942|0|105|0|KETOAN_2026|DESKTOP-DEDB54H|Mashup Engine 72|59|suspended|SELECT|LCK_M_S|PAGE: 15:1:5555134 |657.8|.1|657.9|10907|0|45|0|KETOAN_2026|MAYCHU|.Net SqlClient Data Provider 53|59|suspended|INSERT|LCK_M_S|PAGE: 15:1:5385931 |678.2|.0|678.2|1168|0|33|2|KETOAN_2026|MAY1|.Net SqlClient Data Provider 59|55|suspended|UPDATE|LCK_M_IX|OBJECT: 15:19777611:0 |740.6|.0|740.6|0|0|0|2|KETOAN_2026|KT02|.Net SqlClient Data Provider ===== 2. LENH DANG CHAY (1500 ky tu dau) ===== spid|cau_lenh ----|-------- 53|INSERT INTO @ValueTable ( MasterTableName , RefID , VoucherRefID , VoucherMasterTableName , VoucherRefType , VoucherRef 55|SELECT ROW_NUMBER() OVER (ORDER BY T.RefDate, T.RefNo) AS [STT], ISNULL(T.RefNo, '') AS [S? CT], CAST(T.RefDate AS DATE) AS [Ngày CT], CAST(T.PostedDate AS DATE) AS [Ngày HT], 59|UPDATE [SAVoucherDetail] SET [ListItemID] = @p1, [SAInvoiceRefID] = @p2 WHERE (([RefDetailID] = @p3)) 60|SELECT ROW_NUMBER() OVER (ORDER BY T.RefDate, T.RefNo) AS [STT], ISNULL(T.RefNo, '') AS [S? CT], CAST(T.RefDate AS DATE) AS [Ngày CT], CAST(T.PostedDate AS DATE) AS [Ngày HT], 62|SELECT Count(*) FROM [dbo].View_SAVoucher WHERE PostedDate BETWEEN '2026-01-01 00:00:00.000' AND '2026-08-31 23:59:59.000' AND ( (BranchID = '6ae21b87-5e79-41cd-91ce-af1e159f0e91') OR (BranchID = N'41c2af84-f482-427e-a739-50e82e12a189') OR (BranchID = 72|SELECT Count(*) FROM [dbo].View_SAVoucher WHERE PostedDate BETWEEN '2026-01-29 00:00:00.000' AND '2026-08-31 23:59:59.000' AND ( (BranchID = '41c2af84-f482-427e-a739-50e82e12a189') ) AND ( (DisplayOnBook = 0) OR (DisplayOnBook = 2) ) ===== 3. CHUOI KHOA ===== ke_chan|bi_chan|wait_type|cho_giay|tai_nguyen -------|-------|---------|--------|---------- 59|53|LCK_M_S|678|pagelock fileid=1 pageid=5385931 dbid=15 subresource=FULL id=lockcf51d4a00 mode=IX associatedObjectId=72057596924133376 59|60|LCK_M_S|136|keylock hobtid=72057596920004608 dbid=15 id=lockcf50f4780 mode=X associatedObjectId=72057596920004608 55|59|LCK_M_IX|740|objectlock lockPartition=0 objid=19777611 subresource=FULL dbid=15 id=lockd608ded80 mode=S associatedObjectId=19777611 59|72|LCK_M_S|657|pagelock fileid=1 pageid=5555134 dbid=15 subresource=FULL id=lockcf6df7c80 mode=IX associatedObjectId=72057596765667328 72|62|LCK_M_S|585|pagelock fileid=1 pageid=5555134 dbid=15 subresource=FULL id=lockcf6df7c80 mode=IX associatedObjectId=72057596765667328 ===== 4. TOP LOAI CHO HIEN TAI ===== wait_type|so_task|tong_cho_giay ---------|-------|------------- CXPACKET|27|15804 CLR_AUTO_EVENT|2|4456 BROKER_TRANSMITTER|2|4455 WAIT_XTP_HOST_WAIT|1|2228 ONDEMAND_TASK_QUEUE|1|2228 KSOURCE_WAKEUP|1|2222 LCK_M_S|4|2057 LCK_M_IX|1|740 QDS_SHUTDOWN_QUEUE|1|8 MISCELLANEOUS|1|8 SQLTRACE_INCREMENTAL_FLUSH_SLEEP|1|3 ASYNC_NETWORK_IO|1|1 SLEEP_SYSTEMTASK|1|0 HADR_FILESTREAM_IOMGR_IOCOMPLETION|1|0 ===== 5. CAP PHAT BO NHO TRUY VAN ===== spid|dop|yeu_cau_MB|duoc_cap_MB|ly_tuong_MB|dang_dung_MB|queue_id|thu_tu_cho|cho_giay ----|---|----------|-----------|-----------|------------|--------|----------|-------- 53|1|1|1|0|0|NULL|NULL|NULL 53|1|33|33|33|3|NULL|NULL|NULL 60|1|105|105|105|12|NULL|NULL|NULL 55|1|105|105|105|27|NULL|NULL|NULL 62|4|57|57|57|7|NULL|NULL|NULL 72|1|45|45|45|6|NULL|NULL|NULL Changed database context to 'tempdb'. ===== 6. TEMPDB ===== con_trong_MB|nguoi_dung_MB|noi_bo_MB|version_MB ------------|-------------|---------|---------- 562|1|488|0 name|cap_phat_MB|physical_name ----|-----------|------------- tempdev|1054|C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014ENT\MSSQL\DATA\tempdb.mdf templog|17|C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014ENT\MSSQL\DATA\templog.ldf spid|noi_bo_MB ----|--------- 59|0 58|0 57|0 56|0 55|0 54|0 53|0 52|0 Changed database context to 'master'. ===== 7. AP LUC CPU (SCHEDULER) ===== scheduler_id|cpu_id|task_hien_tai|dang_cho_cpu|hang_doi|io_cho ------------|------|-------------|------------|--------|------ 0|0|11|0|0|0 1|1|13|0|0|0 2|2|11|0|0|0 3|3|13|0|0|0 ===== 8. BO NHO SQL ===== chi_so|cntr_value ------|---------- Page life expectancy|2229 Page life expectancy|2229 Memory Grants Outstanding|6 Memory Grants Pending|0 Target Server Memory (KB)|55751752 Total Server Memory (KB)|7283768 ===== 9. DO TRE I/O THEO FILE ===== db|loai|so_lan_doc|tb_doc_ms|tb_ghi_ms|physical_name --|----|----------|---------|---------|------------- KETOAN_2026|DATA|74200|255.1|21.2|D:\MISA SME 2023\Data\SQL2014ENT\KETOAN_20264bbc94fdd2584802a9238de3dc1166b0.smd tempdb|DATA|25184|5.8|12.4|C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014ENT\MSSQL\DATA\tempdb.mdf KETOAN_2026|LOG|84|34.4|8.6|D:\MISA SME 2023\Data\SQL2014ENT\KETOAN_2026beb1f848106e40eaa8fd8f710d704304Log.sld KETOAN2025|DATA|1701|7.7|.0|D:\MISA SME 2022\Data\SQL2014ENT\KETOAN2025.smd NGOCTHOM2024|DATA|600|8.3|3.0|D:\MISA SME 2022\Data\SQL2014ENT\NGOCTHOM2024.smd tempdb|LOG|33|.5|2.8|C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014ENT\MSSQL\DATA\templog.ldf NGOCTHOM2023|DATA|511|9.4|29.0|D:\MISA SME 2022\Data\SQL2014ENT\NGOCTHOM2023.smd KETOAN2025|LOG|88|36.0|5.4|D:\MISA SME 2022\Data\SQL2014ENT\KETOAN2025Log.sld NGOCTHOM2024|LOG|103|26.7|1.4|D:\MISA SME 2022\Data\SQL2014ENT\NGOCTHOM2024Log.sld NGOCTHOM2023|LOG|105|21.2|5.2|D:\MISA SME 2022\Data\SQL2014ENT\NGOCTHOM2023Log.sld NGOCTHOM2021_2022|DATA|166|13.2|.0|D:\MISA SME 2022\Data\SQL2014ENT\NGOCTHOM2021_2022.smd TesT2025|DATA|54|24.9|2.0|D:\MISA SME 2022\Data\SQL2014ENT\TesT2025.smd ===== 10. CAU HINH ===== name|value_in_use ----|------------ cost threshold for parallelism|5 max degree of parallelism|0 min server memory (MB)|8192 max server memory (MB)|57344 optimize for ad hoc workloads|0 ===== 11. WINDOWS ===== CPU tong = 12.2 % CPU tong = 19.2 % CPU tong = 37.5 % Name Id CPU_giay RAM_MB ---- -- -------- ------ sqlservr 4736 572 7120 misaca_csp11_v2_certd 13116 417 21 System 4 242 0 Microsoft.SqlServer.IntegrationServices.MasterServiceHost 4640 141 58 svchost 592 121 12 MsMpEng 3524 46 168 tailscaled 3704 25 102 explorer 10228 20 136 svchost 1040 16 82 lsass 720 11 22 WmiPrvSE 5804 8 15 sqlservr 4728 8 711 Avg. Disk sec/Read = 0.0135 Avg. Disk sec/Write = 0.0007 Current Disk Queue Length = 0 % Idle Time = 97.9585