Relatório de Diagnóstico SQL Server

Servidor: SRVSEDE01706 | Banco: SDBPRD

Análise de Instância - SRVSEDE01706

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)
BackupSDBPRD	LOG	8.00	0.02	0.00	8.00	8.00
BackupSDBPRD	PRIMARY	1761.38	5.45	0.00	1761.38	1761.38
CustomizacoesERP	LOG	2024.00	6.27	0.00	2024.00	2024.00
CustomizacoesERP	PRIMARY	5000.00	15.48	0.00	5000.00	5000.00
CustomizacoesERP	SECONDARY	1032.00	3.20	0.00	1032.00	1032.00
DB_DBA	Audit	78363.25	243.36	0.00	78363.25	78363.25
DB_DBA	LOG	1000.00	3.11	0.00	1000.00	1000.00
DB_DBA	PRIMARY	1000.00	3.11	0.00	1000.00	1000.00
ESB	LOG	1160.00	3.59	0.00	1160.00	1160.00
ESB	PRIMARY	7378.81	22.84	0.00	7378.81	7378.81
riopro_export	LOG	8.00	0.03	0.00	8.00	8.00
riopro_export	PRIMARY	25992.00	93.50	0.00	25992.00	25992.00
SDBPRD	LOG	461467.00	3877.87	0.00	461467.00	461467.00
SDBPRD	PRIMARY	818808.50	6880.74	10195.36	1124669.30	1736390.90
SDBPRD	SECONDARY	116736.00	980.97	-2048.00	55296.00	-67584.00
SDBPRD_TSS	LOG	9992.00	30.93	0.00	9992.00	9992.00
SDBPRD_TSS	PRIMARY	1169.31	3.62	0.00	1169.31	1169.31
Smartview	LOG	2056.00	6.37	0.00	2056.00	2056.00
Smartview	PRIMARY	1032.00	3.20	0.00	1032.00	1032.00
SVSDB	LOG	72.00	3.60	0.00	72.00	72.00
SVSDB	PRIMARY	8.00	0.40	0.00	8.00	8.00

Conexões Ativas (Em Processamento e Tempo Real)

Banco de Dados	Login	Host	Programa	Conexoes Ativas
master	NT AUTHORITY\SYSTEM	SRVSEDE01706	Microsoft� Windows� Operating System	1
SDBPRD	protheus27			2
SDBPRD	SistemaFirjan\SQLAgentService	SRVSEDE01317	SSIS-PKG_Carrega_Contrato_Pf_ODS-{50FBA7B7-7620-4637-9726-2C0C841E8C62}srvsede01706p.SDBPRD	1
SVSDB	usu.aiopsBD			1

Status dos Backups (> 2 dias)

Nome do Banco	Recovery Model	Tamanho (GB)	Ultimo Backup
Todos os bancos de dados (exceto tempdb e model) estao com backups em dia (ultimas 48h).

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
399	suspended	0	ASYNC_NETWORK_IO	00:00:00	0d 00:11:20	333412	SistemaFirjan\SQLAgentService	SRVSEDE01317	SSIS-PKG_Carrega_Contrato_Pf_ODS-{50FBA7B7-7620-4637-9726-2C0C841E8C62}srvsede01706p.SDBPRD	select * from [dbo].[SE1010]
1000	suspended	1083	LCK_M_S	00:01:14	0d 00:01:14	7	protheus27			SELECT TAB.*,TAB.D_E_L_E_T_ DELETED,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,S_T_A_M_P_,127) ) > 0 THEN CONVERT(VARCHAR,S_T_A_M_P_,127) ELSE CONVERT(VARCHAR,S_T_A_M_P_,127) + '.000' END TIME_STAMP,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,I_N_S_D_T_,127) ) > 0 THEN CONVERT(VARCHAR,I_N_S_D_T_,127) ELSE CONVERT(VARCHAR,I_N_S_D_T_,127) + '.000' END INSERT_STAMP FROM CNA010 TAB WITH (READCOMMITTED) WHERE R_E_C_N_O_ IN (93058) ORDER BY R_E_C_N_O_

SPID

Status

Bloqueado Por

Tipo de Espera

Tempo de Espera

Tempo Decorrido

CPU (ms)

Host

Programa

Texto da Query

399

suspended

ASYNC_NETWORK_IO

00:00:00

0d 00:11:20

333412

SistemaFirjan\SQLAgentService

SRVSEDE01317

SSIS-PKG_Carrega_Contrato_Pf_ODS-{50FBA7B7-7620-4637-9726-2C0C841E8C62}srvsede01706p.SDBPRD

select * from [dbo].[SE1010]

1000

suspended

1083

LCK_M_S

00:01:14

0d 00:01:14

protheus27

SELECT TAB.*,TAB.D_E_L_E_T_ DELETED,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,S_T_A_M_P_,127) ) > 0 THEN CONVERT(VARCHAR,S_T_A_M_P_,127) ELSE CONVERT(VARCHAR,S_T_A_M_P_,127) + '.000' END TIME_STAMP,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,I_N_S_D_T_,127) ) > 0 THEN CONVERT(VARCHAR,I_N_S_D_T_,127) ELSE CONVERT(VARCHAR,I_N_S_D_T_,127) + '.000' END INSERT_STAMP FROM CNA010 TAB WITH (READCOMMITTED) WHERE  R_E_C_N_O_ IN (93058)  ORDER BY  R_E_C_N_O_

Histórico de CPU (�altima Hora)

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

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

