Servidor: SRVSEDE01706 | Banco: SDBPRD
| 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.03 | 0.00 | 8.00 | 8.00 |
| BackupSDBPRD | PRIMARY | 1761.38 | 5.52 | 0.00 | 1761.38 | 1761.38 |
| CustomizacoesERP | LOG | 2024.00 | 6.34 | 0.00 | 2024.00 | 2024.00 |
| CustomizacoesERP | PRIMARY | 5000.00 | 15.67 | 0.00 | 5000.00 | 5000.00 |
| CustomizacoesERP | SECONDARY | 1032.00 | 3.24 | 0.00 | 1032.00 | 1032.00 |
| DB_DBA | Audit | 78363.25 | 246.43 | 0.00 | 78363.25 | 78363.25 |
| DB_DBA | LOG | 1000.00 | 3.14 | 0.00 | 1000.00 | 1000.00 |
| DB_DBA | PRIMARY | 1000.00 | 3.14 | 0.00 | 1000.00 | 1000.00 |
| ESB | LOG | 1160.00 | 3.64 | 0.00 | 1160.00 | 1160.00 |
| ESB | PRIMARY | 7378.81 | 23.13 | 0.00 | 7378.81 | 7378.81 |
| riopro_export | LOG | 8.00 | 0.03 | -146.29 | -4380.70 | -13158.10 |
| riopro_export | PRIMARY | 25992.00 | 94.86 | 18.29 | 26540.70 | 27638.10 |
| SDBPRD | LOG | 461467.00 | 4012.76 | 0.00 | 461467.00 | 461467.00 |
| SDBPRD | PRIMARY | 817784.50 | 7111.17 | 10049.07 | 1119256.60 | 1722200.80 |
| SDBPRD | SECONDARY | 116736.00 | 1015.10 | -2048.00 | 55296.00 | -67584.00 |
| SDBPRD_TSS | LOG | 9992.00 | 31.32 | 0.00 | 9992.00 | 9992.00 |
| SDBPRD_TSS | PRIMARY | 1169.31 | 3.67 | 0.00 | 1169.31 | 1169.31 |
| Smartview | LOG | 2056.00 | 6.45 | 0.00 | 2056.00 | 2056.00 |
| Smartview | PRIMARY | 1032.00 | 3.24 | 0.00 | 1032.00 | 1032.00 |
| SVSDB | LOG | 72.00 | 4.50 | 0.00 | 72.00 | 72.00 |
| SVSDB | PRIMARY | 8.00 | 0.50 | 0.00 | 8.00 | 8.00 |
| Banco de Dados | Login | Host | Programa | Conexoes Ativas |
|---|---|---|---|---|
| master | NT AUTHORITY\SYSTEM | SRVSEDE01706 | Microsoft� Windows� Operating System | 1 |
| SDBPRD | protheus27 | 4 | ||
| SVSDB | usu.aiopsBD | 1 |
| 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). | |||
| Data | Fonte | Mensagem |
|---|---|---|
| Nenhuma mensagem contendo "Erro", "Error", "Fail" ou "Failed" encontrada nos logs da última hora. | ||
| SPID | Status | Bloqueado Por | Tipo de Espera | Tempo de Espera | Tempo Decorrido | CPU (ms) | Login | Host | Programa | Texto da Query |
|---|---|---|---|---|---|---|---|---|---|---|
| 1320 | suspended | 0 | ASYNC_NETWORK_IO | 00:00:00 | 2d 23:36:21 | 1328 | protheus27 | SELECT
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN SC7.C7_FISCORI
ELSE ''
END FILIALDEST,
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
A2.C1_NUM)
FROM SC7010 A1 (NOLOCK)
INNER JOIN SC1010 A2 ON
A2.C1_FILIAL = A1.C7_FISCORI AND
A2.C1_NUM = A1.C7_NUMSC AND
A2.C1_ITEM = A1.C7_ITEMSC AND
A2.C1_PRODUTO = A1.C7_PRODUTO AND
A2.D_E_L_E_T_ = A1.D_E_L_E_T_
WHERE
A1.C7_FILIAL = SC7.C7_FILIAL AND
A1.C7_NUM = SC7.C7_NUM AND
A1.C7_NUMPR = SC7.C7_NUMPR AND
A1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE ''
END SCDEST,
SC7.C7_FILIAL FILIALORIG,
CASE WHEN SC7.C7_FILIAL = SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_NUM)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FILIAL AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_SCORI)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FISCORI AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
END SCDORIG,
SC7.C7_NUM PEDIDO,
SA2.A2_CGC CNPJFornec,
SA2.A2_NOME FORNEC,
SC7.C7_FORNECE CODFOR,
SC7.C7_LOJA LOJFOR,
SUM(SC7.C7_TOTAL) VLRPED,
COALESCE(STUFF((SELECT DISTINCT (', ' +
CASE WHEN C.C7_QUJE = 0 AND
C.C7_RESIDUO = 'S' AND
C.C7_XCANCE != ''
THEN 'Cancelado'
WHEN C.C7_TIPO != 1
THEN 'Autorizacao de Entrega ou Pedido'
WHEN C.C7_RESIDUO != ''
THEN 'Eliminado por Residuo'
WHEN C.C7_ACCPROC != '1' AND
C.C7_CONAPRO = 'B' AND
C.C7_QUJE < C.C7_QUANT
THEN 'Bloqueado'
WHEN C.C7_QUJE = 0 AND
C.C7_QTDACLA = 0
THEN 'Pendente'
WHEN C.C7_QUJE != 0 AND
C.C7_QUJE < C.C7_QUANT
THEN 'Pedido Parcialmente Atendido'
WHEN C.C7_QUJE >= C.C7_QUANT
THEN 'Pedido Atendido'
WHEN C.C7_QTDACLA > 0
THEN 'Pedido Usado em Pre-Nota'
END)
FROM SC7010 C (NOLOCK)
WHERE
C.C7_FILIAL = SC7.C7_FILIAL AND
C.C7_NUM = SC7.C7_NUM AND
C.C7_NUMPR = SC7.C7_NUMPR AND
C.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '') STSPED,
SC7.C7_NUMPR PROCESSO,
(SELECT TOP 1 ISNULL(CONVERT(VARCHAR(2047), CONVERT(VARBINARY(2047), D.C7_XOBSGE)), '') XML
FROM SC7010 D (NOLOCK)
WHERE
D.C7_FILIAL = SC7.C7_FILIAL AND
D.C7_NUM = SC7.C7_NUM AND
D.C7_NUMPR = SC7.C7_NUMPR AND
D.D_E_L_E_T_ = ''
ORDER BY D.C7_ITEM DESC
) OBSGERAL,
SC7.C7_XENDEN ENDENTREGA
FROM SC7010 SC7 (NOLOCK)
INNER JOIN SA2010 SA2 (NOLOCK) ON
SC7.C7_FORNECE = SA2.A2_COD AND
SC7.C7_LOJA = SA2.A2_LOJA
WHERE
SC7.C7_NUMPR = 'SC 00221/2025 ' AND
SA2.A2_FILIAL = ' ' AND
SC7.D_E_L_E_T_ = '' AND
SA2.D_E_L_E_T_ = ''
GROUP BY
C7_FILIAL,
C7_FISCORI,
C7_NUM,
C7_FORNECE,
C7_LOJA,
C7_NUMPR,
C7_XENDEN,
A2_CGC,
A2_NOME,
C7_FISCORI
ORDER BY
C7_FILIAL,
C7_NUM | ||
| 451 | suspended | 0 | ASYNC_NETWORK_IO | 00:00:00 | 0d 00:52:52 | 243 | protheus27 | SELECT
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN SC7.C7_FISCORI
ELSE ''
END FILIALDEST,
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
A2.C1_NUM)
FROM SC7010 A1 (NOLOCK)
INNER JOIN SC1010 A2 ON
A2.C1_FILIAL = A1.C7_FISCORI AND
A2.C1_NUM = A1.C7_NUMSC AND
A2.C1_ITEM = A1.C7_ITEMSC AND
A2.C1_PRODUTO = A1.C7_PRODUTO AND
A2.D_E_L_E_T_ = A1.D_E_L_E_T_
WHERE
A1.C7_FILIAL = SC7.C7_FILIAL AND
A1.C7_NUM = SC7.C7_NUM AND
A1.C7_NUMPR = SC7.C7_NUMPR AND
A1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE ''
END SCDEST,
SC7.C7_FILIAL FILIALORIG,
CASE WHEN SC7.C7_FILIAL = SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_NUM)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FILIAL AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_SCORI)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FISCORI AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
END SCDORIG,
SC7.C7_NUM PEDIDO,
SA2.A2_CGC CNPJFornec,
SA2.A2_NOME FORNEC,
SC7.C7_FORNECE CODFOR,
SC7.C7_LOJA LOJFOR,
SUM(SC7.C7_TOTAL) VLRPED,
COALESCE(STUFF((SELECT DISTINCT (', ' +
CASE WHEN C.C7_QUJE = 0 AND
C.C7_RESIDUO = 'S' AND
C.C7_XCANCE != ''
THEN 'Cancelado'
WHEN C.C7_TIPO != 1
THEN 'Autorizacao de Entrega ou Pedido'
WHEN C.C7_RESIDUO != ''
THEN 'Eliminado por Residuo'
WHEN C.C7_ACCPROC != '1' AND
C.C7_CONAPRO = 'B' AND
C.C7_QUJE < C.C7_QUANT
THEN 'Bloqueado'
WHEN C.C7_QUJE = 0 AND
C.C7_QTDACLA = 0
THEN 'Pendente'
WHEN C.C7_QUJE != 0 AND
C.C7_QUJE < C.C7_QUANT
THEN 'Pedido Parcialmente Atendido'
WHEN C.C7_QUJE >= C.C7_QUANT
THEN 'Pedido Atendido'
WHEN C.C7_QTDACLA > 0
THEN 'Pedido Usado em Pre-Nota'
END)
FROM SC7010 C (NOLOCK)
WHERE
C.C7_FILIAL = SC7.C7_FILIAL AND
C.C7_NUM = SC7.C7_NUM AND
C.C7_NUMPR = SC7.C7_NUMPR AND
C.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '') STSPED,
SC7.C7_NUMPR PROCESSO,
(SELECT TOP 1 ISNULL(CONVERT(VARCHAR(2047), CONVERT(VARBINARY(2047), D.C7_XOBSGE)), '') XML
FROM SC7010 D (NOLOCK)
WHERE
D.C7_FILIAL = SC7.C7_FILIAL AND
D.C7_NUM = SC7.C7_NUM AND
D.C7_NUMPR = SC7.C7_NUMPR AND
D.D_E_L_E_T_ = ''
ORDER BY D.C7_ITEM DESC
) OBSGERAL,
SC7.C7_XENDEN ENDENTREGA
FROM SC7010 SC7 (NOLOCK)
INNER JOIN SA2010 SA2 (NOLOCK) ON
SC7.C7_FORNECE = SA2.A2_COD AND
SC7.C7_LOJA = SA2.A2_LOJA
WHERE
SC7.C7_NUMPR = 'SC 00169/2024 ' AND
SA2.A2_FILIAL = ' ' AND
SC7.D_E_L_E_T_ = '' AND
SA2.D_E_L_E_T_ = ''
GROUP BY
C7_FILIAL,
C7_FISCORI,
C7_NUM,
C7_FORNECE,
C7_LOJA,
C7_NUMPR,
C7_XENDEN,
A2_CGC,
A2_NOME,
C7_FISCORI
ORDER BY
C7_FILIAL,
C7_NUM |
| Data Evento | CPU SQL Server (%) | CPU Ocioso (%) | CPU Outros Processos (%) | Alerta |
|---|---|---|---|---|
| 2026-03-13 15:25:00 | 21 | 75 | 4 | |
| 2026-03-13 15:24:00 | 18 | 78 | 4 | |
| 2026-03-13 15:23:00 | 26 | 70 | 4 | |
| 2026-03-13 15:22:00 | 19 | 77 | 4 | |
| 2026-03-13 15:21:00 | 15 | 81 | 4 | |
| 2026-03-13 15:20:00 | 24 | 72 | 4 | |
| 2026-03-13 15:19:00 | 18 | 78 | 4 | |
| 2026-03-13 15:18:00 | 19 | 77 | 4 | |
| 2026-03-13 15:16:59 | 23 | 72 | 5 | |
| 2026-03-13 15:15:59 | 11 | 85 | 4 | |
| 2026-03-13 15:14:59 | 16 | 81 | 3 | |
| 2026-03-13 15:13:59 | 8 | 89 | 3 | |
| 2026-03-13 15:12:59 | 17 | 79 | 4 | |
| 2026-03-13 15:11:59 | 29 | 67 | 4 | |
| 2026-03-13 15:10:59 | 28 | 69 | 3 | |
| 2026-03-13 15:09:59 | 26 | 70 | 4 | |
| 2026-03-13 15:08:59 | 41 | 55 | 4 | |
| 2026-03-13 15:07:59 | 36 | 59 | 5 | |
| 2026-03-13 15:06:58 | 23 | 73 | 4 | |
| 2026-03-13 15:05:58 | 17 | 78 | 5 | |
| 2026-03-13 15:04:58 | 20 | 76 | 4 | |
| 2026-03-13 15:03:58 | 14 | 82 | 4 | |
| 2026-03-13 15:02:58 | 17 | 79 | 4 | |
| 2026-03-13 15:01:58 | 28 | 68 | 4 | |
| 2026-03-13 15:00:58 | 16 | 80 | 4 | |
| 2026-03-13 14:59:58 | 17 | 79 | 4 | |
| 2026-03-13 14:58:57 | 18 | 78 | 4 | |
| 2026-03-13 14:57:57 | 16 | 79 | 5 | |
| 2026-03-13 14:56:57 | 13 | 84 | 3 | |
| 2026-03-13 14:55:57 | 16 | 81 | 3 | |
| 2026-03-13 14:54:57 | 23 | 73 | 4 | |
| 2026-03-13 14:53:57 | 18 | 77 | 5 | |
| 2026-03-13 14:52:57 | 19 | 77 | 4 | |
| 2026-03-13 14:51:57 | 13 | 83 | 4 | |
| 2026-03-13 14:50:57 | 18 | 78 | 4 | |
| 2026-03-13 14:49:57 | 16 | 80 | 4 | |
| 2026-03-13 14:48:56 | 16 | 80 | 4 | |
| 2026-03-13 14:47:56 | 19 | 77 | 4 | |
| 2026-03-13 14:46:56 | 27 | 67 | 6 | |
| 2026-03-13 14:45:56 | 15 | 81 | 4 | |
| 2026-03-13 14:44:56 | 20 | 76 | 4 | |
| 2026-03-13 14:43:56 | 22 | 74 | 4 | |
| 2026-03-13 14:42:56 | 29 | 67 | 4 | |
| 2026-03-13 14:41:56 | 21 | 75 | 4 | |
| 2026-03-13 14:40:56 | 21 | 75 | 4 | |
| 2026-03-13 14:39:55 | 15 | 81 | 4 | |
| 2026-03-13 14:38:55 | 19 | 77 | 4 | |
| 2026-03-13 14:37:55 | 24 | 72 | 4 | |
| 2026-03-13 14:36:55 | 15 | 81 | 4 | |
| 2026-03-13 14:35:55 | 18 | 78 | 4 | |
| 2026-03-13 14:34:55 | 18 | 78 | 4 | |
| 2026-03-13 14:33:55 | 24 | 72 | 4 | |
| 2026-03-13 14:32:55 | 23 | 73 | 4 | |
| 2026-03-13 14:31:55 | 30 | 66 | 4 | |
| 2026-03-13 14:30:54 | 16 | 80 | 4 | |
| 2026-03-13 14:29:54 | 23 | 73 | 4 | |
| 2026-03-13 14:28:54 | 23 | 72 | 5 | |
| 2026-03-13 14:27:54 | 20 | 76 | 4 | |
| 2026-03-13 14:26:54 | 14 | 82 | 4 | |
| 2026-03-13 14:25:54 | 19 | 77 | 4 |
| Banco de Dados | Arquivo Fisico | IOs Pendentes | Tempo Pendente (ms) | Tipo de IO |
|---|---|---|---|---|
| Nenhuma fila de I/O pendente detectada. | ||||
| 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. | ||||||
| Database Name | File Name | Reads | Writes | Total I/O Stalls (ms) | Avg I/O Stall (ms) |
|---|---|---|---|---|---|
| SDBPRD | SDBPRD_3 | 56953199 | 9743865 | 813785676 | 12.20 |
| SDBPRD | SDBPRD_2 | 50943622 | 7902156 | 709369321 | 12.05 |
| SDBPRD | SDBPRD_1 | 46952177 | 6051326 | 624183560 | 11.78 |
| SDBPRD | SDBPRD | 49658547 | 1652842 | 509167073 | 9.92 |
| tempdb | temp2 | 1601332 | 1705045 | 63406925 | 19.18 |
| tempdb | temp4 | 1601585 | 1705710 | 63384235 | 19.16 |
| tempdb | temp8 | 1601146 | 1706346 | 63336650 | 19.15 |
| tempdb | temp3 | 1601694 | 1705907 | 63309605 | 19.14 |
| tempdb | temp6 | 1601001 | 1705762 | 63305533 | 19.14 |
| tempdb | temp5 | 1601361 | 1705923 | 63301813 | 19.14 |
| 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 | 61 | 5 | 49 | Bad | 45143 | 8531 | 37127 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_I02.ndf | 58 | 5 | 46 | Bad | 45491 | 8852 | 37006 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_I03.ndf | 58 | 5 | 44 | Bad | 45042 | 9513 | 35606 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_I10.ndf | 60 | 4 | 44 | Bad | 45571 | 10186 | 35289 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_I04.ndf | 56 | 5 | 43 | Bad | 45976 | 9596 | 36639 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_I06.ndf | 57 | 4 | 43 | Bad | 44973 | 9664 | 35893 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_I08.ndf | 59 | 4 | 43 | Bad | 45547 | 8887 | 34519 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_I05.ndf | 56 | 4 | 42 | Bad | 45104 | 9938 | 35689 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_I07.ndf | 58 | 3 | 40 | Bad | 45321 | 10583 | 33650 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_I01.ndf | 53 | 4 | 38 | Bad | 80628 | 10479 | 59463 |
| D: | riopro_export | D:\MSSQL\DADOS\riopro_export.mdf | 3 | 44 | 29 | Bad | 1004076 | 283698 | 544299 |
| T: | tempdb | T:\MSSQL\TEMPDB\temp2.mdf | 9 | 28 | 19 | Poor | 64643 | 63927 | 64273 |
| T: | tempdb | T:\MSSQL\TEMPDB\temp3.mdf | 9 | 28 | 19 | Poor | 64634 | 63902 | 64256 |
| T: | tempdb | T:\MSSQL\TEMPDB\temp4.mdf | 9 | 28 | 19 | Poor | 64650 | 63920 | 64274 |
| T: | tempdb | T:\MSSQL\TEMPDB\temp5.mdf | 9 | 28 | 19 | Poor | 64645 | 63897 | 64259 |
| T: | tempdb | T:\MSSQL\TEMPDB\temp6.mdf | 9 | 28 | 19 | Poor | 64646 | 63904 | 64263 |
| T: | tempdb | T:\MSSQL\TEMPDB\temp7.mdf | 9 | 28 | 19 | Poor | 64637 | 63889 | 64251 |
| T: | tempdb | T:\MSSQL\TEMPDB\temp8.mdf | 9 | 28 | 19 | Poor | 64661 | 63895 | 64266 |
| T: | tempdb | T:\MSSQL\TEMPDB\tempdev.mdf | 9 | 28 | 19 | Poor | 64630 | 63768 | 64185 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_2.ndf | 11 | 13 | 12 | Poor | 45227 | 11844 | 40744 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_3.ndf | 12 | 9 | 12 | Poor | 44861 | 11633 | 40007 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD_1.ndf | 11 | 12 | 11 | Poor | 46836 | 11367 | 42786 |
| D: | CustomizacoesERP | D:\mssql\dados\CustomizacoesERP.mdf | 10 | 2 | 10 | Good | 86569 | 8718 | 81257 |
| D: | ESB | D:\MSSQL\DADOS\ESB.mdf | 2 | 23 | 10 | Good | 42703 | 14954 | 32381 |
| D: | SDBPRD | D:\MSSQL\DADOS\SDBPRD.mdf | 9 | 9 | 9 | Good | 65347 | 10117 | 63568 |
| D: | SVSDB | D:\MSSQL\DADOS\SVSDB.mdf | 2 | 10 | 9 | Good | 48379 | 21461 | 26715 |
| D: | SDBPRD_TSS | D:\MSSQL\DADOS\SDBPRD_TSS.mdf | 10 | 1 | 8 | Good | 46105 | 8547 | 40668 |
| C: | msdb | C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf | 5 | 5 | 5 | Very good | 61125 | 9524 | 43627 |
| L: | SVSDB | L:\MSSQL\LOG\SVSDB_log.ldf | 1 | 7 | 5 | Very good | 65046 | 46095 | 54050 |
| L: | riopro_export | L:\MSSQL\LOG\riopro_export_log.ldf | 2 | 2 | 2 | Very good | 13901 | 57721 | 57392 |
| D: | CustomizacoesERP | D:\MSSQL\DADOS\CustomizacoesERP_I01.ndf | 2 | 3 | 2 | Very good | 52866 | 9847 | 31819 |
| D: | DB_DBA | D:\MSSQL\DADOS\DB_DBA_Audit.mdf | 2 | 8 | 2 | Very good | 61328 | 8192 | 60861 |
| C: | master | C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\master.mdf | 2 | 1 | 2 | Very good | 49037 | 8787 | 32530 |
| T: | tempdb | T:\MSSQL\TEMPDB\templog.ldf | 0 | 1 | 1 | Excellent | 18022 | 60687 | 60684 |
| L: | SDBPRD_TSS | L:\MSSQL\LOG\SDBPRD_TSS_log.ldf | 5 | 1 | 1 | Excellent | 979792 | 4309 | 8227 |
| D: | BackupSDBPRD | D:\MSSQL\DADOS\BackupSDBPRD.mdf | 1 | 0 | 1 | Excellent | 55572 | 8192 | 29730 |
| L: | BackupSDBPRD | L:\MSSQL\LOG\BackupSDBPRD_log.ldf | 1 | 1 | 1 | Excellent | 21528 | 5843 | 7679 |
| D: | Smartview | D:\MSSQL\DADOS\Smartview.mdf | 2 | 1 | 1 | Excellent | 52850 | 9179 | 12007 |
| L: | Smartview | L:\MSSQL\LOG\Smartview_log.ldf | 5 | 1 | 1 | Excellent | 927139 | 5303 | 8865 |
| C: | model | C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\model.mdf | 2 | 1 | 1 | Excellent | 68155 | 8192 | 33533 |
| C: | msdb | C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf | 2 | 1 | 1 | Excellent | 23964 | 7139 | 7404 |
| L: | ESB | L:\MSSQL\LOG\ESB_log.ldf | 3 | 1 | 1 | Excellent | 834327 | 6205 | 11172 |
| D: | DB_DBA | D:\MSSQL\DADOS\DB_DBA.mdf | 1 | 1 | 1 | Excellent | 46141 | 8192 | 26567 |
| L: | DB_DBA | L:\MSSQL\LOG\DB_DBA_log.ldf | 1 | 0 | 1 | Excellent | 48901 | 6127 | 8938 |
| L: | CustomizacoesERP | L:\MSSQL\LOG\CustomizacoesERP_log.ldf | 1 | 0 | 0 | Excellent | 111285 | 4967 | 8349 |
| L: | SDBPRD | L:\MSSQL\LOG\SDBPRD_log.ldf | 5 | 0 | 0 | Excellent | 899614 | 5050 | 10087 |
| C: | model | C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\modellog.ldf | 0 | 1 | 0 | Excellent | 15730 | 5721 | 7510 |
| C: | master | C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\mastlog.ldf | 2 | 0 | 0 | Excellent | 22186 | 4342 | 4377 |
| 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 |
|---|---|---|---|---|---|---|---|---|---|
| ASYNC_NETWORK_IO | 8844.17 | 8832.32 | 11.85 | 103115 | 43.49 | 0.0858 | 0.0857 | 0.0001 | https://www.sqlskills.com/help/waits/ASYNC_NETWORK_IO |
| CXPACKET | 7437.14 | 6766.13 | 671.01 | 2256853 | 36.57 | 0.0033 | 0.0030 | 0.0003 | https://www.sqlskills.com/help/waits/CXPACKET |
| LATCH_EX | 1693.92 | 1558.09 | 135.83 | 838927 | 8.33 | 0.0020 | 0.0019 | 0.0002 | https://www.sqlskills.com/help/waits/LATCH_EX |
| SOS_SCHEDULER_YIELD | 758.76 | 0.76 | 758.00 | 1804647 | 3.73 | 0.0004 | 0.0000 | 0.0004 | https://www.sqlskills.com/help/waits/SOS_SCHEDULER_YIELD |
| LCK_M_S | 379.51 | 379.50 | 0.01 | 38 | 1.87 | 9.9871 | 9.9869 | 0.0002 | https://www.sqlskills.com/help/waits/LCK_M_S |
| WRITELOG | 312.37 | 290.54 | 21.83 | 136669 | 1.54 | 0.0023 | 0.0021 | 0.0002 | https://www.sqlskills.com/help/waits/WRITELOG |
| Exec Count | Total CPU (s) | Avg CPU (ms) | Query Text |
|---|---|---|---|
| 135338151 | 2311.39 | 0.02 | SELECT [IDX_NAME] FROM [TOP_VIRTUALIDX] WHERE [IDX_ENV]=@1 AND [IDX_NAME]=@2 |
| 4691317 | 794.46 | 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 |
| 3600852 | 358.65 | 0.10 | SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1 |
| 4843870 | 166.21 | 0.03 | SELECT [XX1_PARAM] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1 |
| 32484 | 128.61 | 3.96 | SELECT
@reservedpages = SUM (reserved_page_count),
@usedpages = SUM (used_page_count),
@pages = SUM (
CASE
WHEN (index_id < 2) THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count)
ELSE 0
END
),
@rowCount = SUM (
CASE
WHEN (index_id < 2) THEN row_count
ELSE 0
END
)
FROM sys.dm_db_partition_stats
WHERE object_id = @id |
| 4843870 | 121.87 | 0.03 | SELECT [XX1_DESCR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1 |
| 1152216 | 119.63 | 0.10 | SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1 |
| 9 | 112.51 | 12501.63 | SELECT TOP 250 R_E_C_N_O_ FROM dbo.CT2010 WHERE D_E_L_E_T_ = ' ' AND (CT2_DATA >= '20260101' AND CHARINDEX(( '073296227' ),CONVERT(CHAR(40),( CT2_HIST )))>0 AND CHARINDEX(( '03RJ' ),CONVERT(CHAR(8),( CT2_FILIAL )))>0 ) ORDER BY CT2_FILIAL DESC ,CT2_DATA DESC ,CT2_LOTE DESC ,CT2_SBLOTE DESC ,CT2_DOC DESC ,CT2_LINHA DESC ,CT2_TPSALD DESC ,CT2_EMPORI DESC ,CT2_FILORI DESC ,CT2_MOEDLC DESC ,R_E_C_N_O_ DESC |
| 4843870 | 110.45 | 0.02 | SELECT [XX1_RECORR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1 |
| 847202 | 108.48 | 0.13 | DELETE [SYS_APP_PARAM] WHERE [APP_PARAM]=@1 |
| Exec Count | Total Duration (s) | Avg Duration (ms) | Total CPU (s) | Avg CPU (ms) | Total Reads | Query Text |
|---|---|---|---|---|---|---|
| 135338173 | 2320.83 | 0.02 | 2311.39 | 0.02 | 270999474 | SELECT [IDX_NAME] FROM [TOP_VIRTUALIDX] WHERE [IDX_ENV]=@1 AND [IDX_NAME]=@2 |
| 4691317 | 1208.67 | 0.26 | 794.46 | 0.17 | 50327383 | 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 |
| 1593236 | 388.24 | 0.24 | 63.45 | 0.04 | 24669762 | SELECT [XX3_TRANS] FROM [dbo].[XX3010] WHERE [R_E_C_N_O_]=@1 |
| 3600852 | 363.88 | 0.10 | 358.65 | 0.10 | 107482887 | SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1 |
| 1 | 310.50 | 310498.43 | 0.00 | 0.22 | 8 | 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 (92942,83977) ORDER BY R_E_C_N_O_ |
| 4843870 | 166.52 | 0.03 | 166.21 | 0.03 | 65330840 | SELECT [XX1_PARAM] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1 |
| 847202 | 161.26 | 0.19 | 108.48 | 0.13 | 11110189 | DELETE [SYS_APP_PARAM] WHERE [APP_PARAM]=@1 |
| 230728 | 153.41 | 0.66 | 81.31 | 0.35 | 16268679 | INSERT INTO SN4010 (N4_FILIAL , N4_CBASE , N4_ITEM , N4_TIPO , N4_OCORR , N4_MOTIVO , N4_TIPOCNT , N4_CONTA , N4_DATA ,
N4_QUANTD , N4_VLROC1 , N4_VLROC2 , N4_VLROC3 , N4_VLROC4 , N4_VLROC5 , N4_SERIE , N4_NOTA , N4_VENDA , N4_TXMEDIA ,
N4_TXDEPR , N4_CCUSTO , N4_LOCAL , N4_SEQ , N4_SUBCTA , N4_SEQREAV , N4_CODBAIX , N4_FILORIG , N4_CLVL , N4_DCONTAB ,
R_E_C_N_O_ , N4_TPSALDO , N4_QUANTPR , N4_CALCPIS , N4_IDMOV , N4_ORIGEM , N4_LP , N4_LA )
VALUES (@IN_FILIAL , @IN_CBASE , @IN_ITEM , @IN_TIPO , @IN_OCORR , @IN_MOTIVO , @IN_TIPOCNT , @IN_CONTA , @IN_DATA , @nQUANTD ,
@nVLROC1 , @nVLROC2 , @nVLROC3 , @nVLROC4 , @nVLROC5 , @IN_SERIE , @IN_NOTA , @nVENDA , @nTXMEDIA , @nTXDEPR ,
@IN_CCUSTO , @IN_LOCAL , @IN_SEQ , @IN_SUBCTA , @IN_SEQREAV , @IN_CODBAIX , @IN_FILORIG , @IN_CLVL , @IN_DCONTAB ,
@iRecno , @IN_TPSALDO , @IN_QUANTPR , @IN_CALCPIS , @IN_IDMOV , 'ATFA050' , '820' , 'N' ) |
| 32484 | 131.31 | 4.04 | 128.61 | 3.96 | 78387559 | SELECT
@reservedpages = SUM (reserved_page_count),
@usedpages = SUM (used_page_count),
@pages = SUM (
CASE
WHEN (index_id < 2) THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count)
ELSE 0
END
),
@rowCount = SUM (
CASE
WHEN (index_id < 2) THEN row_count
ELSE 0
END
)
FROM sys.dm_db_partition_stats
WHERE object_id = @id |
| 4843871 | 122.16 | 0.03 | 121.87 | 0.03 | 63049860 | SELECT [XX1_DESCR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1 |
| Job Name | Execucao | Resultado | Duracao (HH:MM:SS) | Mensagem |
|---|---|---|---|---|
| Nenhum job executado na última hora. | ||||
| SPID | Status | Bloqueado Por | Tipo de Espera | Tempo Espera | Decorrrido | CPU (ms) | L.Reads | Reads | Writes | Login | ERP User | ERP ID | Host | ERP IP | Programa | ERP Prog | Objeto | Texto da Query |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 348 | running | 0 | 00:00:00 | 0d 00:00:03 | 3389 | 4303926 | 0 | 0 | protheus27 | SELECT TOP 250 R_E_C_N_O_, D_E_L_E_T_, E1_FILIAL FROM dbo.SE1010 WHERE E1_FILIAL >= '01RJ0001' AND D_E_L_E_T_ = ' ' AND ( (LOWER(E1_CLIENTE) LIKE '%p00508620%') AND E1_FILIAL IN ('01RJ0001','02RJ0001','02RJ0017','02RJ0030','02RJ0048','02RJ0050','03RJ0013','03RJ0030','03RJ0057','03RJ0060')) ORDER BY E1_FILIAL,E1_PREFIXO,E1_NUM,E1_PARCELA,E1_TIPO,R_E_C_N_O_ | ||||||||
| 1320 | suspended | 0 | ASYNC_NETWORK_IO | 00:00:01 | 2d 23:36:25 | 1328 | 48628 | 72 | 4 | protheus27 | SELECT
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN SC7.C7_FISCORI
ELSE ''
END FILIALDEST,
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
A2.C1_NUM)
FROM SC7010 A1 (NOLOCK)
INNER JOIN SC1010 A2 ON
A2.C1_FILIAL = A1.C7_FISCORI AND
A2.C1_NUM = A1.C7_NUMSC AND
A2.C1_ITEM = A1.C7_ITEMSC AND
A2.C1_PRODUTO = A1.C7_PRODUTO AND
A2.D_E_L_E_T_ = A1.D_E_L_E_T_
WHERE
A1.C7_FILIAL = SC7.C7_FILIAL AND
A1.C7_NUM = SC7.C7_NUM AND
A1.C7_NUMPR = SC7.C7_NUMPR AND
A1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE ''
END SCDEST,
SC7.C7_FILIAL FILIALORIG,
CASE WHEN SC7.C7_FILIAL = SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_NUM)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FILIAL AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_SCORI)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FISCORI AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
END SCDORIG,
SC7.C7_NUM PEDIDO,
SA2.A2_CGC CNPJFornec,
SA2.A2_NOME FORNEC,
SC7.C7_FORNECE CODFOR,
SC7.C7_LOJA LOJFOR,
SUM(SC7.C7_TOTAL) VLRPED,
COALESCE(STUFF((SELECT DISTINCT (', ' +
CASE WHEN C.C7_QUJE = 0 AND
C.C7_RESIDUO = 'S' AND
C.C7_XCANCE != ''
THEN 'Cancelado'
WHEN C.C7_TIPO != 1
THEN 'Autorizacao de Entrega ou Pedido'
WHEN C.C7_RESIDUO != ''
THEN 'Eliminado por Residuo'
WHEN C.C7_ACCPROC != '1' AND
C.C7_CONAPRO = 'B' AND
C.C7_QUJE < C.C7_QUANT
THEN 'Bloqueado'
WHEN C.C7_QUJE = 0 AND
C.C7_QTDACLA = 0
THEN 'Pendente'
WHEN C.C7_QUJE != 0 AND
C.C7_QUJE < C.C7_QUANT
THEN 'Pedido Parcialmente Atendido'
WHEN C.C7_QUJE >= C.C7_QUANT
THEN 'Pedido Atendido'
WHEN C.C7_QTDACLA > 0
THEN 'Pedido Usado em Pre-Nota'
END)
FROM SC7010 C (NOLOCK)
WHERE
C.C7_FILIAL = SC7.C7_FILIAL AND
C.C7_NUM = SC7.C7_NUM AND
C.C7_NUMPR = SC7.C7_NUMPR AND
C.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '') STSPED,
SC7.C7_NUMPR PROCESSO,
(SELECT TOP 1 ISNULL(CONVERT(VARCHAR(2047), CONVERT(VARBINARY(2047), D.C7_XOBSGE)), '') XML
FROM SC7010 D (NOLOCK)
WHERE
D.C7_FILIAL = SC7.C7_FILIAL AND
D.C7_NUM = SC7.C7_NUM AND
D.C7_NUMPR = SC7.C7_NUMPR AND
D.D_E_L_E_T_ = ''
ORDER BY D.C7_ITEM DESC
) OBSGERAL,
SC7.C7_XENDEN ENDENTREGA
FROM SC7010 SC7 (NOLOCK)
INNER JOIN SA2010 SA2 (NOLOCK) ON
SC7.C7_FORNECE = SA2.A2_COD AND
SC7.C7_LOJA = SA2.A2_LOJA
WHERE
SC7.C7_NUMPR = 'SC 00221/2025 ' AND
SA2.A2_FILIAL = ' ' AND
SC7.D_E_L_E_T_ = '' AND
SA2.D_E_L_E_T_ = ''
GROUP BY
C7_FILIAL,
C7_FISCORI,
C7_NUM,
C7_FORNECE,
C7_LOJA,
C7_NUMPR,
C7_XENDEN,
A2_CGC,
A2_NOME,
C7_FISCORI
ORDER BY
C7_FILIAL,
C7_NUM | |||||||
| 451 | suspended | 0 | ASYNC_NETWORK_IO | 00:00:01 | 0d 00:52:55 | 243 | 46257 | 281 | 0 | protheus27 | SELECT
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN SC7.C7_FISCORI
ELSE ''
END FILIALDEST,
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
A2.C1_NUM)
FROM SC7010 A1 (NOLOCK)
INNER JOIN SC1010 A2 ON
A2.C1_FILIAL = A1.C7_FISCORI AND
A2.C1_NUM = A1.C7_NUMSC AND
A2.C1_ITEM = A1.C7_ITEMSC AND
A2.C1_PRODUTO = A1.C7_PRODUTO AND
A2.D_E_L_E_T_ = A1.D_E_L_E_T_
WHERE
A1.C7_FILIAL = SC7.C7_FILIAL AND
A1.C7_NUM = SC7.C7_NUM AND
A1.C7_NUMPR = SC7.C7_NUMPR AND
A1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE ''
END SCDEST,
SC7.C7_FILIAL FILIALORIG,
CASE WHEN SC7.C7_FILIAL = SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_NUM)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FILIAL AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_SCORI)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FISCORI AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
END SCDORIG,
SC7.C7_NUM PEDIDO,
SA2.A2_CGC CNPJFornec,
SA2.A2_NOME FORNEC,
SC7.C7_FORNECE CODFOR,
SC7.C7_LOJA LOJFOR,
SUM(SC7.C7_TOTAL) VLRPED,
COALESCE(STUFF((SELECT DISTINCT (', ' +
CASE WHEN C.C7_QUJE = 0 AND
C.C7_RESIDUO = 'S' AND
C.C7_XCANCE != ''
THEN 'Cancelado'
WHEN C.C7_TIPO != 1
THEN 'Autorizacao de Entrega ou Pedido'
WHEN C.C7_RESIDUO != ''
THEN 'Eliminado por Residuo'
WHEN C.C7_ACCPROC != '1' AND
C.C7_CONAPRO = 'B' AND
C.C7_QUJE < C.C7_QUANT
THEN 'Bloqueado'
WHEN C.C7_QUJE = 0 AND
C.C7_QTDACLA = 0
THEN 'Pendente'
WHEN C.C7_QUJE != 0 AND
C.C7_QUJE < C.C7_QUANT
THEN 'Pedido Parcialmente Atendido'
WHEN C.C7_QUJE >= C.C7_QUANT
THEN 'Pedido Atendido'
WHEN C.C7_QTDACLA > 0
THEN 'Pedido Usado em Pre-Nota'
END)
FROM SC7010 C (NOLOCK)
WHERE
C.C7_FILIAL = SC7.C7_FILIAL AND
C.C7_NUM = SC7.C7_NUM AND
C.C7_NUMPR = SC7.C7_NUMPR AND
C.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '') STSPED,
SC7.C7_NUMPR PROCESSO,
(SELECT TOP 1 ISNULL(CONVERT(VARCHAR(2047), CONVERT(VARBINARY(2047), D.C7_XOBSGE)), '') XML
FROM SC7010 D (NOLOCK)
WHERE
D.C7_FILIAL = SC7.C7_FILIAL AND
D.C7_NUM = SC7.C7_NUM AND
D.C7_NUMPR = SC7.C7_NUMPR AND
D.D_E_L_E_T_ = ''
ORDER BY D.C7_ITEM DESC
) OBSGERAL,
SC7.C7_XENDEN ENDENTREGA
FROM SC7010 SC7 (NOLOCK)
INNER JOIN SA2010 SA2 (NOLOCK) ON
SC7.C7_FORNECE = SA2.A2_COD AND
SC7.C7_LOJA = SA2.A2_LOJA
WHERE
SC7.C7_NUMPR = 'SC 00169/2024 ' AND
SA2.A2_FILIAL = ' ' AND
SC7.D_E_L_E_T_ = '' AND
SA2.D_E_L_E_T_ = ''
GROUP BY
C7_FILIAL,
C7_FISCORI,
C7_NUM,
C7_FORNECE,
C7_LOJA,
C7_NUMPR,
C7_XENDEN,
A2_CGC,
A2_NOME,
C7_FISCORI
ORDER BY
C7_FILIAL,
C7_NUM | |||||||
| 85 | running | 0 | 00:00:00 | 0d 00:00:00 | 0 | 4 | 0 | 0 | protheus27 | SELECT TOP 40 R_E_C_N_O_ FROM dbo.XX2 WHERE XX2_AGEND > '000028' AND D_E_L_E_T_ = ' ' ORDER BY XX2_AGEND,XX2_EMPFIL,R_E_C_N_O_ |
| SPID | DOP (Grau de Paralelismo) | Login | Host | Status | Tipo de Espera | Texto da Query |
|---|---|---|---|---|---|---|
| 451 | 1 | protheus27 | suspended | ASYNC_NETWORK_IO | SELECT
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN SC7.C7_FISCORI
ELSE ''
END FILIALDEST,
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
A2.C1_NUM)
FROM SC7010 A1 (NOLOCK)
INNER JOIN SC1010 A2 ON
A2.C1_FILIAL = A1.C7_FISCORI AND
A2.C1_NUM = A1.C7_NUMSC AND
A2.C1_ITEM = A1.C7_ITEMSC AND
A2.C1_PRODUTO = A1.C7_PRODUTO AND
A2.D_E_L_E_T_ = A1.D_E_L_E_T_
WHERE
A1.C7_FILIAL = SC7.C7_FILIAL AND
A1.C7_NUM = SC7.C7_NUM AND
A1.C7_NUMPR = SC7.C7_NUMPR AND
A1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE ''
END SCDEST,
SC7.C7_FILIAL FILIALORIG,
CASE WHEN SC7.C7_FILIAL = SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_NUM)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FILIAL AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_SCORI)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FISCORI AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
END SCDORIG,
SC7.C7_NUM PEDIDO,
SA2.A2_CGC CNPJFornec,
SA2.A2_NOME FORNEC,
SC7.C7_FORNECE CODFOR,
SC7.C7_LOJA LOJFOR,
SUM(SC7.C7_TOTAL) VLRPED,
COALESCE(STUFF((SELECT DISTINCT (', ' +
CASE WHEN C.C7_QUJE = 0 AND
C.C7_RESIDUO = 'S' AND
C.C7_XCANCE != ''
THEN 'Cancelado'
WHEN C.C7_TIPO != 1
THEN 'Autorizacao de Entrega ou Pedido'
WHEN C.C7_RESIDUO != ''
THEN 'Eliminado por Residuo'
WHEN C.C7_ACCPROC != '1' AND
C.C7_CONAPRO = 'B' AND
C.C7_QUJE < C.C7_QUANT
THEN 'Bloqueado'
WHEN C.C7_QUJE = 0 AND
C.C7_QTDACLA = 0
THEN 'Pendente'
WHEN C.C7_QUJE != 0 AND
C.C7_QUJE < C.C7_QUANT
THEN 'Pedido Parcialmente Atendido'
WHEN C.C7_QUJE >= C.C7_QUANT
THEN 'Pedido Atendido'
WHEN C.C7_QTDACLA > 0
THEN 'Pedido Usado em Pre-Nota'
END)
FROM SC7010 C (NOLOCK)
WHERE
C.C7_FILIAL = SC7.C7_FILIAL AND
C.C7_NUM = SC7.C7_NUM AND
C.C7_NUMPR = SC7.C7_NUMPR AND
C.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '') STSPED,
SC7.C7_NUMPR PROCESSO,
(SELECT TOP 1 ISNULL(CONVERT(VARCHAR(2047), CONVERT(VARBINARY(2047), D.C7_XOBSGE)), '') XML
FROM SC7010 D (NOLOCK)
WHERE
D.C7_FILIAL = SC7.C7_FILIAL AND
D.C7_NUM = SC7.C7_NUM AND
D.C7_NUMPR = SC7.C7_NUMPR AND
D.D_E_L_E_T_ = ''
ORDER BY D.C7_ITEM DESC
) OBSGERAL,
SC7.C7_XENDEN ENDENTREGA
FROM SC7010 SC7 (NOLOCK)
INNER JOIN SA2010 SA2 (NOLOCK) ON
SC7.C7_FORNECE = SA2.A2_COD AND
SC7.C7_LOJA = SA2.A2_LOJA
WHERE
SC7.C7_NUMPR = 'SC 00169/2024 ' AND
SA2.A2_FILIAL = ' ' AND
SC7.D_E_L_E_T_ = '' AND
SA2.D_E_L_E_T_ = ''
GROUP BY
C7_FILIAL,
C7_FISCORI,
C7_NUM,
C7_FORNECE,
C7_LOJA,
C7_NUMPR,
C7_XENDEN,
A2_CGC,
A2_NOME,
C7_FISCORI
ORDER BY
C7_FILIAL,
C7_NUM | |
| 1320 | 1 | protheus27 | suspended | ASYNC_NETWORK_IO | SELECT
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN SC7.C7_FISCORI
ELSE ''
END FILIALDEST,
CASE WHEN SC7.C7_FILIAL != SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
A2.C1_NUM)
FROM SC7010 A1 (NOLOCK)
INNER JOIN SC1010 A2 ON
A2.C1_FILIAL = A1.C7_FISCORI AND
A2.C1_NUM = A1.C7_NUMSC AND
A2.C1_ITEM = A1.C7_ITEMSC AND
A2.C1_PRODUTO = A1.C7_PRODUTO AND
A2.D_E_L_E_T_ = A1.D_E_L_E_T_
WHERE
A1.C7_FILIAL = SC7.C7_FILIAL AND
A1.C7_NUM = SC7.C7_NUM AND
A1.C7_NUMPR = SC7.C7_NUMPR AND
A1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE ''
END SCDEST,
SC7.C7_FILIAL FILIALORIG,
CASE WHEN SC7.C7_FILIAL = SC7.C7_FISCORI
THEN COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_NUM)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FILIAL AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
ELSE COALESCE(STUFF((SELECT DISTINCT (', ' +
B2.C1_SCORI)
FROM SC7010 B1 (NOLOCK)
INNER JOIN SC1010 B2 (NOLOCK) ON
B2.C1_FILIAL = B1.C7_FISCORI AND
B2.C1_NUM = B1.C7_NUMSC AND
B2.C1_ITEM = B1.C7_ITEMSC AND
B2.C1_PRODUTO = B1.C7_PRODUTO AND
B2.D_E_L_E_T_ = B1.D_E_L_E_T_
WHERE
B1.C7_FILIAL = SC7.C7_FILIAL AND
B1.C7_NUM = SC7.C7_NUM AND
B1.C7_NUMPR = SC7.C7_NUMPR AND
B1.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '')
END SCDORIG,
SC7.C7_NUM PEDIDO,
SA2.A2_CGC CNPJFornec,
SA2.A2_NOME FORNEC,
SC7.C7_FORNECE CODFOR,
SC7.C7_LOJA LOJFOR,
SUM(SC7.C7_TOTAL) VLRPED,
COALESCE(STUFF((SELECT DISTINCT (', ' +
CASE WHEN C.C7_QUJE = 0 AND
C.C7_RESIDUO = 'S' AND
C.C7_XCANCE != ''
THEN 'Cancelado'
WHEN C.C7_TIPO != 1
THEN 'Autorizacao de Entrega ou Pedido'
WHEN C.C7_RESIDUO != ''
THEN 'Eliminado por Residuo'
WHEN C.C7_ACCPROC != '1' AND
C.C7_CONAPRO = 'B' AND
C.C7_QUJE < C.C7_QUANT
THEN 'Bloqueado'
WHEN C.C7_QUJE = 0 AND
C.C7_QTDACLA = 0
THEN 'Pendente'
WHEN C.C7_QUJE != 0 AND
C.C7_QUJE < C.C7_QUANT
THEN 'Pedido Parcialmente Atendido'
WHEN C.C7_QUJE >= C.C7_QUANT
THEN 'Pedido Atendido'
WHEN C.C7_QTDACLA > 0
THEN 'Pedido Usado em Pre-Nota'
END)
FROM SC7010 C (NOLOCK)
WHERE
C.C7_FILIAL = SC7.C7_FILIAL AND
C.C7_NUM = SC7.C7_NUM AND
C.C7_NUMPR = SC7.C7_NUMPR AND
C.D_E_L_E_T_ = ''
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(2000)'), 1, 2, ''), '') STSPED,
SC7.C7_NUMPR PROCESSO,
(SELECT TOP 1 ISNULL(CONVERT(VARCHAR(2047), CONVERT(VARBINARY(2047), D.C7_XOBSGE)), '') XML
FROM SC7010 D (NOLOCK)
WHERE
D.C7_FILIAL = SC7.C7_FILIAL AND
D.C7_NUM = SC7.C7_NUM AND
D.C7_NUMPR = SC7.C7_NUMPR AND
D.D_E_L_E_T_ = ''
ORDER BY D.C7_ITEM DESC
) OBSGERAL,
SC7.C7_XENDEN ENDENTREGA
FROM SC7010 SC7 (NOLOCK)
INNER JOIN SA2010 SA2 (NOLOCK) ON
SC7.C7_FORNECE = SA2.A2_COD AND
SC7.C7_LOJA = SA2.A2_LOJA
WHERE
SC7.C7_NUMPR = 'SC 00221/2025 ' AND
SA2.A2_FILIAL = ' ' AND
SC7.D_E_L_E_T_ = '' AND
SA2.D_E_L_E_T_ = ''
GROUP BY
C7_FILIAL,
C7_FISCORI,
C7_NUM,
C7_FORNECE,
C7_LOJA,
C7_NUMPR,
C7_XENDEN,
A2_CGC,
A2_NOME,
C7_FISCORI
ORDER BY
C7_FILIAL,
C7_NUM |
| SPID | Objeto | Modo | Status | Login | Programa | Host | Transacoes Abertas | Inicio |
|---|---|---|---|---|---|---|---|---|
| 85 | XX2 | Sch-S | GRANT | protheus27 | 0 | 2026-03-09 12:32:47 | ||
| 124 | SXH_XH_CBHREXE_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-09 12:32:49 | ||
| 348 | SE1010 | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:25:18 | ||
| 451 | SA2010 | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 14:32:26 | ||
| 451 | SC1010 | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 14:32:26 | ||
| 451 | SC7010 | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 14:32:26 | ||
| 1051 | SF1010_F1_ESPECI2_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_ESPECIF_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_INSS_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_CONTCQP_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_NUMCQPR_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_AGREGCU_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_BASE3_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_DESPIMP_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_NFPNUM_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_APOPRO_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_PAUTFET_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_VFCPANT_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_BALANCA_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_PRFDSUL_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_VALFECP_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_CODLAN_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_SKIPLOT_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_DESCZFP_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_BASE2_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_BFCPANT_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_OPC_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ICMSRET_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_BASEFMD_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_VALDEV_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ALQFMP_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_PRN944I_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_QTDEDEV_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_DESBSE2_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ORIGLAN_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_SLDEXP_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_IVAAJU_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_VALPS3_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_DATACUS_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ITEMORI_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_CODNOR_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_QTDCONF_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_NUMSEQ_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_BASEPIS_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_CONINI_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_TNATREC_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_PRVALID_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_VALFAB_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_NOTAMIN_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_SERIE_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ABATMAT_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_DTREFP1_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_FUSTF_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_COMIS_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_FORAEST_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_BASEPS3_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_UREV_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_CODDIS_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ALIQFAB_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_ORIGEM_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_TIPODEC_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_VLCIF_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ALFCCMP_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_LOJPROC_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_PARCEI_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_CSOSN_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_DCI_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_MSBLQL_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_GRPTI_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_CODPROC_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_TES_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_FTRICMS_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_CCCUSTO_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_VALIPI_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_TOTAL_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_HREXPO_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_PAFMD5_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_QUANT_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_EXPSOP_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_AFETHAB_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_UMOEC_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_UM_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_POTENCI_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_PORCPRL_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ITEM_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ALQCPM_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_REGWMS_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SE2010_E2_JUROS_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_AFACS_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010 | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_VALCPM_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_TPDP_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_VLCIDE_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ENDER_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_ORDEM_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SE2010_E2_DATACAN_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_BASECPB_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SD1010_D1_LOCPAD_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_CEST_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 | ||
| 1057 | SB1010_B1_CONV_DF | Sch-S | GRANT | protheus27 | 0 | 2026-03-13 15:20:51 |
| 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. | ||||||||||
| Data de Criacao | SPID Vítima | SPIDs Envolvidos | Relatorio de Deadlock (XML) |
|---|---|---|---|
| Nenhum deadlock encontrado no ring_buffer para este banco de dados. | |||
| Exec Count | Total CPU (ms) | Avg CPU (ms) | Total Duration (ms) | Avg Duration (ms) | Total Reads | Query Text |
|---|---|---|---|---|---|---|
| 520414 | 68319.00 | 0.13 | 82347.41 | 0.16 | 12661438 | UPDATE F75010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 94573 | 13064.28 | 0.14 | 14079.45 | 0.15 | 2112621 | UPDATE F76010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 49459 | 9888.70 | 0.20 | 12122.82 | 0.25 | 1045207 | UPDATE SC7010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 53382 | 9490.67 | 0.18 | 15517.78 | 0.29 | 1286083 | UPDATE CTK010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 36087 | 9054.71 | 0.25 | 18694.59 | 0.52 | 909616 | UPDATE SE2010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 18634 | 7440.40 | 0.40 | 7841.01 | 0.42 | 439233 | 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_ = ' ' |
| 41885 | 7037.69 | 0.17 | 10952.09 | 0.26 | 733376 | UPDATE SEA010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 19982 | 6185.22 | 0.31 | 27077.03 | 1.36 | 741484 | INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY ) |
| 105109 | 5497.18 | 0.05 | 5503.78 | 0.05 | 420724 | 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_ = ' ' |
| 20419 | 5226.71 | 0.26 | 12685.29 | 0.62 | 548505 | UPDATE SE1010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| Exec Count | Total Duration (ms) | Avg Duration (ms) | Total CPU (ms) | Avg CPU (ms) | Total Reads | Query Text |
|---|---|---|---|---|---|---|
| 520414 | 82347.41 | 0.16 | 68319.00 | 0.13 | 12661438 | UPDATE F75010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 19982 | 27077.03 | 1.36 | 6185.22 | 0.31 | 741484 | INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY ) |
| 36087 | 18694.59 | 0.52 | 9054.71 | 0.25 | 909616 | UPDATE SE2010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 53382 | 15517.78 | 0.29 | 9490.67 | 0.18 | 1286083 | UPDATE CTK010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 94573 | 14079.45 | 0.15 | 13064.28 | 0.14 | 2112621 | UPDATE F76010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 21298 | 12698.49 | 0.60 | 3600.88 | 0.17 | 492919 | UPDATE SBZ010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 20419 | 12685.29 | 0.62 | 5226.71 | 0.26 | 548505 | UPDATE SE1010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 49459 | 12122.82 | 0.25 | 9888.70 | 0.20 | 1045207 | UPDATE SC7010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |
| 9813 | 11606.59 | 1.18 | 1017.96 | 0.10 | 54711 | 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_ = ' ' |
| 41885 | 10952.09 | 0.26 | 7037.69 | 0.17 | 733376 | UPDATE SEA010 SET S_T_A_M_P_ = GETUTCDATE() WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED ) |