Relatório de Diagnóstico SQL Server

Servidor: SRVDATABASE1-PE | Banco: TFCAR4_PRD

Análise de Instância - SRVDATABASE1-PE

Tamanho e Crescimento dos Bancos (por Filegroup) (�altima Hora)

Banco	Filegroup/Tipo	Tamanho Atual (MB)	Crescimento Medio (MB/dia) desde criacao	Crescimento Medio (MB/dia) Semanal	+30 dias (Base Semanal) (MB)	+90 dias (Base Semanal) (MB)
FLUIG_HML	LOG	392.00	0.42	0.00	392.00	392.00
FLUIG_HML	PRIMARY	648.00	0.70	0.00	648.00	648.00
FLUIG_HML_NEW	LOG	392.00	1.40	0.00	392.00	392.00
FLUIG_HML_NEW	PRIMARY	712.00	2.53	0.00	712.00	712.00
FLUIG_PRD	LOG	264.00	3.11	9.14	538.20	1086.60
FLUIG_PRD	PRIMARY	72.00	0.85	0.00	72.00	72.00
SVSDB	LOG	100.00	8.33	0.00	100.00	100.00
SVSDB	PRIMARY	500.00	41.67	0.00	500.00	500.00
SVSDB	SECONDARY	500.00	41.67	0.00	500.00	500.00
TFCAR4_BI	LOG	2440.00	1.94	0.00	2440.00	2440.00
TFCAR4_BI	PRIMARY	87688.00	69.59	0.00	87688.00	87688.00
TFCAR4_PRD	LOG	102088.00	1173.43	0.00	102088.00	102088.00
TFCAR4_PRD	PRIMARY	921768.81	10595.04	1462.86	965654.61	1053426.21
TFCAR4_PRD_TTAT	LOG	72.00	0.64	0.00	72.00	72.00
TFCAR4_PRD_TTAT	PRIMARY	8.00	0.07	0.00	8.00	8.00
TSS_PRD	LOG	14600.00	171.76	0.00	14600.00	14600.00
TSS_PRD	PRIMARY	39649.06	466.46	54.86	41294.86	44586.46
TSS_PRD_TECSA	LOG	520.00	6.12	0.00	520.00	520.00
TSS_PRD_TECSA	PRIMARY	14352.00	168.85	-292.57	5574.90	-11979.30
TSS_PRD_TECSA	SECONDARY	16.00	0.19	0.00	16.00	16.00

Conexões Ativas (Em Processamento e Tempo Real)

Banco de Dados	Login	Host	Programa	Conexoes Ativas
SVSDB	svsdb			1
TFCAR4_PRD	sa			7

Status dos Backups (> 2 dias)

Nome do Banco	Recovery Model	Tamanho (GB)	Ultimo Backup
FLUIG_HML_NEW	FULL	0.70	NUNCA
FLUIG_PRD	FULL	0.07	NUNCA
TFCAR4_PRD_TTAT	FULL	0.01	NUNCA
FLUIG_HML	FULL	0.63	NUNCA

Erros Log SQL (�altima Hora) (TOP 50)

Data	Fonte	Mensagem
Nenhuma mensagem contendo "Erro", "Error", "Fail" ou "Failed" encontrada nos logs da última hora.

Performance da Instância (�altima Hora)

Visão Em Tempo Real (Instância) (TOP 30)

SPID	Status	Bloqueado Por	Tipo de Espera	Tempo de Espera	Tempo Decorrido	CPU (ms)	Login	Host	Programa	Texto da Query
Nenhuma sessao ativa encontrada.

Histórico de CPU (�altima Hora)