Banco de Dados	Arquivo Fisico	IOs Pendentes	Tempo Pendente (ms)	Tipo de IO
Nenhuma fila de I/O pendente detectada.

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)
SDBPRD	SDBPRD_3	68312022	10854142	938193763	11.85
SDBPRD	SDBPRD_2	61178903	8935862	810204843	11.56
SDBPRD	SDBPRD_1	56457850	7418516	717550899	11.23
SDBPRD	SDBPRD	59917418	1889998	584486191	9.46
tempdb	temp2	1874650	2005572	73746346	19.01
tempdb	temp4	1875130	2006583	73713563	18.99
tempdb	temp8	1874541	2007122	73671459	18.98
tempdb	temp6	1874325	2006304	73640475	18.98
tempdb	temp5	1874908	2006866	73639081	18.97
tempdb	temp3	1875076	2006190	73629556	18.97

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
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_I09.ndf	60	5	48	Bad	51718	8524	42500
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_I02.ndf	57	5	45	Bad	52042	9090	42185
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_I03.ndf	56	4	43	Bad	51578	9517	40734
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_I10.ndf	59	4	43	Bad	52141	10022	40348
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_I06.ndf	56	4	43	Bad	51404	9808	40812
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_I04.ndf	55	4	42	Bad	52747	9431	41585
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_I05.ndf	55	4	42	Bad	51596	9878	40795
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_I08.ndf	58	4	41	Bad	52179	8807	38954
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_I07.ndf	57	3	39	Bad	51920	10377	38084
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_I01.ndf	52	3	37	Bad	88200	10579	64904
D:	riopro_export	D:\MSSQL\DADOS\riopro_export.mdf	3	44	29	Bad	999595	283670	543422
T:	tempdb	T:\MSSQL\TEMPDB\temp2.mdf	9	28	19	Poor	64650	63636	64126
T:	tempdb	T:\MSSQL\TEMPDB\temp3.mdf	9	28	18	Poor	64641	63617	64112
T:	tempdb	T:\MSSQL\TEMPDB\temp4.mdf	9	28	18	Poor	64653	63622	64120
T:	tempdb	T:\MSSQL\TEMPDB\temp5.mdf	9	28	18	Poor	64653	63605	64111
T:	tempdb	T:\MSSQL\TEMPDB\temp6.mdf	9	28	18	Poor	64657	63617	64119
T:	tempdb	T:\MSSQL\TEMPDB\temp7.mdf	9	28	18	Poor	64646	63599	64105
T:	tempdb	T:\MSSQL\TEMPDB\temp8.mdf	9	28	18	Poor	64664	63604	64116
T:	tempdb	T:\MSSQL\TEMPDB\tempdev.mdf	9	27	18	Poor	64639	63496	64048
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_1.ndf	11	10	11	Poor	50260	11566	45766
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_2.ndf	11	12	11	Poor	48718	11611	43989
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD_3.ndf	12	9	11	Poor	48242	11451	43198
D:	SDBPRD_TSS	D:\MSSQL\DADOS\SDBPRD_TSS.mdf	10	1	9	Good	45311	8482	39925
D:	SDBPRD	D:\MSSQL\DADOS\SDBPRD.mdf	9	8	9	Good	67826	10042	66059
D:	CustomizacoesERP	D:\mssql\dados\CustomizacoesERP.mdf	10	2	9	Good	86754	8713	81538
D:	SVSDB	D:\MSSQL\DADOS\SVSDB.mdf	2	10	8	Good	50083	20304	26411
D:	ESB	D:\MSSQL\DADOS\ESB.mdf	2	20	7	Good	37456	13913	30278
C:	msdb	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf	5	5	5	Very good	61321	9536	43907
L:	SVSDB	L:\MSSQL\LOG\SVSDB_log.ldf	1	7	4	Very good	64865	44489	52869
L:	riopro_export	L:\MSSQL\LOG\riopro_export_log.ldf	2	2	2	Very good	13816	57649	57316
D:	CustomizacoesERP	D:\MSSQL\DADOS\CustomizacoesERP_I01.ndf	2	3	2	Very good	53346	9839	32006
D:	DB_DBA	D:\MSSQL\DADOS\DB_DBA_Audit.mdf	2	7	2	Very good	61009	8192	60527
C:	master	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\master.mdf	2	1	2	Very good	48931	8790	32304
T:	tempdb	T:\MSSQL\TEMPDB\templog.ldf	0	1	1	Excellent	17294	60686	60684
L:	SDBPRD_TSS	L:\MSSQL\LOG\SDBPRD_TSS_log.ldf	5	1	1	Excellent	989127	4298	8212
D:	BackupSDBPRD	D:\MSSQL\DADOS\BackupSDBPRD.mdf	1	1	1	Excellent	54508	8192	30082
L:	BackupSDBPRD	L:\MSSQL\LOG\BackupSDBPRD_log.ldf	1	0	1	Excellent	20907	5843	7627
D:	Smartview	D:\MSSQL\DADOS\Smartview.mdf	2	1	1	Excellent	52856	9110	11839
L:	Smartview	L:\MSSQL\LOG\Smartview_log.ldf	5	1	1	Excellent	939609	5300	8858
C:	model	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\model.mdf	2	1	1	Excellent	67070	8192	33118
C:	msdb	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf	2	1	1	Excellent	23288	7083	7318
D:	DB_DBA	D:\MSSQL\DADOS\DB_DBA.mdf	1	1	1	Excellent	43935	8192	25693
L:	DB_DBA	L:\MSSQL\LOG\DB_DBA_log.ldf	1	0	1	Excellent	50767	6155	8986
L:	ESB	L:\MSSQL\LOG\ESB_log.ldf	3	0	0	Excellent	847955	5968	10712
L:	CustomizacoesERP	L:\MSSQL\LOG\CustomizacoesERP_log.ldf	1	0	0	Excellent	113620	4960	8330
L:	SDBPRD	L:\MSSQL\LOG\SDBPRD_log.ldf	4	0	0	Excellent	917390	5020	10030
C:	model	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\modellog.ldf	0	0	0	Excellent	15299	5721	7443
C:	master	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\mastlog.ldf	2	0	0	Excellent	20046	4339	4368

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	7758.87	7165.71	593.16	2609970	49.08	0.0030	0.0027	0.0002	https://www.sqlskills.com/help/waits/CXPACKET
ASYNC_NETWORK_IO	1953.37	1941.20	12.16	158575	12.36	0.0123	0.0122	0.0001	https://www.sqlskills.com/help/waits/ASYNC_NETWORK_IO
LCK_M_X	1645.98	1645.98	0.00	3	10.41	548.6600	548.6597	0.0003	https://www.sqlskills.com/help/waits/LCK_M_X
LATCH_EX	1527.50	1413.07	114.43	830172	9.66	0.0018	0.0017	0.0001	https://www.sqlskills.com/help/waits/LATCH_EX
LCK_M_S	1244.27	1244.27	0.00	32	7.87	38.8835	38.8834	0.0001	https://www.sqlskills.com/help/waits/LCK_M_S
SOS_SCHEDULER_YIELD	514.12	0.61	513.51	1502480	3.25	0.0003	0.0000	0.0003	https://www.sqlskills.com/help/waits/SOS_SCHEDULER_YIELD
WRITELOG	316.41	297.61	18.80	133054	2.00	0.0024	0.0022	0.0001	https://www.sqlskills.com/help/waits/WRITELOG
HADR_SYNC_COMMIT	245.81	235.85	9.95	123018	1.55	0.0020	0.0019	0.0001	https://www.sqlskills.com/help/waits/HADR_SYNC_COMMIT

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

Exec Count	Total CPU (s)	Avg CPU (ms)	Query Text
167768999	2842.29	0.02	SELECT [IDX_NAME] FROM [TOP_VIRTUALIDX] WHERE [IDX_ENV]=@1 AND [IDX_NAME]=@2
5897990	994.59	0.17	UPDATE [dbo].[FWTSFWSCHDSMART_EXECUTE] set [D_E_L_E_T_] = @1,[R_E_C_D_E_L_] = [R_E_C_N_O_] WHERE [R_E_C_N_O_]=@2
4522640	449.87	0.10	SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1
6161818	210.58	0.03	SELECT [XX1_PARAM] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1
11	199.11	18101.10	SELECT DISTINCT SC1.C1_FILIAL, SC7.C7_FILIAL, SC1.C1_SOLICIT AS C1_SOLICIT, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_NUM ELSE SC1.C1_SCORI END AS C1_NUM, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_ITEM ELSE SC1.C1_ITSCORI END AS C1_ITEM, SC7.C7_PRODUTO AS C1_PRODUTO, SC7.C7_DESCRI AS C1_DESCRI, SC7.C7_UM AS C1_UM, SC7.C7_QUANT AS C1_QUANT, SC7.C7_PRECO AS C1_VUNIT, (SC7.C7_QUANT * SC7.C7_PRECO) AS VLTOTAL, SC7.C7_USER AS C1_XCOMPRA, SC7.C7_FORNECE AS C1_FORNECE, SC7.C7_LOJA AS C1_LOJA, SC7.C7_NUMPR AS C1_NUMPR, SC7.C7_NUM AS C1_PEDIDO, C7_ITEM, SC7.C7_DATPRF AS C1_DATPRF , SY1.Y1_NOME, SY1.Y1_TEL, SY1.Y1_EMAIL, SC7.C7_COMUNIC, SC7.C7_CONAPRO, SC7.C7_CONTRA, SC7.C7_MEDICAO, (SELECT SUM(A.C7_TOTAL) FROM SC7010 A WHERE A.C7_FILIAL = SC7.C7_FILIAL AND A.C7_NUM = SC7.C7_NUM AND A.C7_RESIDUO = SC7.C7_RESIDUO AND D_E_L_E_T_ != '') VL_TOT_PED, SC7.C7_FILIAL+SC7.C7_NUM AS CHAVEC7 FROM SC7010 SC7 INNER JOIN SC1010 SC1 ON ((CASE WHEN C7_FISCORI = '' THEN (C7_FILIAL+C7_NUMSC+C7_ITEMSC) ELSE (SC7.C7_FISCORI+C7_NUMSC+C7_ITEMSC)END) = C1_FILIAL+C1_NUM+C1_ITEM) AND SC1.D_E_L_E_T_=SC7.D_E_L_E_T_ LEFT JOIN SY1010 SY1 ON (SY1.Y1_USER = SC7.C7_USER) AND SC7.D_E_L_E_T_=SY1.D_E_L_E_T_ WHERE SC1.D_E_L_E_T_ = '' AND (CASE WHEN SC1.C1_NUMPR= '' THEN SC7.C7_NUMPR ELSE SC1.C1_NUMPR END) ='SC 00062/2026 ' AND SC1.C1_SCORI+SC1.C1_ITSCORI ='' AND SC7.C7_MEDICAO = '' AND SC7.C7_RESIDUO != 'S' AND (C7_COMUNIC ='') UNION ALL SELECT DISTINCT SC1.C1_FILIAL, SC7.C7_FILIAL, SC1b.C1_SOLICIT AS C1_SOLICIT, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_NUM ELSE SC1.C1_SCORI END AS C1_NUM, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_ITEM ELSE SC1.C1_ITSCORI END AS C1_ITEM, SC7.C7_PRODUTO AS C1_PRODUTO, SC7.C7_DESCRI AS C1_DESCRI, SC7.C7_UM AS C1_UM, SC7.C7_QUANT AS C1_QUANT, SC7.C7_PRECO AS C1_VUNIT, (SC7.C7_QUANT SC7.C7_PRECO) AS VLTOTAL, SC7.C7_USER AS C1_XCOMPRA, C7_FORNECE AS C1_FORNECE, C7_LOJA AS C1_LOJA, SC7.C7_NUMPR AS C1_NUMPR, C7_NUM AS C1_PEDIDO, C7_ITEM, SC7.C7_DATPRF AS C1_DATPRF , SY1.Y1_NOME, SY1.Y1_TEL, SY1.Y1_EMAIL, SC7.C7_COMUNIC, SC7.C7_CONAPRO, SC7.C7_CONTRA, SC7.C7_MEDICAO, (SELECT SUM(A.C7_TOTAL) FROM SC7010 A WHERE A.C7_FILIAL = SC7.C7_FILIAL AND A.C7_NUM = SC7.C7_NUM AND A.C7_RESIDUO = SC7.C7_RESIDUO AND D_E_L_E_T_ != '*') VL_TOT_PED, SC7.C7_FILIAL+SC7.C7_NUM AS CHAVEC7 FROM SC7010 SC7 INNER JOIN SC1010 SC1 ON ((CASE WHEN C7_FISCORI = '' THEN (C7_FILIAL+C7_NUMSC+C7_ITEMSC) ELSE (SC7.C7_FISCORI+C7_NUMSC+C7_ITEMSC)END) = C1_FILIAL+C1_NUM+C1_ITEM) AND SC1.D_E_L_E_T_=SC7.D_E_L_E_T_ INNER JOIN SC1010 SC1b ON SC1.C1_FISCORI+SC1.C1_SCORI+SC1.C1_ITSCORI = SC1b.C1_FILIAL+SC1b.C1_NUM+SC1b.C1_ITEM AND SC1.D_E_L_E_T_=SC1b.D_E_L_E_T_ LEFT JOIN SY1010 SY1 ON (SY1.Y1_USER = SC7.C7_USER) AND SC7.D_E_L_E_T_=SY1.D_E_L_E_T_ WHERE SC7.D_E_L_E_T_ = '' AND SC1.C1_SCORI+SC1.C1_ITSCORI <> '' AND (CASE WHEN SC1.C1_NUMPR= '' THEN SC7.C7_NUMPR ELSE SC1.C1_NUMPR END) ='SC 00062/2026 ' AND SC7.C7_MEDICAO = '' AND SC7.C7_RESIDUO != 'S' AND (C7_COMUNIC ='') ORDER BY 12, C1_SOLICIT, C1_PEDIDO, C1_ITEM
1544848	198.89	0.13	UPDATE F75010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
1	159.98	159982.92	select * from [dbo].[SE5010]
6161818	154.04	0.02	SELECT [XX1_DESCR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1
1446385	149.97	0.10	SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1
19621	149.01	7.59	UPDATE [dbo].[SYS_USR_LOGIN] set [USR_HRLOGON] = @1 WHERE [R_E_C_N_O_]=@2

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
167769142	2853.92	0.02	2842.29	0.02	335897484	SELECT [IDX_NAME] FROM [TOP_VIRTUALIDX] WHERE [IDX_ENV]=@1 AND [IDX_NAME]=@2
5897990	1491.50	0.25	994.59	0.17	63270168	UPDATE [dbo].[FWTSFWSCHDSMART_EXECUTE] set [D_E_L_E_T_] = @1,[R_E_C_D_E_L_] = [R_E_C_N_O_] WHERE [R_E_C_N_O_]=@2
35	645.98	18456.57	0.01	0.31	956	UPDATE [dbo].[SC1010] set [C1_TOTAL] = @1,[C1_USERLGA] = @2 WHERE [R_E_C_N_O_]=@3
4522644	456.15	0.10	449.87	0.10	134836399	SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1
1	433.66	433664.21	159.98	159982.92	4388366	select * from [dbo].[SE5010]
1544848	232.34	0.15	198.89	0.13	37574383	UPDATE F75010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
6161818	210.97	0.03	210.58	0.03	83068412	SELECT [XX1_PARAM] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1
1014379	196.76	0.19	129.37	0.13	13298748	DELETE [SYS_APP_PARAM] WHERE [APP_PARAM]=@1
19621	186.35	9.50	149.01	7.59	67001978	UPDATE [dbo].[SYS_USR_LOGIN] set [USR_HRLOGON] = @1 WHERE [R_E_C_N_O_]=@2
6161818	154.40	0.03	154.04	0.02	80166938	SELECT [XX1_DESCR] FROM [dbo].[XX1] 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 - SDBPRD

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

SPID	Status	Bloqueado Por	Tipo de Espera	Tempo Espera	Decorrrido	CPU (ms)	L.Reads	Login	Host	Programa	Texto da Query
399	suspended	0	ASYNC_NETWORK_IO	00:00:00	0d 00:11:22	334000	997323	SistemaFirjan\SQLAgentService	SRVSEDE01317	SSIS-PKG_Carrega_Contrato_Pf_ODS-{50FBA7B7-7620-4637-9726-2C0C841E8C62}srvsede01706p.SDBPRD	select * from [dbo].[SE1010]
195	suspended	0	CXPACKET	00:00:00	0d 00:00:00	652	12	protheus27			SELECT DISTINCT SC1.C1_FILIAL, SC7.C7_FILIAL, SC1.C1_SOLICIT AS C1_SOLICIT, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_NUM ELSE SC1.C1_SCORI END AS C1_NUM, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_ITEM ELSE SC1.C1_ITSCORI END AS C1_ITEM, SC7.C7_PRODUTO AS C1_PRODUTO, SC7.C7_DESCRI AS C1_DESCRI, SC7.C7_UM AS C1_UM, SC7.C7_QUANT AS C1_QUANT, SC7.C7_PRECO AS C1_VUNIT, (SC7.C7_QUANT * SC7.C7_PRECO) AS VLTOTAL, SC7.C7_USER AS C1_XCOMPRA, SC7.C7_FORNECE AS C1_FORNECE, SC7.C7_LOJA AS C1_LOJA, SC7.C7_NUMPR AS C1_NUMPR, SC7.C7_NUM AS C1_PEDIDO, C7_ITEM, SC7.C7_DATPRF AS C1_DATPRF , SY1.Y1_NOME, SY1.Y1_TEL, SY1.Y1_EMAIL, SC7.C7_COMUNIC, SC7.C7_CONAPRO, SC7.C7_CONTRA, SC7.C7_MEDICAO, (SELECT SUM(A.C7_TOTAL) FROM SC7010 A WHERE A.C7_FILIAL = SC7.C7_FILIAL AND A.C7_NUM = SC7.C7_NUM AND A.C7_RESIDUO = SC7.C7_RESIDUO AND D_E_L_E_T_ != '') VL_TOT_PED, SC7.C7_FILIAL+SC7.C7_NUM AS CHAVEC7 FROM SC7010 SC7 INNER JOIN SC1010 SC1 ON ((CASE WHEN C7_FISCORI = '' THEN (C7_FILIAL+C7_NUMSC+C7_ITEMSC) ELSE (SC7.C7_FISCORI+C7_NUMSC+C7_ITEMSC)END) = C1_FILIAL+C1_NUM+C1_ITEM) AND SC1.D_E_L_E_T_=SC7.D_E_L_E_T_ LEFT JOIN SY1010 SY1 ON (SY1.Y1_USER = SC7.C7_USER) AND SC7.D_E_L_E_T_=SY1.D_E_L_E_T_ WHERE SC1.D_E_L_E_T_ = '' AND (CASE WHEN SC1.C1_NUMPR= '' THEN SC7.C7_NUMPR ELSE SC1.C1_NUMPR END) ='SC 00062/2026 ' AND SC1.C1_SCORI+SC1.C1_ITSCORI ='' AND SC7.C7_MEDICAO = '' AND SC7.C7_RESIDUO != 'S' AND (C7_COMUNIC ='') UNION ALL SELECT DISTINCT SC1.C1_FILIAL, SC7.C7_FILIAL, SC1b.C1_SOLICIT AS C1_SOLICIT, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_NUM ELSE SC1.C1_SCORI END AS C1_NUM, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_ITEM ELSE SC1.C1_ITSCORI END AS C1_ITEM, SC7.C7_PRODUTO AS C1_PRODUTO, SC7.C7_DESCRI AS C1_DESCRI, SC7.C7_UM AS C1_UM, SC7.C7_QUANT AS C1_QUANT, SC7.C7_PRECO AS C1_VUNIT, (SC7.C7_QUANT SC7.C7_PRECO) AS VLTOTAL, SC7.C7_USER AS C1_XCOMPRA, C7_FORNECE AS C1_FORNECE, C7_LOJA AS C1_LOJA, SC7.C7_NUMPR AS C1_NUMPR, C7_NUM AS C1_PEDIDO, C7_ITEM, SC7.C7_DATPRF AS C1_DATPRF , SY1.Y1_NOME, SY1.Y1_TEL, SY1.Y1_EMAIL, SC7.C7_COMUNIC, SC7.C7_CONAPRO, SC7.C7_CONTRA, SC7.C7_MEDICAO, (SELECT SUM(A.C7_TOTAL) FROM SC7010 A WHERE A.C7_FILIAL = SC7.C7_FILIAL AND A.C7_NUM = SC7.C7_NUM AND A.C7_RESIDUO = SC7.C7_RESIDUO AND D_E_L_E_T_ != '*') VL_TOT_PED, SC7.C7_FILIAL+SC7.C7_NUM AS CHAVEC7 FROM SC7010 SC7 INNER JOIN SC1010 SC1 ON ((CASE WHEN C7_FISCORI = '' THEN (C7_FILIAL+C7_NUMSC+C7_ITEMSC) ELSE (SC7.C7_FISCORI+C7_NUMSC+C7_ITEMSC)END) = C1_FILIAL+C1_NUM+C1_ITEM) AND SC1.D_E_L_E_T_=SC7.D_E_L_E_T_ INNER JOIN SC1010 SC1b ON SC1.C1_FISCORI+SC1.C1_SCORI+SC1.C1_ITSCORI = SC1b.C1_FILIAL+SC1b.C1_NUM+SC1b.C1_ITEM AND SC1.D_E_L_E_T_=SC1b.D_E_L_E_T_ LEFT JOIN SY1010 SY1 ON (SY1.Y1_USER = SC7.C7_USER) AND SC7.D_E_L_E_T_=SY1.D_E_L_E_T_ WHERE SC7.D_E_L_E_T_ = '' AND SC1.C1_SCORI+SC1.C1_ITSCORI <> '' AND (CASE WHEN SC1.C1_NUMPR= '' THEN SC7.C7_NUMPR ELSE SC1.C1_NUMPR END) ='SC 00062/2026 ' AND SC7.C7_MEDICAO = '' AND SC7.C7_RESIDUO != 'S' AND (C7_COMUNIC ='') ORDER BY 12, C1_SOLICIT, C1_PEDIDO, C1_ITEM
1000	suspended	1083	LCK_M_S	00:01:17	0d 00:01:17	7	7	protheus27			SELECT TAB.*,TAB.D_E_L_E_T_ DELETED,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,S_T_A_M_P_,127) ) > 0 THEN CONVERT(VARCHAR,S_T_A_M_P_,127) ELSE CONVERT(VARCHAR,S_T_A_M_P_,127) + '.000' END TIME_STAMP,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,I_N_S_D_T_,127) ) > 0 THEN CONVERT(VARCHAR,I_N_S_D_T_,127) ELSE CONVERT(VARCHAR,I_N_S_D_T_,127) + '.000' END INSERT_STAMP FROM CNA010 TAB WITH (READCOMMITTED) WHERE R_E_C_N_O_ IN (93058) ORDER BY R_E_C_N_O_
649	running	0		00:00:00	0d 00:00:00	0	0	protheus27			SELECT TOP 40 R_E_C_N_O_, D_E_L_E_T_, XI_USERID, XI_CANAL FROM dbo.SXI WHERE XI_USERID = '000000' AND XI_CANAL = '002' AND D_E_L_E_T_ = ' ' ORDER BY XI_USERID,XI_CANAL,XI_CATEGOR,XI_EVENTID,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
195	16	protheus27		suspended	CXPACKET	SELECT DISTINCT SC1.C1_FILIAL, SC7.C7_FILIAL, SC1.C1_SOLICIT AS C1_SOLICIT, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_NUM ELSE SC1.C1_SCORI END AS C1_NUM, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_ITEM ELSE SC1.C1_ITSCORI END AS C1_ITEM, SC7.C7_PRODUTO AS C1_PRODUTO, SC7.C7_DESCRI AS C1_DESCRI, SC7.C7_UM AS C1_UM, SC7.C7_QUANT AS C1_QUANT, SC7.C7_PRECO AS C1_VUNIT, (SC7.C7_QUANT * SC7.C7_PRECO) AS VLTOTAL, SC7.C7_USER AS C1_XCOMPRA, SC7.C7_FORNECE AS C1_FORNECE, SC7.C7_LOJA AS C1_LOJA, SC7.C7_NUMPR AS C1_NUMPR, SC7.C7_NUM AS C1_PEDIDO, C7_ITEM, SC7.C7_DATPRF AS C1_DATPRF , SY1.Y1_NOME, SY1.Y1_TEL, SY1.Y1_EMAIL, SC7.C7_COMUNIC, SC7.C7_CONAPRO, SC7.C7_CONTRA, SC7.C7_MEDICAO, (SELECT SUM(A.C7_TOTAL) FROM SC7010 A WHERE A.C7_FILIAL = SC7.C7_FILIAL AND A.C7_NUM = SC7.C7_NUM AND A.C7_RESIDUO = SC7.C7_RESIDUO AND D_E_L_E_T_ != '') VL_TOT_PED, SC7.C7_FILIAL+SC7.C7_NUM AS CHAVEC7 FROM SC7010 SC7 INNER JOIN SC1010 SC1 ON ((CASE WHEN C7_FISCORI = '' THEN (C7_FILIAL+C7_NUMSC+C7_ITEMSC) ELSE (SC7.C7_FISCORI+C7_NUMSC+C7_ITEMSC)END) = C1_FILIAL+C1_NUM+C1_ITEM) AND SC1.D_E_L_E_T_=SC7.D_E_L_E_T_ LEFT JOIN SY1010 SY1 ON (SY1.Y1_USER = SC7.C7_USER) AND SC7.D_E_L_E_T_=SY1.D_E_L_E_T_ WHERE SC1.D_E_L_E_T_ = '' AND (CASE WHEN SC1.C1_NUMPR= '' THEN SC7.C7_NUMPR ELSE SC1.C1_NUMPR END) ='SC 00062/2026 ' AND SC1.C1_SCORI+SC1.C1_ITSCORI ='' AND SC7.C7_MEDICAO = '' AND SC7.C7_RESIDUO != 'S' AND (C7_COMUNIC ='') UNION ALL SELECT DISTINCT SC1.C1_FILIAL, SC7.C7_FILIAL, SC1b.C1_SOLICIT AS C1_SOLICIT, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_NUM ELSE SC1.C1_SCORI END AS C1_NUM, CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_ITEM ELSE SC1.C1_ITSCORI END AS C1_ITEM, SC7.C7_PRODUTO AS C1_PRODUTO, SC7.C7_DESCRI AS C1_DESCRI, SC7.C7_UM AS C1_UM, SC7.C7_QUANT AS C1_QUANT, SC7.C7_PRECO AS C1_VUNIT, (SC7.C7_QUANT SC7.C7_PRECO) AS VLTOTAL, SC7.C7_USER AS C1_XCOMPRA, C7_FORNECE AS C1_FORNECE, C7_LOJA AS C1_LOJA, SC7.C7_NUMPR AS C1_NUMPR, C7_NUM AS C1_PEDIDO, C7_ITEM, SC7.C7_DATPRF AS C1_DATPRF , SY1.Y1_NOME, SY1.Y1_TEL, SY1.Y1_EMAIL, SC7.C7_COMUNIC, SC7.C7_CONAPRO, SC7.C7_CONTRA, SC7.C7_MEDICAO, (SELECT SUM(A.C7_TOTAL) FROM SC7010 A WHERE A.C7_FILIAL = SC7.C7_FILIAL AND A.C7_NUM = SC7.C7_NUM AND A.C7_RESIDUO = SC7.C7_RESIDUO AND D_E_L_E_T_ != '*') VL_TOT_PED, SC7.C7_FILIAL+SC7.C7_NUM AS CHAVEC7 FROM SC7010 SC7 INNER JOIN SC1010 SC1 ON ((CASE WHEN C7_FISCORI = '' THEN (C7_FILIAL+C7_NUMSC+C7_ITEMSC) ELSE (SC7.C7_FISCORI+C7_NUMSC+C7_ITEMSC)END) = C1_FILIAL+C1_NUM+C1_ITEM) AND SC1.D_E_L_E_T_=SC7.D_E_L_E_T_ INNER JOIN SC1010 SC1b ON SC1.C1_FISCORI+SC1.C1_SCORI+SC1.C1_ITSCORI = SC1b.C1_FILIAL+SC1b.C1_NUM+SC1b.C1_ITEM AND SC1.D_E_L_E_T_=SC1b.D_E_L_E_T_ LEFT JOIN SY1010 SY1 ON (SY1.Y1_USER = SC7.C7_USER) AND SC7.D_E_L_E_T_=SY1.D_E_L_E_T_ WHERE SC7.D_E_L_E_T_ = '' AND SC1.C1_SCORI+SC1.C1_ITSCORI <> '' AND (CASE WHEN SC1.C1_NUMPR= '' THEN SC7.C7_NUMPR ELSE SC1.C1_NUMPR END) ='SC 00062/2026 ' AND SC7.C7_MEDICAO = '' AND SC7.C7_RESIDUO != 'S' AND (C7_COMUNIC ='') ORDER BY 12, C1_SOLICIT, C1_PEDIDO, C1_ITEM
399	1	SistemaFirjan\SQLAgentService	SRVSEDE01317	suspended	ASYNC_NETWORK_IO	select * from [dbo].[SE1010]
1000	1	protheus27		suspended	LCK_M_S	SELECT TAB.*,TAB.D_E_L_E_T_ DELETED,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,S_T_A_M_P_,127) ) > 0 THEN CONVERT(VARCHAR,S_T_A_M_P_,127) ELSE CONVERT(VARCHAR,S_T_A_M_P_,127) + '.000' END TIME_STAMP,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,I_N_S_D_T_,127) ) > 0 THEN CONVERT(VARCHAR,I_N_S_D_T_,127) ELSE CONVERT(VARCHAR,I_N_S_D_T_,127) + '.000' END INSERT_STAMP FROM CNA010 TAB WITH (READCOMMITTED) WHERE R_E_C_N_O_ IN (93058) ORDER BY R_E_C_N_O_