Data Evento	CPU SQL Server (%)	CPU Ocioso (%)	CPU Outros Processos (%)	Alerta
2026-03-05 16:14:28	28	66	6
2026-03-05 16:13:28	25	69	6
2026-03-05 16:12:28	29	65	6
2026-03-05 16:11:28	25	69	6
2026-03-05 16:10:28	26	68	6
2026-03-05 16:09:28	22	73	5
2026-03-05 16:08:28	24	71	5
2026-03-05 16:07:28	22	72	6
2026-03-05 16:06:28	28	67	5
2026-03-05 16:05:28	22	72	6
2026-03-05 16:04:28	22	72	6
2026-03-05 16:03:28	27	66	7
2026-03-05 16:02:28	27	66	7
2026-03-05 16:01:28	25	69	6
2026-03-05 16:00:28	21	73	6
2026-03-05 15:59:28	16	77	7
2026-03-05 15:58:28	49	39	12	Alerta
2026-03-05 15:57:28	37	47	16
2026-03-05 15:56:28	18	60	22
2026-03-05 15:55:28	18	68	14
2026-03-05 15:54:28	24	66	10
2026-03-05 15:53:28	25	70	5
2026-03-05 15:52:28	22	72	6
2026-03-05 15:51:28	21	73	6
2026-03-05 15:50:28	19	75	6
2026-03-05 15:49:28	29	65	6
2026-03-05 15:48:28	24	70	6
2026-03-05 15:47:28	23	71	6
2026-03-05 15:46:28	23	71	6
2026-03-05 15:45:28	31	63	6
2026-03-05 15:44:28	24	70	6
2026-03-05 15:43:28	24	71	5
2026-03-05 15:42:28	28	67	5
2026-03-05 15:41:28	21	74	5
2026-03-05 15:40:28	22	73	5
2026-03-05 15:39:27	17	78	5
2026-03-05 15:38:27	18	76	6
2026-03-05 15:37:27	14	81	5
2026-03-05 15:36:27	10	85	5
2026-03-05 15:35:27	31	63	6
2026-03-05 15:34:27	22	72	6
2026-03-05 15:33:27	25	69	6
2026-03-05 15:32:27	28	66	6
2026-03-05 15:31:27	23	71	6
2026-03-05 15:30:27	34	60	6
2026-03-05 15:29:27	30	64	6
2026-03-05 15:28:27	23	72	5
2026-03-05 15:27:27	17	77	6
2026-03-05 15:26:27	17	77	6
2026-03-05 15:25:27	20	72	8
2026-03-05 15:24:27	33	61	6
2026-03-05 15:23:27	37	58	5
2026-03-05 15:22:27	36	58	6
2026-03-05 15:21:27	33	62	5
2026-03-05 15:20:27	37	57	6
2026-03-05 15:19:27	33	61	6
2026-03-05 15:18:27	40	54	6
2026-03-05 15:17:27	45	49	6
2026-03-05 15:16:27	40	54	6
2026-03-05 15:15:27	30	64	6

Fila de Disco (I/O Pendente) (Tempo Real)

Banco de Dados	Arquivo Fisico	IOs Pendentes	Tempo Pendente (ms)	Tipo de IO
TFCAR4_PRD	E:\Protheus\TFCAR4_PRD_log.ldf	1	0	disk

Eventos de Auto Growth (�altima Hora)

Banco de Dados	Arquivo Logico	Tipo de Evento	Tamanho Anterior (MB)	Tamanho Novo (MB)	Crescimento (MB)	Hora do Evento (UTC)
Nenhum evento de auto-growth encontrado no trace na última hora.

Top Atividade I/O por Arquivo (Desde o último restart) (TOP 10)

Database Name	File Name	Reads	Writes	Total I/O Stalls (ms)	Avg I/O Stall (ms)
TFCAR4_PRD	TFCAR4_PRD	1085718218	160569373	19372572573	15.54
tempdb	temp2	937063312	1028482627	10683828459	5.44
tempdb	tempdev	937070432	1029231103	10672802080	5.43
TFCAR4_PRD	TFCAR4_PRD_log	1885895	665846937	1094316045	1.64
TSS_PRD	TSS_PRD	13708274	2775974	139766611	8.48
tempdb	templog	1283	17789177	98723594	5.55
TSS_PRD	TSS_PRD_log	43057	19659755	38061096	1.93
TSS_PRD_TECSA	STXDR1_TSS_PROD_DATA_01	1320050	44936	29612958	21.69
TSS_PRD_TECSA	STXDR1_TSS_PROD_DATA_02	833207	37603	16394025	18.83
FLUIG_HML_NEW	FLUIG_HML_NEW_log	146	11592880	16045922	1.38

Latência por Datafiles (Desde o último restart) (TOP 50)