SPID

DOP (Grau de Paralelismo)

Host

Status

Tipo de Espera

Texto da Query

195

protheus27

suspended

CXPACKET

SELECT DISTINCT      SC1.C1_FILIAL,     SC7.C7_FILIAL,      SC1.C1_SOLICIT                 AS C1_SOLICIT,     CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_NUM ELSE SC1.C1_SCORI END AS C1_NUM,     CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_ITEM ELSE SC1.C1_ITSCORI END AS C1_ITEM,      SC7.C7_PRODUTO                 AS C1_PRODUTO,      SC7.C7_DESCRI                     AS C1_DESCRI,      SC7.C7_UM                         AS C1_UM,      SC7.C7_QUANT                     AS C1_QUANT,      SC7.C7_PRECO                     AS C1_VUNIT,      (SC7.C7_QUANT * SC7.C7_PRECO)     AS VLTOTAL,      SC7.C7_USER                     AS C1_XCOMPRA,      SC7.C7_FORNECE                 AS C1_FORNECE,      SC7.C7_LOJA                     AS C1_LOJA,      SC7.C7_NUMPR                     AS C1_NUMPR,      SC7.C7_NUM                     AS C1_PEDIDO,     C7_ITEM,     SC7.C7_DATPRF                  AS C1_DATPRF ,      SY1.Y1_NOME,      SY1.Y1_TEL,      SY1.Y1_EMAIL,     SC7.C7_COMUNIC,     SC7.C7_CONAPRO,     SC7.C7_CONTRA,     SC7.C7_MEDICAO,     (SELECT SUM(A.C7_TOTAL) FROM SC7010 A WHERE A.C7_FILIAL = SC7.C7_FILIAL AND A.C7_NUM = SC7.C7_NUM AND A.C7_RESIDUO = SC7.C7_RESIDUO AND D_E_L_E_T_ != '*') VL_TOT_PED,     SC7.C7_FILIAL+SC7.C7_NUM AS CHAVEC7 FROM SC7010 SC7           INNER JOIN SC1010 SC1              ON    ((CASE                      WHEN C7_FISCORI = ''                      THEN (C7_FILIAL+C7_NUMSC+C7_ITEMSC)                      ELSE (SC7.C7_FISCORI+C7_NUMSC+C7_ITEMSC)END) = C1_FILIAL+C1_NUM+C1_ITEM)                 AND SC1.D_E_L_E_T_=SC7.D_E_L_E_T_            LEFT  JOIN SY1010 SY1               ON (SY1.Y1_USER = SC7.C7_USER) AND SC7.D_E_L_E_T_=SY1.D_E_L_E_T_  WHERE  SC1.D_E_L_E_T_                     = ''            AND (CASE WHEN SC1.C1_NUMPR= '' THEN SC7.C7_NUMPR ELSE SC1.C1_NUMPR END) ='SC 00062/2026  '            AND SC1.C1_SCORI+SC1.C1_ITSCORI =''           AND SC7.C7_MEDICAO                 = ''        AND SC7.C7_RESIDUO != 'S'  AND (C7_COMUNIC ='')   UNION ALL  SELECT DISTINCT    SC1.C1_FILIAL,    SC7.C7_FILIAL,     SC1b.C1_SOLICIT                 AS C1_SOLICIT,    CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_NUM ELSE SC1.C1_SCORI END AS C1_NUM,    CASE WHEN SC1.C1_FISCORI = '' THEN SC1.C1_ITEM ELSE SC1.C1_ITSCORI END AS C1_ITEM,     SC7.C7_PRODUTO                     AS C1_PRODUTO,     SC7.C7_DESCRI                     AS C1_DESCRI,     SC7.C7_UM                         AS C1_UM,     SC7.C7_QUANT                     AS C1_QUANT,     SC7.C7_PRECO                     AS C1_VUNIT,     (SC7.C7_QUANT * SC7.C7_PRECO)     AS VLTOTAL,     SC7.C7_USER                     AS C1_XCOMPRA,     C7_FORNECE                         AS C1_FORNECE,     C7_LOJA                         AS C1_LOJA,     SC7.C7_NUMPR                     AS C1_NUMPR,     C7_NUM                             AS C1_PEDIDO,    C7_ITEM,    SC7.C7_DATPRF                      AS C1_DATPRF ,     SY1.Y1_NOME,     SY1.Y1_TEL,     SY1.Y1_EMAIL,    SC7.C7_COMUNIC,    SC7.C7_CONAPRO,    SC7.C7_CONTRA,    SC7.C7_MEDICAO,    (SELECT SUM(A.C7_TOTAL) FROM SC7010 A WHERE A.C7_FILIAL = SC7.C7_FILIAL AND A.C7_NUM = SC7.C7_NUM AND A.C7_RESIDUO = SC7.C7_RESIDUO  AND D_E_L_E_T_ != '*') VL_TOT_PED,    SC7.C7_FILIAL+SC7.C7_NUM AS CHAVEC7 FROM SC7010 SC7           INNER JOIN SC1010 SC1             ON    ((CASE                      WHEN C7_FISCORI = ''                      THEN (C7_FILIAL+C7_NUMSC+C7_ITEMSC)                     ELSE (SC7.C7_FISCORI+C7_NUMSC+C7_ITEMSC)END) = C1_FILIAL+C1_NUM+C1_ITEM)                 AND SC1.D_E_L_E_T_=SC7.D_E_L_E_T_           INNER JOIN SC1010 SC1b                  ON SC1.C1_FISCORI+SC1.C1_SCORI+SC1.C1_ITSCORI = SC1b.C1_FILIAL+SC1b.C1_NUM+SC1b.C1_ITEM AND SC1.D_E_L_E_T_=SC1b.D_E_L_E_T_            LEFT  JOIN SY1010 SY1                  ON (SY1.Y1_USER = SC7.C7_USER) AND SC7.D_E_L_E_T_=SY1.D_E_L_E_T_  WHERE              SC7.D_E_L_E_T_                 = ''                  AND     SC1.C1_SCORI+SC1.C1_ITSCORI <> ''                AND       (CASE WHEN SC1.C1_NUMPR= '' THEN SC7.C7_NUMPR ELSE SC1.C1_NUMPR END) ='SC 00062/2026  '                AND    SC7.C7_MEDICAO                 = ''          AND SC7.C7_RESIDUO != 'S'  AND (C7_COMUNIC ='')    ORDER BY 12, C1_SOLICIT, C1_PEDIDO, C1_ITEM