Drive	Database	Arquivo	Read Latency (ms)	Write Latency (ms)	Avg Latency (ms)	Classificacao	Avg Bytes/Read	Avg Bytes/Write	Avg Bytes/Transfer
E:	TSS_PRD_TECSA	E:\Protheus\TSS_PRD_TECSA_DATA_01.mdf	21	27	21	Bad	34042	17627	33502
E:	TSS_PRD_TECSA	E:\Protheus\TSS_PRD_TECSA_DATA_02.mdf	18	27	18	Poor	33419	19444	32816
E:	SVSDB	E:\SVSDB\SVSDB_dat_01.mdf	1	24	17	Poor	13541	70918	52906
E:	TFCAR4_PRD	E:\Protheus\TFCAR4_PRD.mdf	17	3	15	Poor	169062	11874	148810
C:	FLUIG_HML_NEW	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\FLUIG_HML_NEW.mdf	1	36	9	Good	24964	12016	22026
E:	SVSDB	E:\SVSDB\SVSDB_dat_03.ndf	1	10	9	Good	17530	156035	145429
E:	SVSDB	E:\SVSDB\SVSDB_dat_04.ndf	1	8	8	Good	15639	165517	159914
E:	SVSDB	E:\SVSDB\SVSDB_dat_05.ndf	2	9	8	Good	13586	155852	142636
E:	TSS_PRD	E:\Protheus\TSS_PRD.mdf	8	9	8	Good	506227	23047	424859
E:	SVSDB	E:\SVSDB\SVSDB_dat_02.ndf	2	9	8	Good	35418	156672	150205
C:	tempdb	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\tempdb.mdf	3	7	5	Very good	64913	65842	65399
C:	tempdb	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\templog.ldf	1	5	5	Very good	25386	61018	61015
C:	tempdb	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\tempdb_mssql_2.ndf	3	7	5	Very good	64914	65876	65417
E:	FLUIG_PRD	E:\Protheus\FLUIG_PRD.mdf	1	42	5	Very good	12562	10773	12389
C:	msdb	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf	4	11	4	Very good	259371	8733	248829
C:	master	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\master.mdf	1	5	2	Very good	36446	9136	28590
C:	model	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\model.mdf	0	12	2	Very good	52976	8195	45101
E:	SVSDB	E:\SVSDB\SVSDB_ind_01.ndf	2	1	2	Very good	8192	8192	8192
E:	SVSDB	E:\SVSDB\SVSDB_ind_02.ndf	2	1	2	Very good	8192	8192	8192
E:	SVSDB	E:\SVSDB\SVSDB_ind_03.ndf	2	1	2	Very good	8192	8192	8192
E:	SVSDB	E:\SVSDB\SVSDB_ind_04.ndf	2	1	2	Very good	8192	8192	8192
E:	SVSDB	E:\SVSDB\SVSDB_ind_05.ndf	2	1	2	Very good	8192	8192	8192
E:	FLUIG_PRD	E:\Protheus\FLUIG_PRD_log.ldf	1	1	1	Excellent	30877	701	704
C:	TFCAR4_BI	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\TFCAR4_PBI.mdf	1	3	1	Excellent	14300	8192	14300
E:	SVSDB	E:\SVSDB\SVSDB_log.ldf	1	1	1	Excellent	70451	15740	15959
C:	model	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\modellog.ldf	0	1	1	Excellent	14357	3421	5418
C:	master	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\mastlog.ldf	0	1	1	Excellent	14720	1273	1295
C:	msdb	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf	1	1	1	Excellent	27432	4641	6471
E:	TSS_PRD	E:\Protheus\TSS_PRD_log.ldf	2	1	1	Excellent	1025857	2251	4488
E:	TSS_PRD_TECSA	E:\Protheus\TSS_PRD_TECSA_LOG_01.ldf	1	1	1	Excellent	38555	846	848
C:	FLUIG_HML_NEW	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\FLUIG_HML_NEW_log.ldf	4	1	1	Excellent	14027	796	796
E:	TFCAR4_PRD	E:\Protheus\TFCAR4_PRD_log.ldf	3	1	1	Excellent	656302	1671	3520
E:	TSS_PRD_TECSA	E:\Protheus\TSS_PRD_TECSA_INDEX_02.ndf	1	0	1	Excellent	8192	0	8192
D:	TFCAR4_PRD_TTAT	D:\Audit Trail Protheus\TFCAR4_PRD_TTAT_log.ldf	0	1	1	Excellent	93090	11582	23226
C:	FLUIG_HML	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\FLUIG_HML.mdf	1	1	1	Excellent	21201	8396	21144
C:	FLUIG_HML	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\FLUIG_HML_log.ldf	0	1	1	Excellent	35674	27101	29334
E:	TSS_PRD_TECSA	E:\Protheus\TSS_PRD_TECSA_INDEX_01.ndf	0	0	0	Excellent	8192	0	8192
C:	TFCAR4_BI	C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\TFCAR4_PBI_log.ldf	0	1	0	Excellent	18283	3276	17269
D:	TFCAR4_PRD_TTAT	D:\Audit Trail Protheus\TFCAR4_PRD_TTAT.mdf	0	1	0	Excellent	13338	11317	13305