399

SistemaFirjan\SQLAgentService

SRVSEDE01317

suspended

ASYNC_NETWORK_IO

select * from [dbo].[SE1010]

1000

protheus27

suspended

LCK_M_S

SELECT TAB.*,TAB.D_E_L_E_T_ DELETED,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,S_T_A_M_P_,127) ) > 0 THEN CONVERT(VARCHAR,S_T_A_M_P_,127) ELSE CONVERT(VARCHAR,S_T_A_M_P_,127) + '.000' END TIME_STAMP,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,I_N_S_D_T_,127) ) > 0 THEN CONVERT(VARCHAR,I_N_S_D_T_,127) ELSE CONVERT(VARCHAR,I_N_S_D_T_,127) + '.000' END INSERT_STAMP FROM CNA010 TAB WITH (READCOMMITTED) WHERE  R_E_C_N_O_ IN (93058)  ORDER BY  R_E_C_N_O_

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

SPID	Objeto	Modo	Status	Login	Programa	Host	Transacoes Abertas	Inicio
195	SY1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC1010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
195	SC7010	Sch-S	GRANT	protheus27			0	2026-03-17 15:42:53
399	SE1010	IS	GRANT	SistemaFirjan\SQLAgentService	SSIS-PKG_Carrega_Contrato_Pf_ODS-{50FBA7B7-7620-4637-9726-2C0C841E8C62}srvsede01706p.SDBPRD	SRVSEDE01317	0	2026-03-17 15:31:31
549	CT1010_CT1_09OBRG_DF	Sch-S	GRANT	protheus27			0	2026-03-17 15:29:28
549	CT1010_CT1_TPO03_DF	Sch-S	GRANT	protheus27			0	2026-03-17 15:29:28
649	SXH_XH_CANAL_DF	Sch-S	GRANT	protheus27			0	2026-03-16 17:28:39
694	SX6010_X6_DESC2_DF	Sch-S	GRANT	protheus27			0	2026-03-17 15:29:30
694	SX6010_X6_FIL_DF	Sch-S	GRANT	protheus27			0	2026-03-17 15:29:30
694	SX6010_X6_ACTIVE_DF	Sch-S	GRANT	protheus27			0	2026-03-17 15:29:30
694	SX3010_X3_PROPRI_DF	Sch-S	GRANT	protheus27			0	2026-03-17 15:29:30
694	SX3010_X3_NIVEL_DF	Sch-S	GRANT	protheus27			0	2026-03-17 15:29:30
694	SX6010_R_E_C_N_O__DF	Sch-S	GRANT	protheus27			0	2026-03-17 15:29:30
829	FK7010	IX	GRANT	protheus27			1	2026-03-17 15:29:28
829	CT2010_CT2_VLR01_DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
829	CT2010_CT2_AGLUT_DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
829	CV3010	IX	GRANT	protheus27			1	2026-03-17 15:29:28
829	FKF010	IX	GRANT	protheus27			1	2026-03-17 15:29:28
829	CT2010_CT2_EMPORI_DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
829	CT1010_CT1_AT04OB_DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
829	SA1010	IX	GRANT	protheus27			1	2026-03-17 15:29:28
829	CT1010_CT1_AGLSLD_DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
829	CT1010_CT1_BOOK_DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
829	SE1010	IX	GRANT	protheus27			1	2026-03-17 15:29:28
829	FJV010	IX	GRANT	protheus27			1	2026-03-17 15:29:28
829	CTT010_S_T_A_M_P__DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
829	FIW010	IX	GRANT	protheus27			1	2026-03-17 15:29:28
829	FIV010	IX	GRANT	protheus27			1	2026-03-17 15:29:28
829	CT1010_CT1_DESC04_DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
829	CT1010_CT1_DESC02_DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
829	CT2010_CT2_EC09CR_DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
829	CTK010	IX	GRANT	protheus27			1	2026-03-17 15:29:28
829	CT2010_CT2_AT01CR_DF	Sch-S	GRANT	protheus27			1	2026-03-17 15:29:28
1000	CNA010	IS	GRANT	protheus27			0	2026-03-17 15:41:36
1083	CN9010	IX	GRANT	protheus27			1	2026-03-17 15:28:05
1083	CNB010	IX	GRANT	protheus27			1	2026-03-17 15:28:05
1083	CNC010	IX	GRANT	protheus27			1	2026-03-17 15:28:05
1083	CNA010	IX	GRANT	protheus27			1	2026-03-17 15:28:05
1083	CPD010	IX	GRANT	protheus27			1	2026-03-17 15:28:05
1083	PAC010	IX	GRANT	protheus27			1	2026-03-17 15:28:05

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
2	1000	1083	0	0	(77462ms)LCK_M_S	77462	protheus27			<?query -- SELECT TAB.*,TAB.D_E_L_E_T_ DELETED,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,S_T_A_M_P_,127) ) > 0 THEN CONVERT(VARCHAR,S_T_A_M_P_,127) ELSE CONVERT(VARCHAR,S_T_A_M_P_,127) + '.000' END TIME_STAMP,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,I_N_S_D_T_,127) ) > 0 THEN CONVERT(VARCHAR,I_N_S_D_T_,127) ELSE CONVERT(VARCHAR,I_N_S_D_T_,127) + '.000' END INSERT_STAMP FROM CNA010 TAB WITH (READCOMMITTED) WHERE R_E_C_N_O_ IN (93058) ORDER BY R_E_C_N_O_ --?>