Principais Esperas (Waits) (Delta da �altima Hora)

Tipo de Espera (Wait Type)	Tempo Total (s) (Delta)	Tempo Recurso (s) (Delta)	Tempo Sinal (s) (Delta)	Contagem (Delta)	Porcentagem	Espera Média (s)	Recurso Médio (s)	Sinal Médio (s)	URL de Ajuda
CXPACKET	86.96	67.36	19.60	229253	55.03	0.0004	0.0003	0.0001	https://www.sqlskills.com/help/waits/CXPACKET
ASYNC_NETWORK_IO	17.18	16.64	0.55	3123	10.88	0.0055	0.0053	0.0002	https://www.sqlskills.com/help/waits/ASYNC_NETWORK_IO
WRITELOG	15.01	13.14	1.87	13507	9.50	0.0011	0.0010	0.0001	https://www.sqlskills.com/help/waits/WRITELOG
LATCH_EX	14.08	12.10	1.98	8788	8.91	0.0016	0.0014	0.0002	https://www.sqlskills.com/help/waits/LATCH_EX
SOS_SCHEDULER_YIELD	11.91	0.01	11.89	22800	7.53	0.0005	0.0000	0.0005	https://www.sqlskills.com/help/waits/SOS_SCHEDULER_YIELD
XE_FILE_TARGET_TVF	8.15	8.15	0.00	229187	5.16	0.0000	0.0000	0.0000	https://www.sqlskills.com/help/waits/XE_FILE_TARGET_TVF

Top Queries por CPU (Desde o último restart) (TOP 10)