Nivel

SPID

Bloqueado Por

Sessoes Bloqueadas

Transacoes Abertas

Info de Espera

Tempo Espera (ms)

Host

Programa

SQL Atual

1000

1083

(77462ms)LCK_M_S

77462

protheus27

<?query --
SELECT TAB.*,TAB.D_E_L_E_T_ DELETED,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,S_T_A_M_P_,127) ) > 0 THEN CONVERT(VARCHAR,S_T_A_M_P_,127) ELSE CONVERT(VARCHAR,S_T_A_M_P_,127) + '.000' END TIME_STAMP,CASE WHEN CHARINDEX('.',CONVERT(VARCHAR,I_N_S_D_T_,127) ) > 0 THEN CONVERT(VARCHAR,I_N_S_D_T_,127) ELSE CONVERT(VARCHAR,I_N_S_D_T_,127) + '.000' END INSERT_STAMP FROM CNA010 TAB WITH (READCOMMITTED) WHERE  R_E_C_N_O_ IN (93058)  ORDER BY  R_E_C_N_O_
--?>

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
1544848	198891.16	0.13	232341.09	0.15	37574383	UPDATE F75010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
279808	37758.52	0.13	39652.08	0.14	6249168	UPDATE F76010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
70504	17241.60	0.24	36218.32	0.51	1769967	UPDATE SE2010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
96411	16832.17	0.17	27772.10	0.29	2326103	UPDATE CTK010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
50861	15313.60	0.30	63810.64	1.25	1873591	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
31215	12686.93	0.41	13396.25	0.43	758783	DELETE FROM CQ3010 WHERE CQ3_FILIAL = @IN_FILIAL and ROUND ( CQ3_DEBITO , 2 ) = 0.00 and ROUND ( CQ3_CREDIT , 2 ) = 0.00 and CQ3_DATA = @IN_DATA and ( (CQ3_CONTA = @IN_CONTAC and CQ3_CCUSTO = @IN_CUSTOC ) or (CQ3_CONTA = @IN_CONTAD and CQ3_CCUSTO = @IN_CUSTOD ) ) and CQ3_TPSALD = @IN_TPSALDO and CQ3_MOEDA = @IN_MOEDA and CQ3_LP = @cLp and D_E_L_E_T_ = ' '
46875	12050.62	0.26	30675.08	0.65	1270793	UPDATE SE1010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
54920	11141.55	0.20	14657.16	0.27	1157391	UPDATE SC7010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
65840	10605.99	0.16	16808.78	0.26	1128449	UPDATE SEA010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
179215	9164.62	0.05	9175.92	0.05	717316	SELECT @cModo = X2_MODO , @cModoUn = X2_MODOUN , @cModoEmp = X2_MODOEMP , @iTamFil = X2_TAMFIL , @iTamUn = X2_TAMUN , @iTamEmp = X2_TAMEMP FROM SX2010 WHERE X2_CHAVE = @IN_ALIAS and D_E_L_E_T_ = ' '

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
1544848	232341.09	0.15	198891.16	0.13	37574383	UPDATE F75010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
50861	63810.64	1.25	15313.60	0.30	1873591	INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )
279808	39652.08	0.14	37758.52	0.13	6249168	UPDATE F76010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
70504	36218.32	0.51	17241.60	0.24	1769967	UPDATE SE2010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
46875	30675.08	0.65	12050.62	0.26	1270793	UPDATE SE1010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
96411	27772.10	0.29	16832.17	0.17	2326103	UPDATE CTK010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
40731	26510.07	0.65	6948.85	0.17	945521	UPDATE SBZ010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
17378	22146.01	1.27	1824.31	0.10	96088	SELECT @iRecno = COALESCE ( MIN ( R_E_C_N_O_ ), 0 ) FROM CQ7010 WHERE CQ7_FILIAL = @IN_FILIAL and CQ7_CONTA = @IN_CONTAD and CQ7_CCUSTO = @IN_CUSTOD and CQ7_ITEM = @IN_ITEMD and CQ7_CLVL = @IN_CLVLD and CQ7_MOEDA = @IN_MOEDA and CQ7_TPSALD = @IN_TPSALDO and CQ7_DATA = @IN_DATA and CQ7_LP = @cLp and D_E_L_E_T_ = ' '
15349	20190.73	1.32	4948.74	0.32	410634	UPDATE SA1010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )
3268	19795.61	6.06	1276.21	0.39	130803	INSERT INTO CQ3010 (CQ3_FILIAL , CQ3_CONTA , CQ3_CCUSTO , CQ3_MOEDA , CQ3_TPSALD , CQ3_DATA , CQ3_DEBITO , CQ3_SLBASE , CQ3_STATUS , CQ3_LP , R_E_C_N_O_ ) VALUES (@IN_FILIAL , @IN_CONTAD , @IN_CUSTOD , @IN_MOEDA , @IN_TPSALDO , @IN_DATA , 0 , @cSlBase , @cStatus , @cLp , @iRecno )