Exec Count	Total CPU (s)	Avg CPU (ms)	Query Text
1293299447	18464.36	0.01	SELECT [IDX_NAME] FROM [TOP_VIRTUALIDX] WHERE [IDX_ENV]=@1 AND [IDX_NAME]=@2
506982620	8335.07	0.02	SELECT [XX1_PARAM] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1
506982619	6686.54	0.01	SELECT [XX1_DESCR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1
506982610	6510.88	0.01	SELECT [XX1_RECORR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1
2264507	538.80	0.24	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
9047019	504.30	0.06	SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1
23364407	480.40	0.02	SELECT [USR_ULTSPSW] FROM [dbo].[SYS_USR] WHERE [R_E_C_N_O_]=@1
86	340.57	3960.08	SELECT COUNT(*) NREGS FROM ( SELECT Z67_FILIAL,Z67_NUMPA,Z67_ITEMPA,Z67_DESCPR,Z67_VALLAN,L1_FORMPG,L1_VLRTOT , ROW_NUMBER() OVER ( ORDER BY Z67_FILIAL,Z67_NUMPA,Z67_ITEMPA ) ITEM_ORDER FROM Z67010 Z67 INNER JOIN SL1010 SL1 ON SL1.L1_FILIAL = Z67.Z67_FILIAL AND SL1.L1_XNUMPA = Z67.Z67_NUMPA AND SL1.L1_XFICHA = Z67.Z67_PETCOD AND SL1.D_E_L_E_T_ = ' ' WHERE Z67.D_E_L_E_T_ = '' ) TRB WHERE ITEM_ORDER > 50
141354	315.39	2.23	UPDATE SA1010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
1736844	285.40	0.16	UPDATE SB2010 WITH (ROWLOCK) SET B2_QATU = @nOUT_QSALDOATU , B2_VATU1 = @nOUT_CUSTOATU , B2_VATU2 = @nOUT_CUSTOATU2 , B2_VATU3 = @nOUT_CUSTOATU3 , B2_VATU4 = @nOUT_CUSTOATU4 , B2_VATU5 = @nOUT_CUSTOATU5 , B2_CM1 = @nB2_CM1 , B2_CM2 = @nB2_CM2 , B2_CM3 = @nB2_CM3 , B2_CM4 = @nB2_CM4 , B2_CM5 = @nB2_CM5 , B2_QTSEGUM = @nOUT_QTSEGUM WHERE R_E_C_N_O_ between @nMinRecno and (@nMinRecno + 4095 ) and B2_FILIAL = @cFil_SB2 and B2_COD = @cProduto and B2_LOCAL = @cLocal and D_E_L_E_T_ = ' '

Top Queries por Duração (Desde o último restart) (TOP 10)

Exec Count	Total Duration (s)	Avg Duration (ms)	Total CPU (s)	Avg CPU (ms)	Total Reads	Query Text
1293299509	18687.49	0.01	18464.36	0.01	2586599018	SELECT [IDX_NAME] FROM [TOP_VIRTUALIDX] WHERE [IDX_ENV]=@1 AND [IDX_NAME]=@2
506982665	8418.75	0.02	8335.08	0.02	1842389650	SELECT [XX1_PARAM] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1
506982656	6769.36	0.01	6686.54	0.01	1013965312	SELECT [XX1_DESCR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1
506982640	6591.75	0.01	6510.88	0.01	1013965280	SELECT [XX1_RECORR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1
2264509	4896.88	2.16	538.80	0.24	82485662	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
9047019	1182.49	0.13	504.30	0.06	129790773	SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1
1660744	1181.86	0.71	214.39	0.13	59359430	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_CNLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
799412	734.42	0.92	118.43	0.15	28554478	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_IPLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
2995896	728.95	0.24	189.96	0.06	36747263	DELETE [SYS_APP_PARAM] WHERE [APP_PARAM]=@1
2718426	590.72	0.22	150.86	0.06	51473830	SELECT [ZA_XML] FROM [dbo].[SZA010] WHERE [R_E_C_N_O_]=@1

Status dos Jobs (Execuções na �altima Hora)

Job Name	Execucao	Resultado	Duracao (HH:MM:SS)	Mensagem
Nenhum job executado na última hora.

Análise Performance - TFCAR4_PRD

Visão Em Tempo Real (DB) (TOP 30)

SPID	Status	Tempo Espera	Decorrrido	CPU (ms)	L.Reads	Reads	Writes	Login	Objeto	Texto da Query
1590	running	00:00:00	0d 00:04:18	187459	125466406	9768	30492	sa	[TFCAR4_PRD].[dbo].[MAT006_18_01]	SELECT @vQSaidas = SUM(SD2.D2_QUANT ), @vD2_CUSTO = SUM(SD2.D2_CUSTO1 ), @vD2_CUSTO2 = SUM(SD2.D2_CUSTO2 ), @vD2_CUSTO3 = SUM(SD2.D2_CUSTO3 ) , @vD2_CUSTO4 = SUM(SD2.D2_CUSTO4 ), @vD2_CUSTO5 = SUM(SD2.D2_CUSTO5 ), @vD2_QTSEGUM = SUM(SD2.D2_QTSEGUM ), @vD2_CUSRP1 = SUM(SD2.D2_CUSRP1 ) , @vD2_CUSRP2 = SUM(SD2.D2_CUSRP2 ), @vD2_CUSRP3 = SUM(SD2.D2_CUSRP3 ), @vD2_CUSRP4 = SUM(SD2.D2_CUSRP4 ), @vD2_CUSRP5 = SUM(SD2.D2_CUSRP5 ) FROM SD2010 SD2 inner join SF4010 SF4 ON SF4.F4_FILIAL = @cFil_SF4 and SF4.F4_CODIGO = SD2.D2_TES and (SF4.F4_ESTOQUE = @vcEstoque or (@IN_CONSTESTERC = @IS_ACTIVE and (SF4.F4_PODER3 in ( @vcPoder1 , @vcPoder2 ) ) ) ) and SF4.D_E_L_E_T_ = @IS_SPACE WHERE SD2.D2_FILIAL = @cFil_SD2 and SD2.D2_COD = @IN_CCOD and SD2.D2_LOCAL = @IN_CLOCAL and SD2.D2_EMISSAO >= @vDtVai and SD2.D2_EMISSAO < @IN_DDATA and SD2.D2_ORIGLAN <> @vcOrigLan and SD2.D2_REMITO = @vcRemito and SD2.D2_TPDCENV NOT in ( @vcTPDCENV1 , @vcTpDCENV2 ) and SD2.D_E_L_E_T_ = @IS_SPACE
2290	running	00:00:00	0d 00:00:00	10	0	0	0	sa		SELECT CVALUE FROM dbo.##TMPSC00_1153 WHERE R_E_C_N_O_ = 1838
1206	running	00:00:00	0d 00:00:00	2	194	0	0	sa		SELECT TOP 250 R_E_C_N_O_ FROM dbo.SCP030 WHERE CP_FILIAL = '0101' AND CP_NUM = '014951' AND CP_ITEM > '06' AND D_E_L_E_T_ = ' ' AND ( NOT ( ( CHARINDEX(( CP_STATSA ),( 'BR' ))>0 ) )) ORDER BY CP_FILIAL,CP_NUM,CP_ITEM,CP_EMISSAO,R_E_C_N_O_
96	running	00:00:00	0d 00:00:00	0	72	0	0	sa		SELECT TOP 40 R_E_C_N_O_ FROM dbo.SCHDTSK WHERE TSK_CODIGO = '000036' AND TSK_ITEM = '855442' AND R_E_C_N_O_ > 4113897 AND D_E_L_E_T_ = ' ' ORDER BY TSK_CODIGO,TSK_ITEM,R_E_C_N_O_

Consultas Ativas com Paralelismo (DB) (Tempo Real) (TOP 20)

SPID	DOP (Grau de Paralelismo)	Login	Host	Status	Tipo de Espera	Texto da Query

Locks (Objetos) (Tempo Real) (TOP 100)

SPID	Objeto	Modo	Status	Login	Inicio
96	SCHDTSK_TSK_TENTAT_DF	Sch-S	GRANT	sa	2026-03-04 22:55:57
96	SCHDTSK_TSK_USERID_DF	Sch-S	GRANT	sa	2026-03-04 22:55:57
96	SCHDTSK_TSK_FILIAL_DF	Sch-S	GRANT	sa	2026-03-04 22:55:57
470	SXH_XH_DATA_DF	Sch-S	GRANT	sa	2026-03-04 22:59:37
1206	SCP030_CP_LOTE_DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_CP_MEDIDA_DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_CP_SALBLQ_DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_CP_ITSC_DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_CP_PROJETO_DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_CP_PREREQU_DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_CP_EMISSAO_DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_CP_SEGUM_DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_CP_PRODUTO_DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_I_N_S_D_T__DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_R_E_C_N_O__DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1206	SCP030_CP_NRBPIMS_DF	Sch-S	GRANT	sa	2026-03-05 15:08:58
1590	SD1010	Sch-S	GRANT	sa	2026-03-05 16:11:37
1590	SB2010	IX	GRANT	sa	2026-03-05 16:11:37
1590	SD2010	Sch-S	GRANT	sa	2026-03-05 16:11:37

Blocks (Sessões) (Tempo Real) (TOP 100)

Nivel	SPID	Bloqueado Por	Sessoes Bloqueadas	Transacoes Abertas	Info de Espera	Tempo Espera (ms)	Login	Host	Programa	SQL Atual
Nenhum bloqueio encontrado para sessoes neste banco de dados.

Deadlocks (�altima Hora) (TOP 100)

Data de Criacao	SPID Vítima	SPIDs Envolvidos	Relatorio de Deadlock (XML)
Nenhum deadlock encontrado no ring_buffer para este banco de dados.

Top 10 Queries por CPU (�altima Hora)

Exec Count	Total CPU (ms)	Avg CPU (ms)	Total Duration (ms)	Avg Duration (ms)	Total Reads	Query Text
2264515	538801.75	0.24	4896887.30	2.16	82485885	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
141354	315390.09	2.23	363363.31	2.57	171512935	UPDATE SA1010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
1737306	285473.00	0.16	343176.00	0.20	43893616	UPDATE SB2010 WITH (ROWLOCK) SET B2_QATU = @nOUT_QSALDOATU , B2_VATU1 = @nOUT_CUSTOATU , B2_VATU2 = @nOUT_CUSTOATU2 , B2_VATU3 = @nOUT_CUSTOATU3 , B2_VATU4 = @nOUT_CUSTOATU4 , B2_VATU5 = @nOUT_CUSTOATU5 , B2_CM1 = @nB2_CM1 , B2_CM2 = @nB2_CM2 , B2_CM3 = @nB2_CM3 , B2_CM4 = @nB2_CM4 , B2_CM5 = @nB2_CM5 , B2_QTSEGUM = @nOUT_QTSEGUM WHERE R_E_C_N_O_ between @nMinRecno and (@nMinRecno + 4095 ) and B2_FILIAL = @cFil_SB2 and B2_COD = @cProduto and B2_LOCAL = @cLocal and D_E_L_E_T_ = ' '
88013	259580.50	2.95	319962.30	3.64	145431328	UPDATE SB1010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
1660749	214388.65	0.13	1181858.71	0.71	59359599	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_CNLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
2526435	204002.14	0.08	290647.84	0.12	50304338	UPDATE SB2010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
500707	159007.93	0.32	203419.22	0.41	31572916	UPDATE CT2010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
2951936	129597.57	0.04	130232.73	0.04	22	SELECT @CPROGRAM = coalesce(@CPROGRAM,program_name) from sys.dm_exec_sessions WHERE Session_id = @@SPID
2755898	125323.11	0.05	127087.67	0.05	8303912	SELECT @CUSER = PARAM_VALUE FROM TOP_PARAM WHERE PARAM_NAME = 'USERNAME' AND PARAM_SESSION = @@SPID
799416	118427.57	0.15	734418.07	0.92	28554611	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_IPLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )

Top 10 Queries por Duração (�altima Hora)

Exec Count	Total Duration (ms)	Avg Duration (ms)	Total CPU (ms)	Avg CPU (ms)	Total Reads	Query Text
2264516	4896888.97	2.16	538802.03	0.24	82485921	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
1660749	1181858.71	0.71	214388.65	0.13	59359599	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_CNLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
799416	734418.07	0.92	118427.57	0.15	28554611	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_IPLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
141354	363363.31	2.57	315390.09	2.23	171512935	UPDATE SA1010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
1737393	343189.99	0.20	285486.77	0.16	43895985	UPDATE SB2010 WITH (ROWLOCK) SET B2_QATU = @nOUT_QSALDOATU , B2_VATU1 = @nOUT_CUSTOATU , B2_VATU2 = @nOUT_CUSTOATU2 , B2_VATU3 = @nOUT_CUSTOATU3 , B2_VATU4 = @nOUT_CUSTOATU4 , B2_VATU5 = @nOUT_CUSTOATU5 , B2_CM1 = @nB2_CM1 , B2_CM2 = @nB2_CM2 , B2_CM3 = @nB2_CM3 , B2_CM4 = @nB2_CM4 , B2_CM5 = @nB2_CM5 , B2_QTSEGUM = @nOUT_QTSEGUM WHERE R_E_C_N_O_ between @nMinRecno and (@nMinRecno + 4095 ) and B2_FILIAL = @cFil_SB2 and B2_COD = @cProduto and B2_LOCAL = @cLocal and D_E_L_E_T_ = ' '
88013	319962.30	3.64	259580.50	2.95	145431328	UPDATE SB1010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
2526520	290654.40	0.12	204008.55	0.08	50306137	UPDATE SB2010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
500707	203419.22	0.41	159007.93	0.32	31572916	UPDATE CT2010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
304084	166946.51	0.55	49379.85	0.16	9340224	INSERT INTO CT2010_TTAT_LOG VALUES ( 'CT2_DATA', @COLD, @CNEW, 'D', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
617597	144584.82	0.23	115932.17	0.19	17332308	UPDATE SB2010 WITH (ROWLOCK) SET B2_USAI = @dUltSai WHERE B2_FILIAL = @cFil_SB2 and B2_COD = @cProduto and B2_LOCAL = @cLocal and D_E_L_E_T_ = ' '