Diagnóstico SQL Server - DWSGDASQL2

Resumen Ejecutivo SQL

RAM libre host7.33 GB
Memoria SQL comprometida43.94 GB
Page Life Expectancy8185 s
Conexiones SQL389
Volúmenes SQL bajos1
Bloqueos activos0
Bases de datos20
Transacciones abiertas80
Tareas en cola (Q)2
Índices REBUILD46
Logs críticos2
Jobs fallidos10
Autogrowths 7 días50
Deadlocks0

Servidor SQL: SRVCLSGDEA\SGDEAPRY,1633

Host: DWSGDASQL2

Fecha: 06/06/2026 16:01:40

Recomendaciones

Alertas consolidadas

Información del sistema

CSNameCaptionVersionLastBootUpTimeTotalRAMGBFreeRAMGB
DWSGDASQL2Microsoft Windows Server 2019 Standard10.0.177635/24/2026 12:01:11 AM607.33

CPU

NameNumberOfCoresNumberOfLogicalProcessorsMaxClockSpeed
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900
Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz222900

Discos

DeviceIDVolumeNameSizeGBFreeGBFreePercent
C:179.4121.0567.47
D:TEMP299.9878.5726.19
E:DATA5222.38684.0913.1
F:LOG299.98289.7896.6
G:BACKUPS499.98321.9164.38
Q:New Volume19.9819.3696.91
S:Spool299.98298.3399.45

Contadores de rendimiento - muestra 1 minuto

CounterMinMaxAverage
\\dwsgdasql2\processor(_total)\% processor time6.7935.2512.88
\\dwsgdasql2\memory\available mbytes749175477530
\\dwsgdasql2\system\processor queue length000
\\dwsgdasql2\physicaldisk(_total)\% disk time0.458.335.33
\\dwsgdasql2\physicaldisk(_total)\current disk queue length010.33

Información SQL Server

ServerNameEditionProductLevelProductVersionCollationStartTime
SRVCLSGDEA\SGDEAPRYEnterprise Edition: Core-based Licensing (64-bit)RTM15.0.4316.3SQL_Latin1_General_CP1_CI_AS5/29/2026 2:34:52 AM

Memoria SQL

PhysicalMemoryMBCommittedMBCommittedTargetMBPageLifeExpectancySecBufferCacheHitRatio
614394499945000818513792

Bases de datos

DatabaseNameStateRecoveryModelCompatibilityLevelSizeMBCreateDate
OpheliaSuiteONLINEFULL15044951221/25/2023 11:42:38 AM
tempdbONLINESIMPLE1502243785/29/2026 2:36:28 AM
DMSONLINEFULL150974133/9/2024 11:45:05 PM
DriveONLINEFULL1503476411/9/2023 7:00:50 PM
StageONLINEFULL150121705/8/2023 11:39:48 AM
DMS_bk_040923ONLINEFULL15050119/4/2023 11:54:28 AM
DMS_BK_20ONLINEFULL15021956/21/2023 3:24:03 PM
AgoraSSBONLINEFULL15054012/1/2023 10:18:55 PM
msdbONLINEFULL1502649/24/2019 2:21:42 PM
EstructuraImportacionONLINEFULL1501122/24/2024 11:16:01 AM
ImperiumReportCacheONLINEFULL1501122/28/2026 8:36:43 PM
AgoraSSB_OLDONLINEFULL150825/29/2024 3:42:38 PM
DMS_2ONLINEFULL150811/31/2023 8:44:52 AM
modelONLINEFULL150804/8/2003 9:13:36 AM
DBAONLINEFULL150809/29/2023 9:16:16 AM
DMSGDEAONLINEFULL150766/23/2023 10:34:45 AM
DWMaintenanceONLINEFULL150352/6/2023 4:32:54 PM
ProcessTableONLINEFULL150191/25/2023 11:41:51 AM
CalendarioONLINEFULL150111/25/2023 11:40:30 AM
masterONLINESIMPLE15064/8/2003 9:13:36 AM

Conexiones por aplicación

program_namehost_namelogin_nameconnections
MicroSQLDWSGDAAPP1ophelia98
MicroSQLDWSGDAAPP3ophelia88
MicroSQLDWSGDAAPP2ophelia67
MicroSQLDWSGDAAPP2opheliadms20
MicroSQLDWSGDAAPP1opheliadms18
MicroSQLDWSGDAAPP3opheliadms14
ODKDWSGDAAPP3ophelia12
ODKDWSGDAAPP1ophelia10
MicroSQLDWSGDAAPP4opheliadms9
ODKDWSGDAAPP2ophelia8
.Net SqlClient Data ProviderFASECOLDAVMmonitoreosaas5
Core Microsoft SqlClient Data ProviderDWSGDAAPP2opheliadms4
Core Microsoft SqlClient Data ProviderDWSGDAAPP1ophelia3
Core Microsoft SqlClient Data ProviderDWSGDAAPP1opheliadms3
Core Microsoft SqlClient Data ProviderDWSGDAAPP2ophelia2
Microsoft SQL Server Management StudioDWSGDASQL2DIGITALWARE\DominnigM2
Core .Net SqlClient Data ProviderDWSGDAAPP1ophelia2
Core Microsoft SqlClient Data ProviderDWSGDAAPP3ophelia2
Core Microsoft SqlClient Data ProviderDWSGDAAPP3opheliadms2
Core .Net SqlClient Data ProviderDWSGDAAPP3ophelia2
SQLAgent - Contained AGSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLAgent - Email LoggerSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLAgent - Generic RefresherSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLAgent - Job invocation engineSRVCLSGDEADIGITALWARE\SCVSGDA-AGENT1
SQLServerCEIPSRVCLSGDEANT SERVICE\SQLTELEMETRY$SGDEAPRY1
Zabbix agent 2 MSSQL pluginDWSGDASQL2zbx_monitor1
Core Microsoft SqlClient Data ProviderDWSGDAAPP4ophelia1
Core Microsoft SqlClient Data ProviderDWSGDAMON2opheliadms1
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP2ophelia1
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP3ophelia1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP1ophelia1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP2ophelia1
EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP3ophelia1
Core .Net SqlClient Data ProviderDWSGDAAPP2ophelia1
DWSGDAAPP1ophelia1
DWSGDAAPP2ophelia1
.Net SqlClient Data ProviderDWSGDASQL2ophelia1
Microsoft® Windows® Operating SystemDWSGDASQL2NT AUTHORITY\SYSTEM1

Sesiones activas

session_idlogin_namehost_nameprogram_namestatuscommandwait_typewait_timecpu_timelogical_readsDatabaseName
51NT AUTHORITY\SYSTEMDWSGDASQL2Microsoft® Windows® Operating SystemrunningEXECUTESP_SERVER_DIAGNOSTICS_SLEEP55037633master
379opheliaDWSGDASQL2.Net SqlClient Data ProviderrunningSELECT010master

Bloqueos activos

No hay datos.

Transacciones abiertas (> 5 seg)

SessionIdHostAplicacionUsuarioInicioTransaccionSegundosAbiertaTipoTransaccionUltimaConsulta
322DWSGDAAPP3MicroSQLophelia6/5/2026 3:12:16 PM89340Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
134DWSGDAAPP3MicroSQLophelia6/5/2026 3:15:25 PM89151Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
524DWSGDAAPP1MicroSQLophelia6/5/2026 3:15:46 PM89130Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
300DWSGDAAPP3MicroSQLophelia6/5/2026 3:20:54 PM88822Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
434DWSGDAAPP2MicroSQLophelia6/5/2026 3:20:54 PM88822Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
847DWSGDAAPP1MicroSQLophelia6/5/2026 3:22:28 PM88728Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
301DWSGDAAPP1MicroSQLophelia6/5/2026 3:23:20 PM88676Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1188DWSGDAAPP3MicroSQLophelia6/5/2026 3:26:21 PM88495Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
275DWSGDAAPP2MicroSQLophelia6/5/2026 3:31:16 PM88200Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
257DWSGDAAPP3MicroSQLophelia6/5/2026 3:33:02 PM88094Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
200DWSGDAAPP3MicroSQLophelia6/5/2026 3:36:55 PM87861Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
88DWSGDAAPP1MicroSQLophelia6/5/2026 3:36:55 PM87861Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
895DWSGDAAPP1MicroSQLophelia6/5/2026 3:37:58 PM87798Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
922DWSGDAAPP3MicroSQLophelia6/5/2026 3:39:55 PM87681Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
344DWSGDAAPP3MicroSQLophelia6/5/2026 3:42:33 PM87523Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
111DWSGDAAPP3MicroSQLophelia6/5/2026 3:49:09 PM87127Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
866DWSGDAAPP1MicroSQLophelia6/5/2026 3:51:08 PM87008Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2012DWSGDAAPP3MicroSQLophelia6/5/2026 3:52:15 PM86941Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
652DWSGDAAPP2MicroSQLophelia6/5/2026 3:55:55 PM86721Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1512DWSGDAAPP1MicroSQLophelia6/5/2026 3:56:00 PM86716Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
94DWSGDAAPP3MicroSQLophelia6/5/2026 3:58:08 PM86588Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1671DWSGDAAPP1MicroSQLophelia6/5/2026 4:02:00 PM86356Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2157DWSGDAAPP3MicroSQLophelia6/5/2026 4:07:42 PM86014Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2149DWSGDAAPP3MicroSQLophelia6/5/2026 4:09:48 PM85888Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1543DWSGDAAPP3MicroSQLophelia6/5/2026 4:15:12 PM85564Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2142DWSGDAAPP3MicroSQLophelia6/5/2026 4:16:48 PM85468Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2300DWSGDAAPP3MicroSQLophelia6/5/2026 4:17:58 PM85398Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
263DWSGDAAPP1MicroSQLophelia6/5/2026 4:21:03 PM85213Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2260DWSGDAAPP2MicroSQLophelia6/5/2026 4:21:25 PM85191Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
549DWSGDAAPP2MicroSQLophelia6/5/2026 4:23:32 PM85064Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
321DWSGDAAPP2MicroSQLophelia6/5/2026 4:25:47 PM84929Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2401DWSGDAAPP2MicroSQLophelia6/5/2026 4:27:15 PM84841Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1656DWSGDAAPP2MicroSQLophelia6/5/2026 4:31:30 PM84586Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1731DWSGDAAPP3MicroSQLophelia6/5/2026 4:36:28 PM84288Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1894DWSGDAAPP1MicroSQLophelia6/5/2026 4:40:45 PM84031Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1374DWSGDAAPP1MicroSQLophelia6/5/2026 4:41:39 PM83977Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2088DWSGDAAPP3MicroSQLophelia6/5/2026 4:45:39 PM83737Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
101DWSGDAAPP2MicroSQLophelia6/5/2026 4:50:21 PM83455Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
471DWSGDAAPP1MicroSQLophelia6/5/2026 4:56:17 PM83099Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
177DWSGDAAPP2MicroSQLophelia6/5/2026 4:59:32 PM82904Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2311DWSGDAAPP2MicroSQLophelia6/5/2026 5:01:35 PM82781Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
618DWSGDAAPP2MicroSQLophelia6/5/2026 5:34:06 PM80830Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1658DWSGDAAPP3MicroSQLophelia6/5/2026 5:37:54 PM80602Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
1443DWSGDAAPP1MicroSQLophelia6/5/2026 5:42:24 PM80332Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
2053DWSGDAAPP2MicroSQLophelia6/5/2026 5:53:27 PM79669Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
150DWSGDAAPP3MicroSQLophelia6/5/2026 5:54:12 PM79624Read/Write(@p0 varchar(32),@p1 varchar(16),@p2 varchar(9),@p3 varchar(16),@p4 varchar(16),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
469DWSGDAAPP3MicroSQLophelia6/5/2026 6:08:35 PM78761Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
226DWSGDAAPP1MicroSQLophelia6/5/2026 10:20:07 PM63669Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
494DWSGDAAPP2MicroSQLophelia6/6/2026 8:04:26 AM28610Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
290DWSGDAAPP1MicroSQLophelia6/6/2026 8:17:05 AM27851Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
129DWSGDAAPP1MicroSQLophelia6/6/2026 8:23:20 AM27476Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
173DWSGDAAPP2MicroSQLophelia6/6/2026 8:23:57 AM27439Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
421DWSGDAAPP2MicroSQLophelia6/6/2026 8:29:05 AM27131Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
446DWSGDAAPP2MicroSQLophelia6/6/2026 8:35:31 AM26745Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
141DWSGDAAPP1MicroSQLophelia6/6/2026 8:52:25 AM25731Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
80DWSGDAAPP3MicroSQLophelia6/6/2026 8:55:19 AM25557Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
152DWSGDAAPP2MicroSQLophelia6/6/2026 8:55:33 AM25543Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
153DWSGDAAPP1MicroSQLophelia6/6/2026 8:55:33 AM25543Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
394DWSGDAAPP3MicroSQLophelia6/6/2026 8:59:50 AM25286Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
406DWSGDAAPP1MicroSQLophelia6/6/2026 9:04:55 AM24981Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
236DWSGDAAPP2MicroSQLophelia6/6/2026 9:13:49 AM24447Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
175DWSGDAAPP3MicroSQLophelia6/6/2026 9:16:53 AM24263Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
227DWSGDAAPP2MicroSQLophelia6/6/2026 9:16:53 AM24263Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
160DWSGDAAPP3MicroSQLophelia6/6/2026 9:17:34 AM24222Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
54DWSGDAAPP2MicroSQLophelia6/6/2026 9:20:43 AM24033Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
135DWSGDAAPP3MicroSQLophelia6/6/2026 9:39:51 AM22885Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
304DWSGDAAPP1MicroSQLophelia6/6/2026 9:43:57 AM22639Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
56DWSGDAAPP1MicroSQLophelia6/6/2026 9:44:17 AM22619Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
217DWSGDAAPP3MicroSQLophelia6/6/2026 9:47:34 AM22422Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
125DWSGDAAPP3MicroSQLophelia6/6/2026 9:49:16 AM22320Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
359DWSGDAAPP2MicroSQLophelia6/6/2026 9:52:26 AM22130Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
170DWSGDAAPP2MicroSQLophelia6/6/2026 9:54:04 AM22032Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
340DWSGDAAPP2MicroSQLophelia6/6/2026 9:55:43 AM21933Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
419DWSGDAAPP2MicroSQLophelia6/6/2026 9:55:44 AM21932Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
453DWSGDAAPP2MicroSQLophelia6/6/2026 9:57:22 AM21834Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
310DWSGDAAPP3MicroSQLophelia6/6/2026 10:08:33 AM21163Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
53DWSGDAAPP1MicroSQLophelia6/6/2026 10:11:57 AM20959Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
67DWSGDAAPP3MicroSQLophelia6/6/2026 10:16:58 AM20658Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
97DWSGDAAPP3MicroSQLophelia6/6/2026 10:24:43 AM20193Read/Write(@p0 varchar(32),@p1 varchar(36),@p2 varchar(9),@p3 varchar(36),@p4 varchar(36),@p5 decimal(2,1),@p6 varchar(8000),@p7 varchar(32),@p8 bit,@p9 datetime,@p10 varchar(8000))INSERT INTO [DRIVE_FOLDER] ([_id], [Code], [ParentCode], [Name], [Description], [Size], [Extensions], [BucketName], [IsPublic], [CreationDate], [MicroAppCode]) VALUES (@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)
323DWSGDAAPP2ophelia6/6/2026 4:01:04 PM12Read/Write(@ SMALLINT,@_1 INT,@_2 SMALLINT)SELECT PSW_CONT,PSW_TVAL,PSW_VALO,PTL_CODI,PTL_VERS,DPT_CODI,DPT_CODG,PSW_TABL, PSW_CAMP,PSW_NCAM,PAR_CODE,PAR_TYPE,PAR_FORM,PAR_REQU,PAR_FATH FROM WF_PSWET WHERE PAR_TYPE='HEADER' AND EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2

Wait Stats

wait_typewaiting_tasks_countwait_time_msAvgWaitMssignal_wait_time_ms
SOS_WORK_DISPATCHER11684431292806100055794.0053647679
CXPACKET15598673613981693488.0040016530
CXCONSUMER29460001111912520274.0078619835
ASYNC_NETWORK_IO1276897916664092713.004130896
PAGEIOLATCH_SH1027787141569253691.005574422
SOS_SCHEDULER_YIELD1451099411284011040.00128097143
BACKUPBUFFER9689080870432428.005256438
PREEMPTIVE_XE_DISPATCHER68579484114299140.000
LCK_M_IS40318101197420097.003491
BPSORT16024143577859913.007309756
BACKUPIO33988615537925416.001309216
ASYNC_IO_COMPLETION5913715969862875.00131
LATCH_EX9772229244228612.004721008
LCK_M_IX22312384791310689.003310
PAGEIOLATCH_EX5355564188217363.00551320
WRITELOG3620953158477244.001800268
LCK_M_X3977152123943825.008828
PARALLEL_REDO_WORKER_WAIT_WORK1690398108029516.0021139
LCK_M_SCH_S966978334110127.001194
RESERVED_MEMORY_ALLOCATION_EXT328142770891781180.000

Guía de lectura - Wait Stats

WaitQué indicaQué revisar
CXPACKET / CXCONSUMERParalelismo. No siempre es problema; puede ser normal en consultas grandes.MAXDOP, Cost Threshold for Parallelism, planes de ejecución y consultas con alto CPU/lecturas.
PAGEIOLATCH_SH / PAGEIOLATCH_EXLectura de páginas desde disco hacia memoria.Índices faltantes, scans grandes, presión de memoria, latencia de discos.
ASYNC_NETWORK_IOSQL espera a que la aplicación cliente consuma resultados.Aplicaciones que leen lento, redes, consultas que devuelven demasiadas filas.
LCK_M_*Bloqueos entre sesiones.Transacciones largas, índices ausentes, orden de acceso, aislamiento y consultas de escritura.
WRITELOGEscritura al transaction log.Latencia del disco de logs, transacciones grandes, backups de log, crecimiento del LDF.
SOS_SCHEDULER_YIELDPresión de CPU o consultas que consumen mucho procesador.Top queries CPU, paralelismo, planes, funciones escalares, consultas no sargables.
BACKUPIO / BACKUPBUFFERActividad asociada a backups.Horario de backups, duración, destino, solapamiento con operación.
PREEMPTIVE_XE_DISPATCHER / SOS_WORK_DISPATCHEREsperas internas/Extended Events. Pueden aparecer altas por acumulado histórico.No concluir solo por total acumulado. Comparar deltas entre ejecuciones del reporte.

Uso: Wait Stats sirve para identificar el tipo de cuello de botella dominante: CPU, disco, bloqueos, red, log o paralelismo. Para monitoreo real conviene guardar histórico y comparar deltas, porque la DMV es acumulada desde el último reinicio de SQL Server.

Top Queries CPU

ExecutionsCPUTimeMsAvgCPUMsElapsedMsLogicalReadsQueryText
2765449483197441462827222617067SELECT [w].[EMP_CODI], [w].[CAS_CONT], [w].[SEG_CONT], [w].[AUD_ESTA], [w].[AUD_UFAC], [w].[AUD_USUA], [w].[ETA_CONT], [w].[FLU_CONT], [w].[SEG_ABRE], [w].[SEG_AENV], [w].[SEG_ALER], [w].[SEG_COME], [w].[SEG_CONA], [w].[SEG_DATA], [w].[SEG_DIAD], [w].[SEG_DIAE], [w].[SEG_DIAR], [w].[SEG_EANT], [w].[SEG_ERRO], [w].[SEG_ESTC], [w].[SEG_ESTE], [w].[SEG_FATI], [w].[SEG_FCUL], [w].[SEG_FENC], [w].[SEG_FIEJ], [w].[SEG_FLIM], [w].[SEG_FREC], [w].[SEG_HCUL], [w].[SEG_HLIM], [w].[SEG_HREC], [w].[SEG_IDCH], [w].[SEG_INTE], [w].[SEG_IPAD], [w].[SEG_PRIO], [w].[SEG_RECO], [w].[SEG_RESU], [w].[SEG_SUBJ], [w].[SEG_UALA], [w].[SEG_UENC], [w].[SEG_UORI] FROM [WF_SEGUI] AS [w] WHERE [w].[EMP_CODI] = @companyCode AND [w].[SEG_IPAD] = @localIp AND [w].[SEG_ESTE] = N'Q' AND [w].[SEG_FENC] < @queuingDate AND [w].[SEG_FREC] >= @creationDate
2448213002887024050153108SELECT target_data FROM sys.dm_xe_session_targets xet WITH(nolock) JOIN sys.dm_xe_sessions xes WITH(nolock) ON xes.address = xet.event_session_address WHERE xes.name = 'telemetry_xevents' AND xet.target_name = 'ring_buffer'
180071196992661252293163377511SELECT TOP(@__p_2) [r].[Id], [r].[CaseCode], [r].[CompanyCode], [r].[CompletedAt], [r].[CreatedAt], [r].[DependencyCode], [r].[ErrorMessage], [r].[FileNumber], [r].[JobId], [r].[LastErrorAt], [r].[MaxRetries], [r].[NextRetryAt], [r].[ProcessCode], [r].[ProcessName], [r].[ProcessingServer], [r].[Reason], [r].[ReassignBPM], [r].[ReassignDMS], [r].[RetryCount], [r].[StartedAt], [r].[Status], [r].[StatusId], [r].[TrackingCode], [r].[UserExecutor], [r].[UserToReassign] FROM [ReassignmentTask] AS [r] WHERE [r].[ProcessingServer] = @__serverIp_0 AND ([r].[Status] = N'Pending' OR ([r].[Status] = N'Failed' AND [r].[RetryCount] < [r].[MaxRetries] AND [r].[NextRetryAt] IS NOT NULL AND [r].[NextRetryAt] <= @__now_1)) ORDER BY [r].[CreatedAt]
2460100279940712677381139631SELECT CONVERT(uniqueidentifier, HASHBYTES('MD2', rankTable.[sql_handle])) as [qhash], rankTable.[sql_handle] as [qhandle], st.[text], rankTable.[plan_count], rankTable.[execution_count], DATEADD(second, DATEDIFF(second, GETDATE(), GETUTCDATE()), rankTable.[last_execution_time]) AS [last_execution_time], rankTable.[avg_worker_time], rankTable.[last_worker_time], rankTable.[avg_physical_reads], rankTable.[avg_logical_reads], rankTable.[avg_logical_writes], rankTable.[avg_elapsed_time], rankTable.[last_elapsed_time], s.[session_id], s.[login_name], s.[host_name], s.[host_process_id], rankTable.[dbid], rankTable.[dbname] FROM ( SELECT innerTable.*, [plan].[dbid], [plan].[dbname], ROW_NUMBER() OVER (PARTITION BY [plan].[dbid] ORDER BY [avg_worker_time] DESC) AS [_rank_db_worker_time], ROW_NUMBER() OVER (PARTITION BY [plan].[dbid] ORDER BY [avg_logical_reads] DESC) AS [_rank_db_logical_reads], ROW_NUMBER() OVER (PARTITION BY [plan].[dbid] ORDER BY [avg_logical_writes] DESC) AS [_rank_db_logical_writes], ROW_NUMBER() OVER (ORDER BY [avg_physical_reads] DESC) AS [_rank_physical_reads], ROW_NUMBER() OVER (ORDER BY [avg_elapsed_time] DESC) AS [_rank_elapsed_time] FROM ( SELECT qs.[sql_handle], SUM(qs_plan.[plan_count]) as [plan_count], SUM(qs.[execution_count]) as [execution_count], MAX(qs.[last_execution_time]) as [last_execution_time], SUM(qs.[total_worker_time]) / SUM(qs.execution_count) / 1000 as [avg_worker_time], AVG(qs.[last_worker_time]) / 1000 as [last_worker_time], SUM(qs.[total_physical_reads]) / SUM(qs.execution_count) as [avg_physical_reads], SUM(qs.[total_logical_reads]) / SUM(qs.execution_count) as [avg_logical_reads], SUM(qs.[total_logical_writes]) / SUM(qs.execution_count) as [avg_logical_writes], SUM(qs.[total_elapsed_time]) / SUM(qs.execution_count) / 1000 as [avg_elapsed_time], AVG(qs.[last_elapsed_time]) / 1000 as [last_elapsed_time], MAX ([plan_handle]) as [plan_handle] FROM sys.dm_exec_query_stats AS qs LEFT JOIN ( SELECT COUNT(DISTINCT [plan_handle]) as [plan_count], [query_hash], [query_plan_hash] FROM sys.dm_exec_query_stats GROUP BY [query_hash], [query_plan_hash] ) as [qs_plan] ON qs_plan.[query_hash] = qs.[query_hash] AND qs_plan.[query_plan_hash] = qs.[query_plan_hash] WHERE [total_worker_time] > 0 AND [last_execution_time] > DATEADD(SECOND,-5 * 300,GETDATE()) GROUP BY qs.[sql_handle] ) AS [innerTable] OUTER APPLY ( SELECT value AS [dbid], DB_NAME(CONVERT(int, value)) as [dbname] FROM sys.dm_exec_plan_attributes(innerTable.plan_handle) WHERE [attribute] = 'dbid' ) AS [plan] ) AS [rankTable] CROSS APPLY sys.dm_exec_sql_text(rankTable.[sql_handle]) st LEFT JOIN sys.dm_exec_requests r ON rankTable.[sql_handle] = r.[sql_handle] LEFT JOIN sys.dm_exec_sessions s ON s.[session_id] = r.[session_id] WHERE rankTable.[dbname] NOT IN ('') AND ( [_rank_db_worker_time] <= 10 OR [_rank_db_logical_reads] <= 10 OR [_rank_db_logical_writes] <= 10 OR [_rank_physical_reads] <= 10 OR [_rank_elapsed_time] <= 10 )
5807298661258104558726040729WITH FilteredTables AS ( SELECT object_id FROM sys.tables WHERE object_id > 0 ) INSERT INTO #IndexStats SELECT stats.database_id, stats.object_id, stats.index_id, stats.partition_number, AVG(stats.avg_fragmentation_in_percent) AS avg_fragmentation_in_percent, SUM(stats.page_count) * 8 AS IndexSizeKb FROM FilteredTables AS t INNER JOIN sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'LIMITED') AS stats ON stats.object_id = t.object_id GROUP BY stats.database_id, stats.object_id, stats.index_id, stats.partition_number HAVING SUM(stats.page_count) * 8 >= 1024
13156849243396032106391406SELECT DISTINCT RF.IdRadicado, RF.Radicado, RF.Fecha, CN.[Name] AS 'Canal', RF.[Tipo de persona], TD.Name AS 'Tipo de identificación', CL.NumberIdentification AS 'Número de identificación', RF.Entidad, RF.Destinatario AS 'Nombres y apellidos remitente', CL.Id AS 'Id Cliente', CT.Id AS 'Id Contacto', RF.País, RF.Departamento, RF.Ciudad, RF.Dirección, RF.[Correo electrónico], RF.Asunto, RF.Folios, RFD.Attachments AS 'Número de anexos', RF.[Descripción de anexos], RF.Compañía, RF.Dependencia, CONCAT(DP.NameSolicitud, ' / ', LTRIM(RTRIM(DP.NameDetalle)), IIF(ISNULL(DP.NameEspecificacion, '0') = '0', NULL, ' / '), DP.NameEspecificacion) AS 'Trámite', RFD.UserName AS 'Usuario Radicador', RF.FuncionarioResponsable 'Responsable', 'https://tinyurl.com/5e6yz5u9' AS QR FROM GETDATABYRADICATE_VW RF INNER JOIN REQUESTFILE_VW RFD ON RFD.Id = RF.IdRadicado INNER JOIN CANAL_VW CN ON CN.Id = RFD.ChannelId INNER JOIN CLIENTS_VW CL ON CL.Id = RFD.ClientId INNER JOIN CONTACTS_VW CT ON CT.Id = RFD.ContactId INNER JOIN TypeDetail TD ON TD.Id = CL.DocumentTypeId INNER JOIN DMSProcedureNew_VW DP ON RFD.ProcedureId = DP.IdProcedure WHERE RF.Radicado = @Radicado
190274517452347264920625268SELECT COUNT(*) FROM [ReassignmentTask] AS [r] WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0
238663652421538071712287700SELECT COUNT(*) FROM [WF_PROCESS_QUEUE] AS [w] WHERE [w].[STATUS] = N'PROCESSING' AND ([w].[LAST_HEARTBEAT] IS NULL OR DATEDIFF(minute, [w].[LAST_HEARTBEAT], @__now_1) <= @___heartbeatTimeoutMinutes_2)
240753535601437106612539609SELECT TOP(@__p_0) [w].[QUEUE_ID] FROM [WF_PROCESS_QUEUE] AS [w] WHERE [w].[STATUS] = N'PENDING' AND [w].[RETRY_COUNT] < [w].[MAX_RETRIES] ORDER BY [w].[PRIORITY] DESC, [w].[CREATED_DATE]
129958729958714751643936064INSERT INTO dbo.SmartSupervisionMom2 SELECT RequestFiles.Id AS RequestFilesId ,RequestFiles.FileNumber AS [RADICADO FIDUGESTOR] -- Número de radicado ,CAST(CAST(RequestFiles.FiledDate AS DATE) AS VARCHAR) AS [FECHA DE RADICACION] -- Fecha de radicación ,FORMAT(RequestFiles.FiledDate, 'h:mm tt') AS [HORA_RADICACION] -- Hora de radicación en formato AM/PM ,CONCAT(DATENAME(MONTH, RequestFiles.FiledDate),' - ',YEAR(RequestFiles.FiledDate)) AS [MES/AÑO] -- Mes y año en español --Tipo de PQR extraído del motivo de reclasificación o tomado por defecto ,COALESCE( SUBSTRING( RequestFileHistoriesReclas.Reason, CHARINDEX('Se reclasificó el tipo de PQRSD así: de', RequestFileHistoriesReclas.Reason) + LEN('Se reclasificó el tipo de PQRSD así: de'), CHARINDEX(' a ', RequestFileHistoriesReclas.Reason) - CHARINDEX('Se reclasificó el tipo de PQRSD así: de', RequestFileHistoriesReclas.Reason) - LEN('Se reclasificó el tipo de PQRSD así: de') ), PqrsType.Name ) AS [TIPO_DE_PQR] --Clasificaciones, canal, motivos, tipo y detalle de solicitud ,producto.Name AS [CLASIFICACION SFC PRODUCTO] ,canalpqr.Name AS [CANAL] ,Motivo.Name AS [MACROMOTIVO] ,NameType.Name AS [TIPO DE SOLICITUD] ,ProcedureType.Name AS [DETALLE DE LA SOLICITUD] ,SpecificationType.Name AS [ESPECIFICACIÓN DE LA SOLICITUD] -- Información relacionada con la transmisión a la SFC ,CONCAT(512,RequestFiles.FileNumber) AS [RADICADO SFC FIDUGESTOR] ,CAST(CAST(RequestFiles.FiledDate AS DATE) AS VARCHAR) AS [FECHA DEL ENVIO A SFC] ,'Recibida' AS [ESTADO SFC MOMENTO 2] ,CASE WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN 'Enviada' ELSE 'No Enviada' END AS [ESTADO DE LA TRASMISION] ,CASE WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN CAST(CAST(smartprocesslog.RegistrationDate AS DATE) AS VARCHAR) END AS [FECHA DE TRASMISION] ,CASE WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN 'N/A' ELSE CAST(smartprocesslog.Observations AS NVARCHAR(MAX)) END AS [TIPO DE ERROR] -- Información de funcionarios y dependencias que gestionan y responden ,CONCAT(Users1.Name,' ', Users1.Surnames ) [FUNCIONARIO QUE GESTIONA] ,Dependencies1.Name [DEPENDENCIA QUE GESTIONA] ,CAST(CAST(RequestFileHistories1.CreationDate AS DATE) AS VARCHAR) AS [FECHA DE LA GESTION] ,CASE WHEN CONCAT(UsersFinalizador.Name,' ', UsersFinalizador.Surnames ) <>'' THEN CONCAT(UsersFinalizador.Name,' ', UsersFinalizador.Surnames ) ELSE CONCAT(Users.Name,' ', Users.Surnames ) END AS [FUNCIONARIO QUE RESPONDE] ,Dependencies.Name AS [DEPENDENCIA QUE RESPONDE] -- Información sobre respuestas parciales o definitivas ,CASE WHEN MAX(RequestFilesRespuestaParcial.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL AND MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER(PARTITION BY RequestFiles.FileNumber) IS NULL THEN 'Respuesta Parcial' WHEN MAX(RequestFilesRespuestaDefinitiva.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL THEN 'Respuesta Definitiva' END AS [TIPO DE RESPUESTA] ,MAX(ISNULL(RequestFilesRespuestaDefinitiva.FileNumber,RequestFilesRespuestaParcial.FileNumber)) OVER(PARTITION BY RequestFiles.FileNumber) AS [RADICADO DE RESPUESTA (MOMENTO 3)] ,MAX(CONVERT(VARCHAR,CONVERT(DATE,ISNULL(RequestFilesRespuestaDefinitiva.FiledDate, RequestFilesRespuestaParcial.FiledDate)))) OVER(PARTITION BY RequestFiles.FileNumber) AS [FECHA DE RESPUESTA] ,MAX(RIGHT(CONVERT(DATETIME, ISNULL(RequestFilesRespuestaDefinitiva.FiledDate,RequestFilesRespuestaParcial.FiledDate), 108),8)) OVER(PARTITION BY RequestFiles.FileNumber) AS [HORA DE RESPUESTA] -- Estado de envío al momento 3 ,CASE WHEN MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Enviada' ELSE 'No Enviada' END AS [SE ENVIO MOMENTO 3] ,CASE WHEN MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'N/A' WHEN smartprocesslogMom3.RegistrationDate IS NULL THEN 'No ha sido Enviada' ELSE CAST(smartprocesslogMom3.Observations AS VARCHAR(8000)) END AS [TIPO DE ERROR MOMENTO 3] ,CAST(CAST(smartprocesslogMom3.RegistrationDate AS DATE) AS VARCHAR) AS [FECHA DE TRASMISION MOMENTO 3] -- Estado final de la solicitud ,CASE WHEN MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL AND MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Cerrado' WHEN smartprocesslog.Id IS NOT NULL AND MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Recibida' ELSE 'Abierto' END AS [ESTADO ACTUAL MOMENTO 3] -- Información adicional de reclasificación y seguimiento ,CASE WHEN RequestFileHistoriesReclas.Id IS NOT NULL THEN 'Si' ELSE 'No' END AS [EL RADICADO TUVO RECLASIFICACION] ,RequestFileHistoriesReclas.Reason AS [TIPO DE PQRS ANTES DE RECLASIFICAR] ,PqrsType.Name AS [TIPO DE PQRS DESPUES DE RECLASIFICAR] ,Admision.Name AS [ADMISION] ,SmartAddicionalRequestFiles.ComingFromProcedure AS [PROCEDENTE] ,Favorabilidad.Name AS [FAVORABILIDAD] ,SmartAddicionalRequestFiles.FavorConsumerProcedure AS [A FAVOR DE] ,CASE WHEN SmartAddicionalRequestFiles.RefusedEntityProcedure='1' THEN 'Si' ELSE 'No' END AS [INADMITIDA O RECHAZADA POR LA ENTIDAD] ,SmartAddicionalRequestFiles.SuperFRemittedProcedure AS [TRASLADO A LA SUPERINTENDENCIA] ,AFavorDe.Name AS [ACEPTACION] ,Rectificacion.Name AS [RECTIFICACION] ,Desistimiento.Name AS [DESISTIMIENTO] ,clients.NumberIdentification AS [REMITENTE] ,CASE WHEN Clients.AffiliatedFomag='1' THEN 'Si' ELSE 'No' END AS [AFILIADO AL FOMAG] ,AffiliateType.Code AS [TIPO DE AFILIADO] ,RequestFiles.Subject AS [ASUNTO] ,CASE WHEN Clients.OriginRegistry='SmartSupervision' AND RequestFiles.ReportedSmart='1' THEN 'Si' WHEN Clients.OriginRegistry NOT IN ('SmartSupervision') THEN 'No' END AS [ACTUALIZO MOMENTO 4] ,CASE WHEN RequestFiles.ReportedSmart='1' THEN CONVERT(VARCHAR,CONVERT(DATE,Clients.ModificationDate)) END AS [FECHA ACTUALIZACION] -- Campos auxiliares para filtrado por año y mes ,CAST(YEAR(RequestFiles.FiledDate) AS int) AS AñoFil ,MONTH(RequestFiles.FiledDate) AS MesFil ,ISNULL(Dependencies.code,0) AS DependeciaFil -- Add campos Circular 19 ,Circular19.[TIPO DE FRAUDE] AS [TIPO DE FRAUDE] ,Circular19.[MODALIDAD DE FRAUDE] AS [MODALIDAD DE FRAUDE] ,Circular19.[MONTO RECLAMADO] AS [MONTO RECLAMADO] ,Circular19.[MONTO RECONOCIDO] AS [MONTO RECONOCIDO] -- Tabla principal de radicados FROM DMS.DBO.RequestFiles -- Unión para identificar el último usuario que gestionó el radicado LEFT JOIN ( SELECT RequestFileHistories.UserName, RequestFileHistories.RequestFileId, RequestFileHistories.Status, RequestFileHistories.processcode, ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS rn FROM DMS.DBO.RequestFileHistories WHERE Status NOT IN (--Se agregan los siguientes estados por caso SAC 960781 '4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425' ,'8d6acd5a-d128-45b0-b1a5-f9c0fef90708','EF7B7E43-9151-422A-9A2C-6E3B6C53BC85') AND ProcessCode !='615' ) RequestFileHistories ON RequestFileHistories.RequestFileId = RequestFiles.Id AND RequestFileHistories.rn = 1 -- Unión con la información del cliente LEFT JOIN DMS.DBO.clients ON clients.Id = RequestFiles.clientid -- Unión para obtener el último registro del Momento 2 con subproceso REPORTE_QUEJA LEFT JOIN ( SELECT smartprocesslog.Id, smartprocesslog.Status, smartprocesslog.FileNumber, smartprocesslog.RegistrationDate, smartprocesslog.Observations, smartprocesslog.ClientDocumentNumber, ROW_NUMBER() OVER (PARTITION BY FileNumber, ClientDocumentNumber ORDER BY RegistrationDate DESC) AS rn FROM DMS.DBO.smartprocesslog WHERE Process = 'MOMENTO_2' AND SubProcess = 'REPORTE_QUEJA' --AND smartprocesslog.FileNumber = '20241011326782' ) smartprocesslog ON smartprocesslog.FileNumber = RequestFiles.FileNumber AND smartprocesslog.ClientDocumentNumber = Clients.NumberIdentification AND smartprocesslog.rn = 1 -- Unión para obtener el último registro del Momento 3 con subproceso REPORTE_QUEJA LEFT JOIN ( SELECT smartprocesslog.Id, smartprocesslog.FileNumber, smartprocesslog.ClientDocumentNumber, smartprocesslog.RegistrationDate, smartprocesslog.Status, smartprocesslog.Observations, ROW_NUMBER() OVER ( PARTITION BY FileNumber ORDER BY -- Prioriza los EXITOSO más recientes, luego cualquier otro estado CASE WHEN Status = 'EXITOSO' THEN 1 ELSE 2 END, RegistrationDate DESC ) AS rn FROM DMS.DBO.smartprocesslog WHERE Process = 'MOMENTO_3' AND SubProcess = 'REPORTE_QUEJA' AND Status IN ('EXITOSO', 'FINALIZADO', 'FALLIDO') ) smartprocesslogMom3 ON smartprocesslogMom3.FileNumber = RequestFiles.FileNumber --AND smartprocesslogMom3.Id = ( -- SELECT TOP 1 AA.Id -- FROM DMS.DBO.smartprocesslog AA -- WHERE AA.FileNumber = smartprocesslogMom3.FileNumber -- AND AA.Process = 'MOMENTO_3' -- AND AA.SubProcess = 'REPORTE_QUEJA' -- ORDER BY AA.RegistrationDate DESC --) AND smartprocesslogMom3.rn = 1 -- Historial más antiguo con dependencia asignada LEFT JOIN ( SELECT RequestFileHistories.RequestFileId, RequestFileHistories.CreationDate, RequestFileHistories.UserName, RequestFileHistories.ProcessCode, ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate ASC) AS rn FROM DMS.DBO.RequestFileHistories WHERE DependencyId IS NOT NULL AND ProcessCode !='615' --AND RequestFileId ='FCF1BB64-614E-4D69-9E4A-D8BED126A1DC' ) RequestFileHistories1 ON RequestFileHistories1.RequestFileId = RequestFiles.Id AND RequestFileHistories1.rn = 1 -- Último historial con estado 'Finalizado' LEFT JOIN ( SELECT AAA.RequestFileId, AAA.CreationDate, AAA.UserName, ROW_NUMBER() OVER (PARTITION BY AAA.RequestFileId ORDER BY AAA.CreationDate DESC) AS rn FROM DMS.DBO.RequestFileHistories AAA INNER JOIN DMS.DBO.TYPESTATEREQUEST_VW BBB ON CONVERT(VARCHAR(40), AAA.Status) = CONVERT(VARCHAR(40), BBB.Id) WHERE BBB.Name = 'Finalizado' ) RequestFileHistoriesUsuarioFinalizador ON RequestFileHistoriesUsuarioFinalizador.RequestFileId = RequestFiles.Id AND RequestFileHistoriesUsuarioFinalizador.rn = 1 -- Usuario que finalizó el radicado LEFT JOIN DMS.DBO.Users UsersFinalizador ON UsersFinalizador.UserName = RequestFileHistoriesUsuarioFinalizador.UserName -- Historial de reclasificación LEFT JOIN (SELECT RequestFileHistories.Id, RequestFileHistories.RequestFileId, RequestFileHistories.Reason, ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS rn FROM DMS.DBO.RequestFileHistories WHERE RequestFileHistories.Status = '31b6159d-de9d-4cba-9508-4d9d4ee2faf7' ) AS RequestFileHistoriesReclas ON RequestFileHistoriesReclas.RequestFileId = RequestFiles.Id AND RequestFileHistoriesReclas.rn = 1 -- Usuario que respondió LEFT JOIN DMS.DBO.Users Users ON Users.UserName = RequestFileHistories.UserName -- Usuario asociado al historial más antiguo con dependencia LEFT JOIN DMS.DBO.Users Users1 ON Users1.UserName = RequestFileHistories1.UserName -- Información adicional del radicado (producto, canal, motivo, etc.) LEFT JOIN DMS.DBO.SmartAddicionalRequestFiles ON SmartAddicionalRequestFiles.RequestFilesId = RequestFiles.Id LEFT JOIN DMS.DBO.TypeDetail producto ON producto.Id = SmartAddicionalRequestFiles.ProductCode LEFT JOIN DMS.DBO.TypeDetail canalpqr ON canalpqr.Id = SmartAddicionalRequestFiles.Channel LEFT JOIN DMS.DBO.TypeDetail Motivo ON Motivo.Id = SmartAddicionalRequestFiles.MacroReasonCode LEFT JOIN DMS.DBO.TypeDetail Admision ON Admision.Id = SmartAddicionalRequestFiles.Admission LEFT JOIN DMS.DBO.TypeDetail Favorabilidad ON Favorabilidad.Id = SmartAddicionalRequestFiles.Favorability LEFT JOIN DMS.DBO.TypeDetail AFavorDe ON AFavorDe.Id = SmartAddicionalRequestFiles.Acceptance LEFT JOIN DMS.DBO.TypeDetail Rectificacion ON Rectificacion.Id = SmartAddicionalRequestFiles.Rectification LEFT JOIN DMS.DBO.TypeDetail Desistimiento ON Desistimiento.Id = SmartAddicionalRequestFiles.ComplaintWithdrawal -- Tipo de afiliado del cliente LEFT JOIN DMS.DBO.TYPEAFFILIATE_VW AffiliateType ON Clients.AffiliateTypeId = CONVERT(VARCHAR(40), AffiliateType.Id) -- Procedimiento asociado al radicado LEFT JOIN DMS.DBO.DMS_Procedures ON DMS_Procedures.Id = RequestFiles.ProcedureId LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id = DMS_Procedures.NameTypeId LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id = DMS_Procedures.ProcedureTypeId LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id = DMS_Procedures.SpecificationTypeId -- Tipo PQRSD del radicado LEFT JOIN DMS.dbo.PQRSDType PqrsType ON PqrsType.Id = RequestFiles.PqrsTypeId -- Verifica si tiene respuesta parcial LEFT JOIN ( SELECT CC.Id, AA.FiledDate, AA.FileNumber, AA.ChannelId, ROW_NUMBER() OVER (PARTITION BY BB.ParentId ORDER BY AA.FiledDate DESC) AS RN FROM DMS.dbo.RequestFiles AA INNER JOIN DMS.dbo.RelatedRequestFiles BB ON BB.RequestFileId = AA.Id INNER JOIN DMS.dbo.RequestFiles CC ON BB.ParentId = CC.Id WHERE AA.RequestTypeId = '956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND AA.ResposnseText = 2 ) RequestFilesRespuestaParcial ON RequestFiles.Id = RequestFilesRespuestaParcial.Id AND RequestFilesRespuestaParcial.RN = '1' -- Verifica si tiene respuesta definitiva LEFT JOIN ( SELECT CC.Id, AA.FiledDate, AA.FileNumber, AA.ChannelId, ROW_NUMBER() OVER (PARTITION BY BB.ParentId ORDER BY AA.FiledDate DESC) AS RN FROM DMS.dbo.RequestFiles AA INNER JOIN DMS.dbo.RelatedRequestFiles BB ON BB.RequestFileId = AA.Id INNER JOIN DMS.dbo.RequestFiles CC ON BB.ParentId = CC.Id WHERE AA.RequestTypeId = '956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND AA.ResposnseText = 1 ) RequestFilesRespuestaDefinitiva ON RequestFiles.Id = RequestFilesRespuestaDefinitiva.Id AND RequestFilesRespuestaDefinitiva.RN = '1' --Dependencia del usuario finalizador o de quien respondió LEFT JOIN ( SELECT * FROM ( SELECT UsersCompany.UserId, Dependencies.Id AS DependencyId, Dependencies.Name, Dependencies.Code, Dependencies.TopSection, UsersCompany.State, ROW_NUMBER() OVER (PARTITION BY UsersCompany.UserId ORDER BY TypeDetail.Code ASC) AS rn FROM DMS.DBO.UsersCompany INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id = UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State = TypeDetail.Id ) RankedDependencies WHERE rn = 1 ) Dependencies ON ISNULL(UsersFinalizador.id, Users.id) = Dependencies.UserId --Consulta adiciona los campos de la actualización circular 19 LEFT JOIN ( SELECT RequestFilesId, FraudTypeName.Name AS [Tipo de Fraude], FraudModalityName.Name AS [Modalidad de Fraude], FORMAT(ISNULL(ClaimedAmount, 0), 'N0', 'es-CO') AS [Monto Reclamado], FORMAT(ISNULL(RecognizedAmount, 0), 'N0', 'es-CO') AS [Monto Reconocido] FROM DMS.dbo.SmartAddicionalRequestFiles LEFT JOIN DMS.dbo.TypeDetail AS FraudTypeName ON SmartAddicionalRequestFiles.FraudType = FraudTypeName.Id AND FraudTypeName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB754' LEFT JOIN DMS.dbo.TypeDetail AS FraudModalityName ON SmartAddicionalRequestFiles.FraudModality = FraudModalityName.Id AND FraudModalityName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB758') AS Circular19 ON RequestFiles.Id = Circular19.RequestFilesId -- Dependencia asociada al primer usuario con historial LEFT JOIN ( SELECT * FROM ( SELECT UsersCompany.UserId, Dependencies.Id AS DependencyId, Dependencies.Name, Dependencies.Code, Dependencies.TopSection, UsersCompany.State, ROW_NUMBER() OVER (PARTITION BY UsersCompany.UserId ORDER BY TypeDetail.Code ASC) AS rn FROM DMS.DBO.UsersCompany INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id = UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State = TypeDetail.Id ) RankedDependencies WHERE rn = 1 ) Dependencies1 ON Users1.Id = Dependencies1.UserId -- Filtros principales WHERE RequestFiles.OriginId = '2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' -- Origen de radicados AND RequestFiles.StatusId <> 'E6D67E4A-F545-4D62-B882-5A38A0FC35E2' -- Excluir anulados AND RequestFileHistories.Status NOT IN ('4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425') AND RequestFiles.PqrsTypeId NOT IN ( 'B48BF430-F3F7-4431-A375-3B9DBC1441E4', -- QuejEx '496B613B-8905-4496-A201-5AF1235DA91C' -- QejSFC ) AND RequestFileHistories.ProcessCode !='615'
123212977572445455634051SELECT RTRIM(object_name) AS object_name, RTRIM(counter_name) AS counter_name, RTRIM(instance_name) AS instance_name, RTRIM(cntr_value) AS cntr_value FROM sys.dm_os_performance_counters UNION SELECT @SQLNAME AS object_name, 'Version' AS counter_name, @@version AS instance_name, CAST(0 as bigint) AS cntr_value UNION SELECT @SQLNAME AS object_name, 'Uptime' AS counter_name, '' AS instance_name, CAST(DATEDIFF(second, sqlserver_start_time, GETDATE()) as bigint) AS cntr_value FROM sys.dm_os_sys_info UNION SELECT @SQLNAME + ':Databases' AS object_name, 'State' AS counter_name, name AS instance_name, state AS cntr_value FROM sys.databases UNION SELECT a.object_name, 'BufferCacheHitRatio' AS counter_name, '' AS instance_name, cast(a.cntr_value * ISNULL((100.0 / NULLIF(b.cntr_value,0)),0) AS dec(3, 0)) AS cntr_value FROM sys.dm_os_performance_counters a JOIN ( SELECT cntr_value, OBJECT_NAME FROM sys.dm_os_performance_counters WHERE counter_name = 'Buffer cache hit ratio base' AND OBJECT_NAME = @SQLNAME + ':Buffer Manager' ) b ON a.OBJECT_NAME = b.OBJECT_NAME WHERE a.counter_name = 'Buffer cache hit ratio' AND a.OBJECT_NAME = @SQLNAME + ':Buffer Manager' UNION SELECT a.object_name, 'WorktablesFromCacheRatio' AS counter_name, '' AS instance_name, cast(a.cntr_value * ISNULL((100.0 / NULLIF(b.cntr_value,0)),0) AS dec(3, 0)) AS cntr_value FROM sys.dm_os_performance_counters a JOIN ( SELECT cntr_value, OBJECT_NAME FROM sys.dm_os_performance_counters WHERE counter_name = 'Worktables From Cache Base' AND OBJECT_NAME = @SQLNAME + ':Access Methods' ) b ON a.OBJECT_NAME = b.OBJECT_NAME WHERE a.counter_name = 'Worktables From Cache Ratio' AND a.OBJECT_NAME = @SQLNAME + ':Access Methods' UNION SELECT a.object_name, 'CacheHitRatio' AS counter_name, '_Total' AS instance_name, cast(a.cntr_value * ISNULL((100.0 / NULLIF(b.cntr_value,0)),0) AS dec(3, 0)) AS cntr_value FROM sys.dm_os_performance_counters a JOIN ( SELECT cntr_value, OBJECT_NAME FROM sys.dm_os_performance_counters WHERE counter_name = 'Cache Hit Ratio base' AND OBJECT_NAME = @SQLNAME + ':Plan Cache' AND instance_name = '_Total' ) b ON a.OBJECT_NAME = b.OBJECT_NAME WHERE a.counter_name = 'Cache Hit Ratio' AND a.OBJECT_NAME = @SQLNAME + ':Plan Cache' AND instance_name = '_Total'
24552776041132863393284039SELECT data_space_id, [file_id], [type], name, physical_name, [state], CONVERT(bigint, size) * 8 as size_kbytes, CASE [type] WHEN 2 THEN NULL ELSE CONVERT(bigint, FILEPROPERTY(name,'SpaceUsed')) * 8 END as space_used_kbytes, CASE max_size WHEN -1 THEN NULL ELSE CONVERT(bigint, max_size) * 8 END as max_size_kbytes, CASE is_percent_growth WHEN 1 THEN growth ELSE growth * 8 END as growth, is_percent_growth, ((SELECT SUM(CONVERT(bigint, size)) FROM sys.database_files WHERE [type] % 2 = 0) - (SELECT SUM(CONVERT(bigint,total_pages)) FROM sys.partitions AS p INNER JOIN sys.allocation_units AS a ON p.[partition_id] = a.container_id))*8 AS ShrinkSpace_kbytes FROM sys.database_files
1102661582419564345030182SELECT DISTINCT RF.Radicado, RF.Fecha, RF.[Tipo de persona], RF.Entidad, RF.Destinatario, RF.País, RF.Departamento, RF.Ciudad, RF.Dirección, RF.[Correo electrónico], RF.Asunto, RF.[Cuerpo del mensaje], RF.Folios, RF.[Descripción de anexos], RF.[Canal de envío], RF.Elaboró, RF.Revisó, RF.Aprobó, RF.Compañía, RF.Dependencia, RF.Funcionario, RF.Cargo, RF.TFirma, RF.[Firma Firmante], RF.[Cargo destinatario], ISNULL (RF.CollaborativeWorkName, '1') AS 'CollaborativeWorkName', RF.CollaborativeWorkBody FROM GETDATABYRADICATE_VW RF WHERE RF.Radicado = @Radicado
162475611547210529662048427select RequestFiles . FileNumber , convert ( VARCHAR , RequestFiles . FiledDate ) Z from RequestFiles left join RequestFileHistories on RequestFiles . Id = RequestFileHistories . RequestFileId and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from dms . dbo . RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @0 ) ) left join TypeDetail on TypeDetail . Id = RequestFileHistories . Status where RequestFileHistories . UserName = @1 and TypeDetail . Name < > @2
12421532421532264458199952SELECT * FROM dbo.V_RPTG_Radicados WHERE Radicado <> '0'
4237393593481940769271784SELECT DISTINCT RequestFiles.Id RequestFileId ,RequestFileIdParent ,CASE WHEN Status='914f4fcc-627c-49b0-8c67-75a21f826d31' THEN '1' --Finalizado --WHEN Status='7AD94AE5-6D29-4EC0-B846-2664C88A7D45' THEN '2' --Getión y Tramite --ELSE NULL END ResponseText ELSE '2' END ResponseText --18/10/2024 Se realiza ajuste de acuerdo a los diferentes posibles status que puede tener un radicado, se valida con Julio INTO #RADICADOSTEMP_ FROM RequestFiles INNER JOIN ( SELECT RequestFileId RequestFileIdParent --,REPLACE(RIGHT(RequestFileHistories.Reason, CHARINDEX(' ', REVERSE(RequestFileHistories.Reason)) - 1),'radicado','') AS reason ,CASE WHEN CHARINDEX(' ', RequestFileHistories.Reason) > 0 THEN REPLACE( REVERSE( SUBSTRING( REVERSE(RequestFileHistories.Reason), 1, CHARINDEX(' ', REVERSE(RequestFileHistories.Reason)) - 1 ) ), 'radicado', '' ) ELSE REPLACE(RequestFileHistories.Reason, 'radicado', '') END AS reason ,Status FROM RequestFileHistories INNER JOIN RequestFiles ON RequestFiles.ID=RequestFileHistories.RequestFileId AND OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' --AND CONVERT(DATE,RequestFileHistories.CreationDate) =CONVERT(DATE,GETDATE()) WHERE RequestFileHistories.Reason LIKE '%Se envía respuesta%' OR RequestFileHistories.Reason LIKE '%Se envió respuesta%' --and RequestFileId='D1D39553-523A-4B4F-87F0-BD80A20B6A6A' --AND --where --RequestFiles.FileNumber='20231012303362' --)RADICADOS ON RADICADOS.Reason=RequestFiles.FileNumber --WHERE RequestFileId='B90E3FB9-304F-41C4-B124-251A6BC8B62F' )RADICADOS ON RADICADOS.reason=RequestFiles.FileNumber
5326259224352022563310646094SELECT COUNT(*) FROM GN_DIASN WHERE CCA_CONT= @ AND DIA_NOTR > @_1 AND DIA_NOTR <= @_2
2460208059842735488201WITH Sessions(IsActive, IsUser) AS ( SELECT CASE WHEN COALESCE (w.wait_type, r.Command, r.wait_type, r.last_wait_type) IS NOT NULL THEN 1 ELSE 0 END AS IsActive, s.is_user_process AS IsUser FROM sys.dm_exec_sessions s LEFT OUTER JOIN sys.dm_exec_requests r ON s.session_id = r.session_id LEFT OUTER JOIN sys.dm_os_waiting_tasks w ON s.session_id = w.session_id ) SELECT TOP 1 SERVERPROPERTY('ResourceVersion') as ProductVersion, SERVERPROPERTY('ProductLevel') as ProductLevel, SERVERPROPERTY('Edition') as Edition, SERVERPROPERTY('IsClustered') as IsClustered, (SELECT Count(*) FROM Sessions WHERE IsUser = 0) AS SystemSessions, (SELECT Count(*) FROM Sessions WHERE IsUser = 1) AS UserSessions, (SELECT Count(*) FROM Sessions WHERE IsActive = 1) AS ActiveSessions, (SELECT Count(*) FROM Sessions WHERE IsActive = 0) AS InactiveSessions, (SELECT SUM(CONVERT(BIGINT,usecounts)) FROM sys.dm_exec_cached_plans) AS CacheUseCount, GETUTCDATE() AS TimeStamp FROM Sessions
3131518066152174434331SELECT ag.name AS group_name, drs.database_state as database_state, drs.is_suspended as is_suspended, drs.synchronization_health as synchronization_health, arcs.replica_server_name AS replica_name, db_name(drs.database_id) AS dbname, drs.is_local FROM sys.dm_hadr_database_replica_states drs JOIN sys.dm_hadr_availability_replica_cluster_states arcs ON arcs.replica_id = drs.replica_id JOIN sys.availability_groups ag ON ag.group_id = arcs.group_id JOIN sys.dm_hadr_availability_replica_states ars ON ars.replica_id = arcs.replica_id WHERE drs.is_local = 1
24601776487221530249054SELECT * FROM (SELECT c.session_id, c.client_net_address, s.login_name, DATEADD(second, DATEDIFF(second, GETDATE(), GETUTCDATE()), s.login_time) AS login_time, s.program_name, s.cpu_time, (CONVERT(bigint,c.num_reads) + c.num_writes) * c.net_packet_size AS tranferred_bytes, CASE WHEN s.last_request_start_time > s.last_request_end_time THEN DATEDIFF(SECOND, s.last_request_start_time, GETDATE()) WHEN s.last_request_end_time > '1900-01-01T00:00:00' THEN DATEDIFF(SECOND, s.last_request_end_time, GETDATE()) ELSE 0 END AS idle_time_in_secs, CASE WHEN DATEDIFF(YEAR, s.login_time, GETDATE()) > 67 THEN 2147483647 ELSE DATEDIFF(SECOND, s.login_time, GETDATE()) END AS connection_duration_in_secs, s.database_id, ROW_NUMBER() OVER (PARTITION BY s.database_id ORDER BY cpu_time DESC) as row_rank FROM sys.dm_exec_connections c INNER JOIN sys.dm_exec_sessions s ON c.session_id = s.session_id) AS x WHERE x.row_rank <= 10ORDER BY x.cpu_time DESC

Archivos SQL más pesados

DatabaseNameLogicalNamePhysicalNameFileTypeSizeMBMaxSizeMBIsPercentGrowth
OpheliaSuiteOpheliaSuiteDMSE:\SGDEA\OpheliaSuite.mdfROWS4491846-1False
DMSDMSE:\SGDEA\DMS.mdfROWS52015-1False
DMSDMS_BE:\SGDEA\DMS_B.ndfROWS43402-1False
DriveDriveE:\SGDEA\Drive.mdfROWS34484-1False
tempdbtemp6D:\TEMPDB\temp6.mdfROWS31071-1False
tempdbtemp7D:\TEMPDB\temp7.mdfROWS30755-1False
tempdbtemp5D:\TEMPDB\temp5.mdfROWS30735-1False
tempdbtemp10D:\TEMPDB\temp10.mdfROWS30709-1False
tempdbtemp8D:\TEMPDB\temp8.mdfROWS29267-1False
tempdbtemp9D:\TEMPDB\temp9.mdfROWS23991-1False
tempdbtemp4D:\TEMPDB\temp4.mdfROWS21358-1False
tempdbtemp11D:\TEMPDB\temp11.mdfROWS13169-1False
tempdbtempdevD:\TEMPDB\tempdev.mdfROWS12644-1False
StageStageE:\SGDEA\Stage.mdfROWS10814-1False
DMS_bk_040923DMSE:\SGDEA\DMS_bk_040923.mdfROWS5000-1False
OpheliaSuiteOpheliaSuiteDMS_logF:\LOG\OpheliaSuite_log.ldfLOG32752097152False
DMS_BK_20DMSE:\SGDEA\DMS_BK_20.mdfROWS2184-1False
DMSDMS_logF:\LOG\DMS_log.ldfLOG19952097152False
StageStage_logF:\LOG\Stage_log.ldfLOG13552097152False
AgoraSSBAgoraE:\SGDEA\Agora.mdfROWS436-1False

Volumenes fisicos SQL

DatabaseNameFileTypePhysicalNameVolumeMountPointLogicalVolumeNameTotalGBFreeGBFreePct
AgoraSSBROWSE:\SGDEA\Agora.mdfE:\DATA5222.38684.0913.10
AgoraSSB_OLDROWSE:\SGDEA\AgoraSSB.mdfE:\DATA5222.38684.0913.10
CalendarioROWSE:\SGDEA\Calendario.mdfE:\DATA5222.38684.0913.10
DBAROWSE:\SGDEA\DBA.mdfE:\DATA5222.38684.0913.10
DMSROWSE:\SGDEA\DMS.mdfE:\DATA5222.38684.0913.10
DMSROWSE:\SGDEA\DMS_B.ndfE:\DATA5222.38684.0913.10
DMS_2ROWSE:\SGDEA\DMS_2.mdfE:\DATA5222.38684.0913.10
DMS_bk_040923ROWSE:\SGDEA\DMS_bk_040923.mdfE:\DATA5222.38684.0913.10
DMS_BK_20ROWSE:\SGDEA\DMS_BK_20.mdfE:\DATA5222.38684.0913.10
DMSGDEAROWSE:\SGDEA\DMSGDEA.mdfE:\DATA5222.38684.0913.10
DriveROWSE:\SGDEA\Drive.mdfE:\DATA5222.38684.0913.10
DWMaintenanceLOGE:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\DWMaintenance_logE:\DATA5222.38684.0913.10
DWMaintenanceROWSE:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\DWMaintenanceE:\DATA5222.38684.0913.10
EstructuraImportacionROWSE:\SGDEA\EstructuraImportacion.mdfE:\DATA5222.38684.0913.10
ImperiumReportCacheROWSE:\SGDEA\ImperiumReportCache.mdfE:\DATA5222.38684.0913.10
OpheliaSuiteROWSE:\SGDEA\OpheliaSuite.mdfE:\DATA5222.38684.0913.10
ProcessTableROWSE:\SGDEA\ProcessTable.mdfE:\DATA5222.38684.0913.10
StageROWSE:\SGDEA\Stage.mdfE:\DATA5222.38684.0913.10
AgoraSSBLOGF:\LOG\Agora_log.ldfF:\LOG299.98289.7896.60
AgoraSSB_OLDLOGF:\LOG\AgoraSSB_log.ldfF:\LOG299.98289.7896.60
CalendarioLOGF:\LOG\Calendario_log.ldfF:\LOG299.98289.7896.60
DBALOGF:\LOG\DBA_log.ldfF:\LOG299.98289.7896.60
DMSLOGF:\LOG\DMS_log.ldfF:\LOG299.98289.7896.60
DMS_2LOGF:\LOG\DMS_2_log.ldfF:\LOG299.98289.7896.60
DMS_bk_040923LOGF:\LOG\DMS_bk_040923_log.ldfF:\LOG299.98289.7896.60
DMS_BK_20LOGF:\LOG\DMS_BK_20_log.ldfF:\LOG299.98289.7896.60
DMSGDEALOGF:\LOG\DMSGDEA_log.ldfF:\LOG299.98289.7896.60
DriveLOGF:\LOG\Drive_log.ldfF:\LOG299.98289.7896.60
EstructuraImportacionLOGF:\LOG\EstructuraImportacion_log.ldfF:\LOG299.98289.7896.60
ImperiumReportCacheLOGF:\LOG\ImperiumReportCache_log.ldfF:\LOG299.98289.7896.60
OpheliaSuiteLOGF:\LOG\OpheliaSuite_log.ldfF:\LOG299.98289.7896.60
ProcessTableLOGF:\LOG\ProcessTable_log.ldfF:\LOG299.98289.7896.60
StageLOGF:\LOG\Stage_log.ldfF:\LOG299.98289.7896.60

Uso interno de archivos por base

DatabaseNameLogicalNameFileTypePhysicalNameSizeGBUsedGBFreeInternalGBUsedPctGrowthConfigMaxSizeGB
OpheliaSuiteOpheliaSuiteDMSROWSE:\SGDEA\OpheliaSuite.mdf4386.574385.351.2299.9764.000000 MBSin limite
OpheliaSuiteOpheliaSuiteDMS_logLOGF:\LOG\OpheliaSuite_log.ldf3.203.190.0199.5964.000000 MB2048.00 GB
AgoraSSBAgoraROWSE:\SGDEA\Agora.mdf0.430.410.0296.3564.000000 MBSin limite
DMSDMSROWSE:\SGDEA\DMS.mdf50.8048.422.3895.3264.000000 MBSin limite
DMSDMS_BROWSE:\SGDEA\DMS_B.ndf42.3840.401.9895.3264.000000 MBSin limite
DMSDMS_logLOGF:\LOG\DMS_log.ldf1.951.850.1094.8164.000000 MB2048.00 GB
DriveDriveROWSE:\SGDEA\Drive.mdf33.6829.703.9888.1964.000000 MBSin limite
DMS_BK_20DMSROWSE:\SGDEA\DMS_BK_20.mdf2.131.850.2986.5964.000000 MBSin limite
StageStage_logLOGF:\LOG\Stage_log.ldf1.321.120.2084.9464.000000 MB2048.00 GB
DWMaintenanceDWMaintenanceROWSE:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\DWMaintenance0.020.020.0084.8264.000000 MBSin limite
DMS_bk_040923DMSROWSE:\SGDEA\DMS_bk_040923.mdf4.884.130.7584.6364.000000 MBSin limite
AgoraSSB_OLDAgoraSSBROWSE:\SGDEA\AgoraSSB.mdf0.010.010.0082.9364.000000 MBSin limite
ProcessTableProcessTableDMSROWSE:\SGDEA\ProcessTable.mdf0.010.010.0082.8164.000000 MBSin limite
DMS_2DMSROWSE:\SGDEA\DMS_2.mdf0.070.060.0181.3364.000000 MBSin limite
StageStageROWSE:\SGDEA\Stage.mdf10.568.512.0580.6164.000000 MBSin limite
DMSGDEADMSGDEAROWSE:\SGDEA\DMSGDEA.mdf0.050.040.0180.5564.000000 MBSin limite
CalendarioCalendarioROWSE:\SGDEA\Calendario.mdf0.010.000.0062.5064.000000 MBSin limite
ProcessTableProcessTableDMS_logLOGF:\LOG\ProcessTable_log.ldf0.010.010.0057.3364.000000 MB2048.00 GB
EstructuraImportacionEstructuraImportacionROWSE:\SGDEA\EstructuraImportacion.mdf0.010.000.0049.2264.000000 MBSin limite
ImperiumReportCacheImperiumReportCacheROWSE:\SGDEA\ImperiumReportCache.mdf0.010.000.0042.9764.000000 MBSin limite
DBADBAROWSE:\SGDEA\DBA.mdf0.010.000.0036.7264.000000 MBSin limite
DMS_BK_20DMS_logLOGF:\LOG\DMS_BK_20_log.ldf0.010.000.0131.5664.000000 MB2048.00 GB
DriveDrive_logLOGF:\LOG\Drive_log.ldf0.270.080.2027.7564.000000 MB2048.00 GB
DWMaintenanceDWMaintenance_logLOGE:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\DWMaintenance_log0.010.000.0117.8864.000000 MB2048.00 GB
DMS_bk_040923DMS_logLOGF:\LOG\DMS_bk_040923_log.ldf0.010.000.0115.9164.000000 MB2048.00 GB
DMS_2DMS_logLOGF:\LOG\DMS_2_log.ldf0.010.000.0112.8964.000000 MB2048.00 GB
CalendarioCalendario_logLOGF:\LOG\Calendario_log.ldf0.000.000.009.8664.000000 MB2048.00 GB
EstructuraImportacionEstructuraImportacion_logLOGF:\LOG\EstructuraImportacion_log.ldf0.100.010.098.4764.000000 MB2048.00 GB
AgoraSSBAgora_logLOGF:\LOG\Agora_log.ldf0.100.010.098.3464.000000 MB2048.00 GB
ImperiumReportCacheImperiumReportCache_logLOGF:\LOG\ImperiumReportCache_log.ldf0.100.010.097.0764.000000 MB2048.00 GB
DMSGDEADMSGDEA_logLOGF:\LOG\DMSGDEA_log.ldf0.020.000.026.2864.000000 MB2048.00 GB
DBADBA_logLOGF:\LOG\DBA_log.ldf0.070.000.072.7164.000000 MB2048.00 GB
AgoraSSB_OLDAgoraSSB_logLOGF:\LOG\AgoraSSB_log.ldf0.070.000.071.8064.000000 MB2048.00 GB

Uso Transaction Log

DatabaseNameLogSizeGBLogSpaceUsedPctStatus
OpheliaSuite3.2099.590
DMS1.9594.810
Stage1.3284.940
msdb0.0084.560
ProcessTable0.0157.370
model0.0732.090
DMS_BK_200.0131.610
master0.0030.640
Drive0.2727.750
DWMaintenance0.0117.910
DMS_bk_0409230.0115.960
DMS_20.0112.930
Calendario0.009.990
EstructuraImportacion0.108.480
AgoraSSB0.108.340
ImperiumReportCache0.107.070
DMSGDEA0.026.310
DBA0.072.710
AgoraSSB_OLD0.071.810
tempdb0.871.310

Autogrowths recientes - 7 dias

EventNameDatabaseNameFileNameStartTimeDurationMsGrowthMBHostNameApplicationNameLoginName
Log File Auto GrowDMSDMS_log6/6/2026 2:02:44 PM100.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 2:02:42 PM100.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 1:37:56 PM96.0064.00DWSGDAAPP2ophelia
Data File Auto GrowOpheliaSuiteOpheliaSuiteDMS6/6/2026 1:34:04 PM100.0064.00DWSGDAAPP3ophelia
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 1:20:48 PM80.0064.00DWSGDAAPP3ophelia
Data File Auto GrowOpheliaSuiteOpheliaSuiteDMS6/6/2026 1:12:30 PM103.0064.00DWSGDAAPP1ophelia
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:54:16 PM100.0064.00DWSGDAAPP2ophelia
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:38:40 PM80.0064.00DWSGDAAPP3ophelia
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:18:03 PM100.0064.00DWSGDAAPP3ophelia
Log File Auto GrowStageStage_log6/6/2026 10:32:35 AM103.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 10:32:27 AM110.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 10:32:20 AM80.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 10:32:13 AM97.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 10:32:06 AM97.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 10:31:57 AM100.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 10:31:50 AM93.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 10:31:42 AM97.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 10:31:35 AM100.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 10:12:52 AM93.0064.00DWSGDAAPP1ophelia
Log File Auto GrowDMSDMS_log6/6/2026 10:03:06 AM110.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 10:03:04 AM116.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 8:24:07 AM97.0064.00DWSGDAAPP2ophelia
Log File Auto GrowDMSDMS_log6/6/2026 6:03:14 AM87.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 6:03:11 AM90.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 6:03:09 AM113.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:32:24 AM96.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:32:19 AM103.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:32:15 AM137.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:32:10 AM107.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:32:06 AM130.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:32:01 AM120.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:31:55 AM173.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:31:51 AM114.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:31:47 AM100.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:31:42 AM97.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:31:38 AM117.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xBFBEAA16B4144D4B9844B254237E9D79 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowStageStage_log6/6/2026 4:30:27 AM113.0064.00sa
Log File Auto GrowDMSDMS_log6/6/2026 2:12:54 AM143.0064.00DWSGDAAPP4MicroSQLophelia
Log File Auto GrowDMSDMS_log6/6/2026 2:03:18 AM160.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 2:03:13 AM107.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 2:03:05 AM100.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0xAA11EF2D2ED2784EAA5A0D962D66E469 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 2:02:29 AM123.0064.00DWSGDAAPP4MicroSQLophelia
Log File Auto GrowDMSDMS_log6/6/2026 2:00:29 AM137.0064.00DWSGDAAPP4MicroSQLophelia
Log File Auto GrowDMSDMS_log6/6/2026 12:50:48 AM87.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 2)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:52 AM93.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:51 AM110.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:50 AM103.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:49 AM106.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:48 AM100.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:47 AM110.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT

Guía de lectura - Autogrowths recientes

Un autogrowth significa que SQL Server tuvo que crecer automáticamente un archivo MDF, NDF o LDF porque se quedó sin espacio interno asignado. No siempre es un error, pero en producción puede causar pausas, esperas de I/O y bloqueos temporales.

DatoPara qué sirve
DatabaseNameIdentifica la base que está creciendo.
FileNameIndica si creció un archivo de datos o de log.
StartTimePermite cruzar el crecimiento con lentitud, bloqueos o caídas reportadas por usuarios.
DurationMsMide cuánto tardó el crecimiento. Si es alto, puede afectar la operación.
GrowthMBIndica cuánto creció. Crecimientos muy pequeños y frecuentes sugieren mala configuración.

Recomendación: preasignar tamaño a MDF/LDF y configurar crecimiento fijo en MB/GB. Evitar crecimiento porcentual en producción.

Backups recientes

DatabaseNameRecoveryModelLastFullBackupHoursSinceFullLastDifferentialBackupLastLogBackupMinutesSinceLog
AgoraSSBFULL5/31/2026 12:32:04 AM1606/6/2026 12:30:33 AM
AgoraSSB_OLDFULL5/31/2026 12:32:12 AM1606/6/2026 12:30:36 AM
CalendarioFULL5/31/2026 12:32:14 AM1606/6/2026 12:30:38 AM
DBAFULL5/31/2026 12:32:17 AM1606/6/2026 12:30:41 AM
DMSFULL5/31/2026 12:49:35 AM1606/6/2026 12:32:06 AM
DMS_2FULL5/31/2026 12:49:42 AM1606/6/2026 12:32:08 AM
DMS_bk_040923FULL5/31/2026 12:50:20 AM1606/6/2026 12:32:10 AM
DMS_BK_20FULL5/31/2026 12:50:40 AM1606/6/2026 12:32:11 AM
DMSGDEAFULL5/31/2026 12:50:42 AM1606/6/2026 12:32:13 AM
DriveFULL5/31/2026 12:55:44 AM1606/6/2026 12:33:03 AM
DWMaintenanceFULL5/31/2026 12:55:46 AM1606/6/2026 12:33:06 AM
EstructuraImportacionFULL5/31/2026 12:55:48 AM1606/6/2026 12:33:08 AM
ImperiumReportCacheFULL5/31/2026 12:55:50 AM1606/6/2026 12:33:10 AM
OpheliaSuiteFULL5/31/2026 8:38:16 AM1526/6/2026 12:39:33 AM
ProcessTableFULL5/31/2026 8:38:19 AM1526/6/2026 12:39:35 AM
StageFULL5/31/2026 8:38:42 AM1526/6/2026 12:39:50 AM

SQL Agent Jobs fallidos o sin historial

JobNameLastRunStatusrun_daterun_timerun_durationmessage
collection_set_1_noncached_collect_and_uploadNo history
collection_set_2_collectionNo history
collection_set_2_uploadNo history
collection_set_3_collectionNo history
collection_set_3_uploadNo history
DELETE_MANTNo history
DependenciesNo history
JOB BACKUP V2No history
JOB MANTENIMIENTO V2 DriveNo history
MongoSqlServerNo history

TempDB - archivos

LogicalNameFileTypePhysicalNameSizeMBUsedMBFreeMBUsedPctGrowthConfig
templogLOGD:\TEMPDB\templog.ldf893.9411.67882.271.3164.000000000000 MB
temp10ROWSD:\TEMPDB\temp10.mdf30709.251614.5029094.755.2664.000000000000 MB
temp11ROWSD:\TEMPDB\temp11.mdf13169.50809.8112359.696.1564.000000000000 MB
temp2ROWSD:\TEMPDB\temp2.mdf250.0011.88238.134.7564.000000000000 MB
temp3ROWSD:\TEMPDB\temp3.mdf300.0012.13287.884.0464.000000000000 MB
temp4ROWSD:\TEMPDB\temp4.mdf21358.131501.0019857.137.0364.000000000000 MB
temp5ROWSD:\TEMPDB\temp5.mdf30735.751521.8829213.884.9564.000000000000 MB
temp6ROWSD:\TEMPDB\temp6.mdf31071.811507.1929564.634.8564.000000000000 MB
temp7ROWSD:\TEMPDB\temp7.mdf30755.941532.3129223.634.9864.000000000000 MB
temp8ROWSD:\TEMPDB\temp8.mdf29267.191508.3127758.885.1564.000000000000 MB
temp9ROWSD:\TEMPDB\temp9.mdf23991.001504.6922486.316.2764.000000000000 MB
tempdevROWSD:\TEMPDB\tempdev.mdf12644.19753.3111890.885.9664.000000000000 MB

TempDB - consumidores principales

SessionIdLoginNameHostNameProgramNameDatabaseNamestatuscommandTempdbAllocatedMBTempdbDeallocatedMBQueryText
705opheliaDWSGDAAPP1Core .Net SqlClient Data Provider3.693.88
85DIGITALWARE\SCVSGDA-AGENTSRVCLSGDEASQLAgent - Generic Refresher1.190.69
262monitoreosaasFASECOLDAVM.Net SqlClient Data Provider0.440.44
168DIGITALWARE\DominnigMDWSGDASQL2Microsoft SQL Server Management Studio0.060.06
390opheliaDWSGDAAPP1Core Microsoft SqlClient Data Provider0.060.06
391opheliaDWSGDAAPP2EFCore/10.0.5 (Microsoft Windows 10.0.17763 X64)0.000.00
392opheliaDWSGDAAPP2MicroSQL0.000.00
393opheliaDWSGDAAPP3MicroSQL0.000.00
394opheliaDWSGDAAPP3MicroSQL0.000.00
395opheliaDWSGDAAPP1ODK0.000.00
396opheliadmsDWSGDAAPP1Core Microsoft SqlClient Data Provider0.000.00
397opheliadmsDWSGDAAPP2Core Microsoft SqlClient Data Provider0.000.00
398opheliaDWSGDAAPP1MicroSQL0.000.00
399opheliaDWSGDAAPP1ODK0.000.00
400opheliaDWSGDAAPP3MicroSQL0.000.00
401opheliadmsDWSGDAAPP1Core Microsoft SqlClient Data Provider0.000.00
402opheliaDWSGDAAPP3MicroSQL0.000.00
403opheliaDWSGDAAPP3MicroSQL0.000.00
404opheliaDWSGDAAPP3MicroSQL0.000.00
405opheliaDWSGDAAPP3MicroSQL0.000.00
406opheliaDWSGDAAPP1MicroSQL0.000.00
407opheliaDWSGDAAPP3MicroSQL0.000.00
408opheliaDWSGDAAPP3MicroSQL0.000.00
409opheliaDWSGDAAPP3MicroSQL0.000.00
410opheliaDWSGDAAPP1ODK0.000.00
411opheliaDWSGDAAPP3MicroSQL0.000.00
412opheliaDWSGDAAPP2MicroSQL0.000.00
413opheliaDWSGDAAPP30.000.00
415opheliaDWSGDAAPP10.000.00
419opheliaDWSGDAAPP2MicroSQL0.000.00

Top Queries Logical Reads

ExecutionsTotalLogicalReadsAvgLogicalReadsCPUTimeMsElapsedMsDatabaseNameQueryText
27622261706780658354494831462827SELECT [w].[EMP_CODI], [w].[CAS_CONT], [w].[SEG_CONT], [w].[AUD_ESTA], [w].[AUD_UFAC], [w].[AUD_USUA], [w].[ETA_CONT], [w].[FLU_CONT], [w].[SEG_ABRE], [w].[SEG_AENV], [w].[SEG_ALER], [w].[SEG_COME], [w].[SEG_CONA], [w].[SEG_DATA], [w].[SEG_DIAD], [w].[SEG_DIAE], [w].[SEG_DIAR], [w].[SEG_EANT], [w].[SEG_ERRO], [w].[SEG_ESTC], [w].[SEG_ESTE], [w].[SEG_FATI], [w].[SEG_FCUL], [w].[SEG_FENC], [w].[SEG_FIEJ], [w].[SEG_FLIM], [w].[SEG_FREC], [w].[SEG_HCUL], [w].[SEG_HLIM], [w].[SEG_HREC], [w].[SEG_IDCH], [w].[SEG_INTE], [w].[SEG_IPAD], [w].[SEG_PRIO], [w].[SEG_RECO], [w].[SEG_RESU], [w].[SEG_SUBJ], [w].[SEG_UALA], [w].[SEG_UENC], [w].[SEG_UORI] FROM [WF_SEGUI] AS [w] WHERE [w].[EMP_CODI] = @companyCode AND [w].[SEG_IPAD] = @localIp AND [w].[SEG_ESTE] = N'Q' AND [w].[SEG_FENC] < @queuingDate AND [w].[SEG_FREC] >= @creationDate
18013163431949907311973841252850SELECT TOP(@__p_2) [r].[Id], [r].[CaseCode], [r].[CompanyCode], [r].[CompletedAt], [r].[CreatedAt], [r].[DependencyCode], [r].[ErrorMessage], [r].[FileNumber], [r].[JobId], [r].[LastErrorAt], [r].[MaxRetries], [r].[NextRetryAt], [r].[ProcessCode], [r].[ProcessName], [r].[ProcessingServer], [r].[Reason], [r].[ReassignBPM], [r].[ReassignDMS], [r].[RetryCount], [r].[StartedAt], [r].[Status], [r].[StatusId], [r].[TrackingCode], [r].[UserExecutor], [r].[UserToReassign] FROM [ReassignmentTask] AS [r] WHERE [r].[ProcessingServer] = @__serverIp_0 AND ([r].[Status] = N'Pending' OR ([r].[Status] = N'Failed' AND [r].[RetryCount] < [r].[MaxRetries] AND [r].[NextRetryAt] IS NOT NULL AND [r].[NextRetryAt] <= @__now_1)) ORDER BY [r].[CreatedAt]
16620484273878026247561105296select RequestFiles . FileNumber , convert ( VARCHAR , RequestFiles . FiledDate ) Z from RequestFiles left join RequestFileHistories on RequestFiles . Id = RequestFileHistories . RequestFileId and RequestFileHistories . CreationDate = ( select MAX ( CreationDate ) from dms . dbo . RequestFileHistories A where A . RequestFileId = RequestFileHistories . RequestFileId and A . Status not in ( @0 ) ) left join TypeDetail on TypeDetail . Id = RequestFileHistories . Status where RequestFileHistories . UserName = @1 and TypeDetail . Name < > @2
7634681692061359125407146969SELECT bs.database_name as dbname, [type], DATEDIFF(SECOND, bs.backup_finish_date, getdate()) as time_since_last_backup, (DATEDIFF(SECOND, bs.backup_start_date, bs.backup_finish_date)) as duration, db.recovery_model as db_recovery_model FROM msdb.dbo.backupset as bs LEFT JOIN sys.databases as db ON bs.database_name = db.name WHERE bs.database_name not in ( SELECT AGDatabases.database_name AS Databasename FROM sys.dm_hadr_availability_group_states States INNER JOIN master.sys.availability_groups Groups ON States.group_id = Groups.group_id INNER JOIN sys.availability_databases_cluster AGDatabases ON Groups.group_id = AGDatabases.group_id WHERE primary_replica != @@Servername OR primary_replica is NULL ) and db.name is not NULL GROUP BY bs.database_name, backup_finish_date, [type], backup_start_date, db.recovery_model HAVING backup_finish_date = ( SELECT MAX(backup_finish_date) FROM msdb.dbo.backupset WHERE database_name = bs.database_name AND bs.type = [type] ) ORDER BY bs.database_name
14393606443936064299587147516StageINSERT INTO dbo.SmartSupervisionMom2 SELECT RequestFiles.Id AS RequestFilesId ,RequestFiles.FileNumber AS [RADICADO FIDUGESTOR] -- Número de radicado ,CAST(CAST(RequestFiles.FiledDate AS DATE) AS VARCHAR) AS [FECHA DE RADICACION] -- Fecha de radicación ,FORMAT(RequestFiles.FiledDate, 'h:mm tt') AS [HORA_RADICACION] -- Hora de radicación en formato AM/PM ,CONCAT(DATENAME(MONTH, RequestFiles.FiledDate),' - ',YEAR(RequestFiles.FiledDate)) AS [MES/AÑO] -- Mes y año en español --Tipo de PQR extraído del motivo de reclasificación o tomado por defecto ,COALESCE( SUBSTRING( RequestFileHistoriesReclas.Reason, CHARINDEX('Se reclasificó el tipo de PQRSD así: de', RequestFileHistoriesReclas.Reason) + LEN('Se reclasificó el tipo de PQRSD así: de'), CHARINDEX(' a ', RequestFileHistoriesReclas.Reason) - CHARINDEX('Se reclasificó el tipo de PQRSD así: de', RequestFileHistoriesReclas.Reason) - LEN('Se reclasificó el tipo de PQRSD así: de') ), PqrsType.Name ) AS [TIPO_DE_PQR] --Clasificaciones, canal, motivos, tipo y detalle de solicitud ,producto.Name AS [CLASIFICACION SFC PRODUCTO] ,canalpqr.Name AS [CANAL] ,Motivo.Name AS [MACROMOTIVO] ,NameType.Name AS [TIPO DE SOLICITUD] ,ProcedureType.Name AS [DETALLE DE LA SOLICITUD] ,SpecificationType.Name AS [ESPECIFICACIÓN DE LA SOLICITUD] -- Información relacionada con la transmisión a la SFC ,CONCAT(512,RequestFiles.FileNumber) AS [RADICADO SFC FIDUGESTOR] ,CAST(CAST(RequestFiles.FiledDate AS DATE) AS VARCHAR) AS [FECHA DEL ENVIO A SFC] ,'Recibida' AS [ESTADO SFC MOMENTO 2] ,CASE WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN 'Enviada' ELSE 'No Enviada' END AS [ESTADO DE LA TRASMISION] ,CASE WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN CAST(CAST(smartprocesslog.RegistrationDate AS DATE) AS VARCHAR) END AS [FECHA DE TRASMISION] ,CASE WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN 'N/A' ELSE CAST(smartprocesslog.Observations AS NVARCHAR(MAX)) END AS [TIPO DE ERROR] -- Información de funcionarios y dependencias que gestionan y responden ,CONCAT(Users1.Name,' ', Users1.Surnames ) [FUNCIONARIO QUE GESTIONA] ,Dependencies1.Name [DEPENDENCIA QUE GESTIONA] ,CAST(CAST(RequestFileHistories1.CreationDate AS DATE) AS VARCHAR) AS [FECHA DE LA GESTION] ,CASE WHEN CONCAT(UsersFinalizador.Name,' ', UsersFinalizador.Surnames ) <>'' THEN CONCAT(UsersFinalizador.Name,' ', UsersFinalizador.Surnames ) ELSE CONCAT(Users.Name,' ', Users.Surnames ) END AS [FUNCIONARIO QUE RESPONDE] ,Dependencies.Name AS [DEPENDENCIA QUE RESPONDE] -- Información sobre respuestas parciales o definitivas ,CASE WHEN MAX(RequestFilesRespuestaParcial.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL AND MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER(PARTITION BY RequestFiles.FileNumber) IS NULL THEN 'Respuesta Parcial' WHEN MAX(RequestFilesRespuestaDefinitiva.FileNumber) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL THEN 'Respuesta Definitiva' END AS [TIPO DE RESPUESTA] ,MAX(ISNULL(RequestFilesRespuestaDefinitiva.FileNumber,RequestFilesRespuestaParcial.FileNumber)) OVER(PARTITION BY RequestFiles.FileNumber) AS [RADICADO DE RESPUESTA (MOMENTO 3)] ,MAX(CONVERT(VARCHAR,CONVERT(DATE,ISNULL(RequestFilesRespuestaDefinitiva.FiledDate, RequestFilesRespuestaParcial.FiledDate)))) OVER(PARTITION BY RequestFiles.FileNumber) AS [FECHA DE RESPUESTA] ,MAX(RIGHT(CONVERT(DATETIME, ISNULL(RequestFilesRespuestaDefinitiva.FiledDate,RequestFilesRespuestaParcial.FiledDate), 108),8)) OVER(PARTITION BY RequestFiles.FileNumber) AS [HORA DE RESPUESTA] -- Estado de envío al momento 3 ,CASE WHEN MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Enviada' ELSE 'No Enviada' END AS [SE ENVIO MOMENTO 3] ,CASE WHEN MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'N/A' WHEN smartprocesslogMom3.RegistrationDate IS NULL THEN 'No ha sido Enviada' ELSE CAST(smartprocesslogMom3.Observations AS VARCHAR(8000)) END AS [TIPO DE ERROR MOMENTO 3] ,CAST(CAST(smartprocesslogMom3.RegistrationDate AS DATE) AS VARCHAR) AS [FECHA DE TRASMISION MOMENTO 3] -- Estado final de la solicitud ,CASE WHEN MAX(RequestFilesRespuestaDefinitiva.FiledDate) OVER(PARTITION BY RequestFiles.FileNumber) IS NOT NULL AND MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Cerrado' WHEN smartprocesslog.Id IS NOT NULL AND MIN(smartprocesslogMom3.Status) OVER (PARTITION BY smartprocesslogMom3.FileNumber,smartprocesslogMom3.ClientDocumentNumber)='EXITOSO' THEN 'Recibida' ELSE 'Abierto' END AS [ESTADO ACTUAL MOMENTO 3] -- Información adicional de reclasificación y seguimiento ,CASE WHEN RequestFileHistoriesReclas.Id IS NOT NULL THEN 'Si' ELSE 'No' END AS [EL RADICADO TUVO RECLASIFICACION] ,RequestFileHistoriesReclas.Reason AS [TIPO DE PQRS ANTES DE RECLASIFICAR] ,PqrsType.Name AS [TIPO DE PQRS DESPUES DE RECLASIFICAR] ,Admision.Name AS [ADMISION] ,SmartAddicionalRequestFiles.ComingFromProcedure AS [PROCEDENTE] ,Favorabilidad.Name AS [FAVORABILIDAD] ,SmartAddicionalRequestFiles.FavorConsumerProcedure AS [A FAVOR DE] ,CASE WHEN SmartAddicionalRequestFiles.RefusedEntityProcedure='1' THEN 'Si' ELSE 'No' END AS [INADMITIDA O RECHAZADA POR LA ENTIDAD] ,SmartAddicionalRequestFiles.SuperFRemittedProcedure AS [TRASLADO A LA SUPERINTENDENCIA] ,AFavorDe.Name AS [ACEPTACION] ,Rectificacion.Name AS [RECTIFICACION] ,Desistimiento.Name AS [DESISTIMIENTO] ,clients.NumberIdentification AS [REMITENTE] ,CASE WHEN Clients.AffiliatedFomag='1' THEN 'Si' ELSE 'No' END AS [AFILIADO AL FOMAG] ,AffiliateType.Code AS [TIPO DE AFILIADO] ,RequestFiles.Subject AS [ASUNTO] ,CASE WHEN Clients.OriginRegistry='SmartSupervision' AND RequestFiles.ReportedSmart='1' THEN 'Si' WHEN Clients.OriginRegistry NOT IN ('SmartSupervision') THEN 'No' END AS [ACTUALIZO MOMENTO 4] ,CASE WHEN RequestFiles.ReportedSmart='1' THEN CONVERT(VARCHAR,CONVERT(DATE,Clients.ModificationDate)) END AS [FECHA ACTUALIZACION] -- Campos auxiliares para filtrado por año y mes ,CAST(YEAR(RequestFiles.FiledDate) AS int) AS AñoFil ,MONTH(RequestFiles.FiledDate) AS MesFil ,ISNULL(Dependencies.code,0) AS DependeciaFil -- Add campos Circular 19 ,Circular19.[TIPO DE FRAUDE] AS [TIPO DE FRAUDE] ,Circular19.[MODALIDAD DE FRAUDE] AS [MODALIDAD DE FRAUDE] ,Circular19.[MONTO RECLAMADO] AS [MONTO RECLAMADO] ,Circular19.[MONTO RECONOCIDO] AS [MONTO RECONOCIDO] -- Tabla principal de radicados FROM DMS.DBO.RequestFiles -- Unión para identificar el último usuario que gestionó el radicado LEFT JOIN ( SELECT RequestFileHistories.UserName, RequestFileHistories.RequestFileId, RequestFileHistories.Status, RequestFileHistories.processcode, ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS rn FROM DMS.DBO.RequestFileHistories WHERE Status NOT IN (--Se agregan los siguientes estados por caso SAC 960781 '4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425' ,'8d6acd5a-d128-45b0-b1a5-f9c0fef90708','EF7B7E43-9151-422A-9A2C-6E3B6C53BC85') AND ProcessCode !='615' ) RequestFileHistories ON RequestFileHistories.RequestFileId = RequestFiles.Id AND RequestFileHistories.rn = 1 -- Unión con la información del cliente LEFT JOIN DMS.DBO.clients ON clients.Id = RequestFiles.clientid -- Unión para obtener el último registro del Momento 2 con subproceso REPORTE_QUEJA LEFT JOIN ( SELECT smartprocesslog.Id, smartprocesslog.Status, smartprocesslog.FileNumber, smartprocesslog.RegistrationDate, smartprocesslog.Observations, smartprocesslog.ClientDocumentNumber, ROW_NUMBER() OVER (PARTITION BY FileNumber, ClientDocumentNumber ORDER BY RegistrationDate DESC) AS rn FROM DMS.DBO.smartprocesslog WHERE Process = 'MOMENTO_2' AND SubProcess = 'REPORTE_QUEJA' --AND smartprocesslog.FileNumber = '20241011326782' ) smartprocesslog ON smartprocesslog.FileNumber = RequestFiles.FileNumber AND smartprocesslog.ClientDocumentNumber = Clients.NumberIdentification AND smartprocesslog.rn = 1 -- Unión para obtener el último registro del Momento 3 con subproceso REPORTE_QUEJA LEFT JOIN ( SELECT smartprocesslog.Id, smartprocesslog.FileNumber, smartprocesslog.ClientDocumentNumber, smartprocesslog.RegistrationDate, smartprocesslog.Status, smartprocesslog.Observations, ROW_NUMBER() OVER ( PARTITION BY FileNumber ORDER BY -- Prioriza los EXITOSO más recientes, luego cualquier otro estado CASE WHEN Status = 'EXITOSO' THEN 1 ELSE 2 END, RegistrationDate DESC ) AS rn FROM DMS.DBO.smartprocesslog WHERE Process = 'MOMENTO_3' AND SubProcess = 'REPORTE_QUEJA' AND Status IN ('EXITOSO', 'FINALIZADO', 'FALLIDO') ) smartprocesslogMom3 ON smartprocesslogMom3.FileNumber = RequestFiles.FileNumber --AND smartprocesslogMom3.Id = ( -- SELECT TOP 1 AA.Id -- FROM DMS.DBO.smartprocesslog AA -- WHERE AA.FileNumber = smartprocesslogMom3.FileNumber -- AND AA.Process = 'MOMENTO_3' -- AND AA.SubProcess = 'REPORTE_QUEJA' -- ORDER BY AA.RegistrationDate DESC --) AND smartprocesslogMom3.rn = 1 -- Historial más antiguo con dependencia asignada LEFT JOIN ( SELECT RequestFileHistories.RequestFileId, RequestFileHistories.CreationDate, RequestFileHistories.UserName, RequestFileHistories.ProcessCode, ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate ASC) AS rn FROM DMS.DBO.RequestFileHistories WHERE DependencyId IS NOT NULL AND ProcessCode !='615' --AND RequestFileId ='FCF1BB64-614E-4D69-9E4A-D8BED126A1DC' ) RequestFileHistories1 ON RequestFileHistories1.RequestFileId = RequestFiles.Id AND RequestFileHistories1.rn = 1 -- Último historial con estado 'Finalizado' LEFT JOIN ( SELECT AAA.RequestFileId, AAA.CreationDate, AAA.UserName, ROW_NUMBER() OVER (PARTITION BY AAA.RequestFileId ORDER BY AAA.CreationDate DESC) AS rn FROM DMS.DBO.RequestFileHistories AAA INNER JOIN DMS.DBO.TYPESTATEREQUEST_VW BBB ON CONVERT(VARCHAR(40), AAA.Status) = CONVERT(VARCHAR(40), BBB.Id) WHERE BBB.Name = 'Finalizado' ) RequestFileHistoriesUsuarioFinalizador ON RequestFileHistoriesUsuarioFinalizador.RequestFileId = RequestFiles.Id AND RequestFileHistoriesUsuarioFinalizador.rn = 1 -- Usuario que finalizó el radicado LEFT JOIN DMS.DBO.Users UsersFinalizador ON UsersFinalizador.UserName = RequestFileHistoriesUsuarioFinalizador.UserName -- Historial de reclasificación LEFT JOIN (SELECT RequestFileHistories.Id, RequestFileHistories.RequestFileId, RequestFileHistories.Reason, ROW_NUMBER() OVER (PARTITION BY RequestFileId ORDER BY CreationDate DESC) AS rn FROM DMS.DBO.RequestFileHistories WHERE RequestFileHistories.Status = '31b6159d-de9d-4cba-9508-4d9d4ee2faf7' ) AS RequestFileHistoriesReclas ON RequestFileHistoriesReclas.RequestFileId = RequestFiles.Id AND RequestFileHistoriesReclas.rn = 1 -- Usuario que respondió LEFT JOIN DMS.DBO.Users Users ON Users.UserName = RequestFileHistories.UserName -- Usuario asociado al historial más antiguo con dependencia LEFT JOIN DMS.DBO.Users Users1 ON Users1.UserName = RequestFileHistories1.UserName -- Información adicional del radicado (producto, canal, motivo, etc.) LEFT JOIN DMS.DBO.SmartAddicionalRequestFiles ON SmartAddicionalRequestFiles.RequestFilesId = RequestFiles.Id LEFT JOIN DMS.DBO.TypeDetail producto ON producto.Id = SmartAddicionalRequestFiles.ProductCode LEFT JOIN DMS.DBO.TypeDetail canalpqr ON canalpqr.Id = SmartAddicionalRequestFiles.Channel LEFT JOIN DMS.DBO.TypeDetail Motivo ON Motivo.Id = SmartAddicionalRequestFiles.MacroReasonCode LEFT JOIN DMS.DBO.TypeDetail Admision ON Admision.Id = SmartAddicionalRequestFiles.Admission LEFT JOIN DMS.DBO.TypeDetail Favorabilidad ON Favorabilidad.Id = SmartAddicionalRequestFiles.Favorability LEFT JOIN DMS.DBO.TypeDetail AFavorDe ON AFavorDe.Id = SmartAddicionalRequestFiles.Acceptance LEFT JOIN DMS.DBO.TypeDetail Rectificacion ON Rectificacion.Id = SmartAddicionalRequestFiles.Rectification LEFT JOIN DMS.DBO.TypeDetail Desistimiento ON Desistimiento.Id = SmartAddicionalRequestFiles.ComplaintWithdrawal -- Tipo de afiliado del cliente LEFT JOIN DMS.DBO.TYPEAFFILIATE_VW AffiliateType ON Clients.AffiliateTypeId = CONVERT(VARCHAR(40), AffiliateType.Id) -- Procedimiento asociado al radicado LEFT JOIN DMS.DBO.DMS_Procedures ON DMS_Procedures.Id = RequestFiles.ProcedureId LEFT JOIN DMS.DBO.PQRSDTypeRequest NameType ON NameType.Id = DMS_Procedures.NameTypeId LEFT JOIN DMS.DBO.PQRSDDetailRequest ProcedureType ON ProcedureType.Id = DMS_Procedures.ProcedureTypeId LEFT JOIN DMS.DBO.PQRSDRequestSpecification SpecificationType ON SpecificationType.Id = DMS_Procedures.SpecificationTypeId -- Tipo PQRSD del radicado LEFT JOIN DMS.dbo.PQRSDType PqrsType ON PqrsType.Id = RequestFiles.PqrsTypeId -- Verifica si tiene respuesta parcial LEFT JOIN ( SELECT CC.Id, AA.FiledDate, AA.FileNumber, AA.ChannelId, ROW_NUMBER() OVER (PARTITION BY BB.ParentId ORDER BY AA.FiledDate DESC) AS RN FROM DMS.dbo.RequestFiles AA INNER JOIN DMS.dbo.RelatedRequestFiles BB ON BB.RequestFileId = AA.Id INNER JOIN DMS.dbo.RequestFiles CC ON BB.ParentId = CC.Id WHERE AA.RequestTypeId = '956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND AA.ResposnseText = 2 ) RequestFilesRespuestaParcial ON RequestFiles.Id = RequestFilesRespuestaParcial.Id AND RequestFilesRespuestaParcial.RN = '1' -- Verifica si tiene respuesta definitiva LEFT JOIN ( SELECT CC.Id, AA.FiledDate, AA.FileNumber, AA.ChannelId, ROW_NUMBER() OVER (PARTITION BY BB.ParentId ORDER BY AA.FiledDate DESC) AS RN FROM DMS.dbo.RequestFiles AA INNER JOIN DMS.dbo.RelatedRequestFiles BB ON BB.RequestFileId = AA.Id INNER JOIN DMS.dbo.RequestFiles CC ON BB.ParentId = CC.Id WHERE AA.RequestTypeId = '956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND AA.ResposnseText = 1 ) RequestFilesRespuestaDefinitiva ON RequestFiles.Id = RequestFilesRespuestaDefinitiva.Id AND RequestFilesRespuestaDefinitiva.RN = '1' --Dependencia del usuario finalizador o de quien respondió LEFT JOIN ( SELECT * FROM ( SELECT UsersCompany.UserId, Dependencies.Id AS DependencyId, Dependencies.Name, Dependencies.Code, Dependencies.TopSection, UsersCompany.State, ROW_NUMBER() OVER (PARTITION BY UsersCompany.UserId ORDER BY TypeDetail.Code ASC) AS rn FROM DMS.DBO.UsersCompany INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id = UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State = TypeDetail.Id ) RankedDependencies WHERE rn = 1 ) Dependencies ON ISNULL(UsersFinalizador.id, Users.id) = Dependencies.UserId --Consulta adiciona los campos de la actualización circular 19 LEFT JOIN ( SELECT RequestFilesId, FraudTypeName.Name AS [Tipo de Fraude], FraudModalityName.Name AS [Modalidad de Fraude], FORMAT(ISNULL(ClaimedAmount, 0), 'N0', 'es-CO') AS [Monto Reclamado], FORMAT(ISNULL(RecognizedAmount, 0), 'N0', 'es-CO') AS [Monto Reconocido] FROM DMS.dbo.SmartAddicionalRequestFiles LEFT JOIN DMS.dbo.TypeDetail AS FraudTypeName ON SmartAddicionalRequestFiles.FraudType = FraudTypeName.Id AND FraudTypeName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB754' LEFT JOIN DMS.dbo.TypeDetail AS FraudModalityName ON SmartAddicionalRequestFiles.FraudModality = FraudModalityName.Id AND FraudModalityName.TypeHeadId = '6B6708AE-6E99-488D-9E3E-23F42D5EB758') AS Circular19 ON RequestFiles.Id = Circular19.RequestFilesId -- Dependencia asociada al primer usuario con historial LEFT JOIN ( SELECT * FROM ( SELECT UsersCompany.UserId, Dependencies.Id AS DependencyId, Dependencies.Name, Dependencies.Code, Dependencies.TopSection, UsersCompany.State, ROW_NUMBER() OVER (PARTITION BY UsersCompany.UserId ORDER BY TypeDetail.Code ASC) AS rn FROM DMS.DBO.UsersCompany INNER JOIN DMS.DBO.Dependencies ON Dependencies.Id = UsersCompany.DependenceId INNER JOIN DMS.DBO.TypeDetail ON UsersCompany.State = TypeDetail.Id ) RankedDependencies WHERE rn = 1 ) Dependencies1 ON Users1.Id = Dependencies1.UserId -- Filtros principales WHERE RequestFiles.OriginId = '2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' -- Origen de radicados AND RequestFiles.StatusId <> 'E6D67E4A-F545-4D62-B882-5A38A0FC35E2' -- Excluir anulados AND RequestFileHistories.Status NOT IN ('4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425') AND RequestFiles.PqrsTypeId NOT IN ( 'B48BF430-F3F7-4431-A375-3B9DBC1441E4', -- QuejEx '496B613B-8905-4496-A201-5AF1235DA91C' -- QejSFC ) AND RequestFileHistories.ProcessCode !='615'
58026040729448977298661045587WITH FilteredTables AS ( SELECT object_id FROM sys.tables WHERE object_id > 0 ) INSERT INTO #IndexStats SELECT stats.database_id, stats.object_id, stats.index_id, stats.partition_number, AVG(stats.avg_fragmentation_in_percent) AS avg_fragmentation_in_percent, SUM(stats.page_count) * 8 AS IndexSizeKb FROM FilteredTables AS t INNER JOIN sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'LIMITED') AS stats ON stats.object_id = t.object_id GROUP BY stats.database_id, stats.object_id, stats.index_id, stats.partition_number HAVING SUM(stats.page_count) * 8 >= 1024
19033206317721084451886472854SELECT COUNT(*) FROM [ReassignmentTask] AS [r] WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0
9320241740953618136774138386SELECT ETA_ASUN,GAB_CONT,ETA_INST,ETA_CRIA,ETA_PCOM,ETA_PDEL, ETA_PSEG,ETA_PRIO,ETA_MTIE,ETA_DLIM,ETA_HLIM,ETA_CLIM,ETA_DREC, ETA_HREC,ETA_CREC,ETA_POSX,ETA_POSY,ETA_INIC,ETA_SECS,ETA_RECO, ETA_MACC,CCA_CONT,ETA_EMAI,ETA_TABL,ETA_CAMP,ETA_ANTE,ETA_MASU, ETA_CRIS,ETA_ANTS,ETA_NOTI,ETA_SNOT,ETA_APAR,ETA_VMIN,ETA_VMAX, ETA_COST,FLU_COND,ETA_ACOR,ETA_MCOR,WEB_CONT,MWE_CONT,ETA_ARCH, REG_CONT,PLA_CONT,DPL_CONT,ETA_EJEC,ETA_TPLA,ETA_ADJU,ETA_ATDO, ETA_APLA,ETA_ADPR,ETA_TTAR,PLA_COND,DGR_CONU,DGR_CONA,ETA_DEST, ETA_SSQL,DPL_COND,ETA_TLIM,ETA_TESP,ETA_TARC,ETA_SARC,ETA_OSEP, ETA_ODAT,ETA_IENC,PME_CONT,ETA_EXTE,ETA_TFIN,ETA_TTES,DPL_CON1, DPL_CON2,DPL_CON3,ETA_CDOC,ETA_CLEC,ETA_TCON,ETA_CCES,ETA_CSMS, ETA_DSMS,ETA_ESMS,ETA_CEMA,ETA_DEMA,PTL_CODI,PTL_VERS,DPT_CODI, PTL_CODA,PTL_VERA,DPT_CODA,PTL_CODD,PTL_VERD,DPT_CODD,PTL_CODE, PTL_VERE,DPT_COD1,DPT_COD2,DPT_COD3,DPT_COD4,DPT_COD5,DPT_COD6, WSE_CODE,ETA_ADDP,DPG_CODU,DPG_CODA,ETA_VSER,ETA_TREG, ETA_TIES,ETA_CLES,ETA_DLES,ETA_HLES,ETA_TCAL,ETA_DALE,ETA_HALE FROM WF_ETAPA WITH (NOLOCK) WHERE EMP_CODI= @ AND FLU_CONT= @_1 AND ETA_CONT= @_2
2408712545873520353730371344SELECT TOP(@__p_0) [w].[QUEUE_ID] FROM [WF_PROCESS_QUEUE] AS [w] WHERE [w].[STATUS] = N'PENDING' AND [w].[RETRY_COUNT] < [w].[MAX_RETRIES] ORDER BY [w].[PRIORITY] DESC, [w].[CREATED_DATE]
2387812293892514365413381001SELECT COUNT(*) FROM [WF_PROCESS_QUEUE] AS [w] WHERE [w].[STATUS] = N'PROCESSING' AND ([w].[LAST_HEARTBEAT] IS NULL OR DATEDIFF(minute, [w].[LAST_HEARTBEAT], @__now_1) <= @___heartbeatTimeoutMinutes_2)
24551148815046796096481068SELECT TOP 10 t.NAME AS TableName, t.object_id, mainIndex.data_space_id, SUM(p.rows) AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(CASE i.[type] WHEN 2 THEN 8 * a.used_pages ELSE 0 END) AS IndexSpaceKB FROM [sys].[tables] t INNER HASH JOIN sys.indexes mainIndex ON (t.object_id = mainIndex.object_id AND mainIndex.[type] IN (0,1)) INNER HASH JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER HASH JOIN [sys].[partitions] p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER HASH JOIN [sys].[allocation_units] a ON p.partition_id = a.container_id WHERE t.is_ms_shipped = 0 AND i.OBJECT_ID > 255 GROUP BY t.Name, t.object_id, mainIndex.data_space_id ORDER BY TotalSpaceKB DESC
5333124106598241224645225928SELECT COUNT(*) FROM GN_DIASN WHERE CCA_CONT= @ AND DIA_NOTR > @_1 AND DIA_NOTR <= @_2
492717842317946237393194076DMSSELECT DISTINCT RequestFiles.Id RequestFileId ,RequestFileIdParent ,CASE WHEN Status='914f4fcc-627c-49b0-8c67-75a21f826d31' THEN '1' --Finalizado --WHEN Status='7AD94AE5-6D29-4EC0-B846-2664C88A7D45' THEN '2' --Getión y Tramite --ELSE NULL END ResponseText ELSE '2' END ResponseText --18/10/2024 Se realiza ajuste de acuerdo a los diferentes posibles status que puede tener un radicado, se valida con Julio INTO #RADICADOSTEMP_ FROM RequestFiles INNER JOIN ( SELECT RequestFileId RequestFileIdParent --,REPLACE(RIGHT(RequestFileHistories.Reason, CHARINDEX(' ', REVERSE(RequestFileHistories.Reason)) - 1),'radicado','') AS reason ,CASE WHEN CHARINDEX(' ', RequestFileHistories.Reason) > 0 THEN REPLACE( REVERSE( SUBSTRING( REVERSE(RequestFileHistories.Reason), 1, CHARINDEX(' ', REVERSE(RequestFileHistories.Reason)) - 1 ) ), 'radicado', '' ) ELSE REPLACE(RequestFileHistories.Reason, 'radicado', '') END AS reason ,Status FROM RequestFileHistories INNER JOIN RequestFiles ON RequestFiles.ID=RequestFileHistories.RequestFileId AND OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' --AND CONVERT(DATE,RequestFileHistories.CreationDate) =CONVERT(DATE,GETDATE()) WHERE RequestFileHistories.Reason LIKE '%Se envía respuesta%' OR RequestFileHistories.Reason LIKE '%Se envió respuesta%' --and RequestFileId='D1D39553-523A-4B4F-87F0-BD80A20B6A6A' --AND --where --RequestFiles.FileNumber='20231012303362' --)RADICADOS ON RADICADOS.Reason=RequestFiles.FileNumber --WHERE RequestFileId='B90E3FB9-304F-41C4-B124-251A6BC8B62F' )RADICADOS ON RADICADOS.reason=RequestFiles.FileNumber
181999528199952242153226445SELECT * FROM dbo.V_RPTG_Radicados WHERE Radicado <> '0'
2459708424228804679057580SELECT TOP 10 t.NAME AS TableName, t.object_id, mainIndex.data_space_id, SUM(p.rows) AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(CASE i.[type] WHEN 2 THEN 8 * a.used_pages ELSE 0 END) AS IndexSpaceKB FROM [sys].[tables] t INNER HASH JOIN sys.indexes mainIndex ON (t.object_id = mainIndex.object_id AND mainIndex.[type] IN (0,1)) INNER HASH JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER HASH JOIN [sys].[partitions] p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER HASH JOIN [sys].[allocation_units] a ON p.partition_id = a.container_id WHERE t.is_ms_shipped = 0 AND i.OBJECT_ID > 255 GROUP BY t.Name, t.object_id, mainIndex.data_space_id ORDER BY TotalSpaceKB DESC
1376968871508675226652685SELECT [d].[ReferenceId], [d].[Tomo], COALESCE(SUM(COALESCE([d].[Folios], 0.0)), 0.0) AS [Folios], COALESCE(SUM(COALESCE([d].[Size], 0)), 0) AS [Size], MIN(COALESCE([d].[DateDocument], NULL)) AS [InitialDate], MAX(COALESCE([d].[DateDocument], NULL)) AS [EndDate], COUNT(*) AS [NumberDocuments] FROM [DMS_ReorderedDocuments] AS [d] WHERE [d].[ReferenceId] = @__referenceId_0 GROUP BY [d].[ReferenceId], [d].[Tomo]
1366918000508675110952134SELECT [d].[Id], [d].[CodeReference], [d].[CreationUser], [d].[DateDocument], [d].[EndPage], [d].[Folios], [d].[HomePage], [d].[ModificationDate], [d].[ModificationUser], [d].[Orden], [d].[ReferenceId], [d].[ReferenceRFId], [d].[RegistrationDate], [d].[Size], [d].[Tomo] FROM [DMS_ReorderedDocuments] AS [d] WHERE [d].[ReferenceId] = @__referenceId_0 ORDER BY [d].[Orden]
2459680435527674404261487SELECT TOP 10 t.NAME AS TableName, t.object_id, mainIndex.data_space_id, SUM(p.rows) AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(CASE i.[type] WHEN 2 THEN 8 * a.used_pages ELSE 0 END) AS IndexSpaceKB FROM [sys].[tables] t INNER HASH JOIN sys.indexes mainIndex ON (t.object_id = mainIndex.object_id AND mainIndex.[type] IN (0,1)) INNER HASH JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER HASH JOIN [sys].[partitions] p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER HASH JOIN [sys].[allocation_units] a ON p.partition_id = a.container_id WHERE t.is_ms_shipped = 0 AND i.OBJECT_ID > 255 GROUP BY t.Name, t.object_id, mainIndex.data_space_id ORDER BY TotalSpaceKB DESC
2766799332246351710624541SELECT EMP_CODI,CAS_CONT,SEG_CONT,FLU_CONT,ETA_CONT,SEG_UENC,SEG_ESTE,SEG_COME,SEG_SUBJ FROM WF_SEGU2 WHERE EMP_CODI = @p0 AND SEG_IPAD = @p1 AND SEG_ESTE = 'P' AND GAB_CONT NOT IN (-40,-20,-22,-53) AND AUD_UFAC < DATEADD(HOUR, -1, GETDATE()) AND SEG_FREC >= DATEADD(YEAR, -2, GETDATE())
131639140648789568492603210SELECT DISTINCT RF.IdRadicado, RF.Radicado, RF.Fecha, CN.[Name] AS 'Canal', RF.[Tipo de persona], TD.Name AS 'Tipo de identificación', CL.NumberIdentification AS 'Número de identificación', RF.Entidad, RF.Destinatario AS 'Nombres y apellidos remitente', CL.Id AS 'Id Cliente', CT.Id AS 'Id Contacto', RF.País, RF.Departamento, RF.Ciudad, RF.Dirección, RF.[Correo electrónico], RF.Asunto, RF.Folios, RFD.Attachments AS 'Número de anexos', RF.[Descripción de anexos], RF.Compañía, RF.Dependencia, CONCAT(DP.NameSolicitud, ' / ', LTRIM(RTRIM(DP.NameDetalle)), IIF(ISNULL(DP.NameEspecificacion, '0') = '0', NULL, ' / '), DP.NameEspecificacion) AS 'Trámite', RFD.UserName AS 'Usuario Radicador', RF.FuncionarioResponsable 'Responsable', 'https://tinyurl.com/5e6yz5u9' AS QR FROM GETDATABYRADICATE_VW RF INNER JOIN REQUESTFILE_VW RFD ON RFD.Id = RF.IdRadicado INNER JOIN CANAL_VW CN ON CN.Id = RFD.ChannelId INNER JOIN CLIENTS_VW CL ON CL.Id = RFD.ClientId INNER JOIN CONTACTS_VW CT ON CT.Id = RFD.ContactId INNER JOIN TypeDetail TD ON TD.Id = CL.DocumentTypeId INNER JOIN DMSProcedureNew_VW DP ON RFD.ProcedureId = DP.IdProcedure WHERE RF.Radicado = @Radicado

Estadisticas potencialmente desactualizadas

DatabaseNameSchemaNameTableNameStatisticNameLastUpdatedRowsModificationCounterModifiedPct
Stagesyssysrscols_WA_Sys_00000003_000000031/15/2024 2:59:56 PM20792833621136297.31
Stagesyssyscolpars_WA_Sys_00000007_000000299/26/2024 10:24:36 AM1891148234678389.53
DMS_2syssysrscols_WA_Sys_00000005_000000032/3/2023 12:45:16 PM263664478224460.62
DMS_2syssysrscols_WA_Sys_00000002_000000032/3/2023 12:45:16 PM263664478224460.62
DMS_2syssysrscolsclst2/3/2023 12:45:16 PM263664478224460.62
DMS_BK_20syssysrscols_WA_Sys_00000005_000000036/21/2023 4:03:31 PM304133457211002.04
DMS_BK_20syssysrscols_WA_Sys_00000002_000000036/21/2023 4:03:31 PM304133457211002.04
DMS_BK_20syssysrscolsclst6/21/2023 4:03:31 PM304133457211002.04
Stagesyssysrscols_WA_Sys_00000005_000000035/28/2025 9:59:29 AM27712618649450.16
Stagesyssysrscols_WA_Sys_00000002_000000035/28/2025 9:59:29 AM27712618639450.13
Stagesyssysrscolsclst5/28/2025 9:59:29 AM27712618639450.13
DMS_2syssysidxstats_WA_Sys_00000006_000000361/3/2023 11:26:45 AM1048672606417.94
DMS_2syssysiscols_WA_Sys_00000007_0000003710/13/2022 1:09:28 PM1131712726301.68
DMS_bk_040923syssysidxstats_WA_Sys_00000006_000000364/25/2023 12:45:14 PM1156638685524.91
DMS_BK_20syssysidxstats_WA_Sys_00000006_000000364/25/2023 12:45:14 PM1156598985181.49
DMS_BK_20syssysiscols_WA_Sys_00000007_000000376/15/2023 9:27:37 AM1500592803952.00
DMS_bk_040923syssysrscols_WA_Sys_00000005_000000038/30/2023 3:24:10 PM32721117663415.83
DMS_bk_040923syssysrscols_WA_Sys_00000002_000000038/30/2023 3:24:10 PM32721117663415.83
DMS_bk_040923syssysrscolsclst8/30/2023 3:24:10 PM32721117663415.83
DMS_BK_20syssysidxstats_WA_Sys_00000008_000000366/15/2023 9:27:36 AM1210403523334.88
DMSsyssysrscols_WA_Sys_00000005_000000035/27/2025 4:24:37 PM4016921832295.39
DMSsyssysrscols_WA_Sys_00000002_000000035/27/2025 4:24:37 PM4016921822295.37
DMSsyssysrscolsclst5/27/2025 4:24:37 PM4016921822295.37
DMS_bk_040923syssysiscols_WA_Sys_00000007_000000379/1/2023 12:45:32 AM1668232741395.32
DMS_bk_040923syssysidxstats_WA_Sys_00000008_000000369/1/2023 12:50:03 AM126211988949.92
Stagesyssysschobjs_WA_Sys_0000000B_000000226/24/2025 9:13:37 AM266920247758.60
StagedboSmartSupervisionMom2_WA_Sys_0000001B_394FC3D86/6/2026 12:51:16 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_00000037_394FC3D86/6/2026 12:51:16 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_00000038_394FC3D86/6/2026 12:51:16 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_00000036_394FC3D86/6/2026 12:51:16 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_00000019_394FC3D86/6/2026 12:51:16 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_00000011_394FC3D86/6/2026 12:51:16 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_0000001D_394FC3D86/6/2026 12:51:16 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_0000001E_394FC3D86/6/2026 12:51:16 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_00000003_394FC3D86/6/2026 12:51:15 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_00000034_394FC3D86/6/2026 12:51:15 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_00000035_394FC3D86/6/2026 12:51:15 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_00000009_394FC3D86/6/2026 12:51:15 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_0000000B_394FC3D86/6/2026 12:51:15 AM5370772148412400.02
StagedboSmartSupervisionMom2_WA_Sys_00000033_394FC3D86/6/2026 12:51:15 AM5370772148412400.02
StagedboSmartSupervisionMom2PK__SmartSup__3214EC0733D5295D6/6/2026 12:51:15 AM5370772148412400.02
StagedboSmartSupervisionMom1_WA_Sys_00000006_641AF1A36/6/2026 12:51:16 AM19797916400.00
StagedboSmartSupervisionMom1_WA_Sys_00000017_641AF1A36/6/2026 12:51:16 AM19797916400.00
StagedboSmartSupervisionMom1_WA_Sys_00000013_641AF1A36/6/2026 12:51:16 AM19797916400.00
StagedboSmartSupervisionMom1_WA_Sys_00000018_641AF1A36/6/2026 12:51:16 AM19797916400.00
StagedboSmartSupervisionMom1_WA_Sys_00000031_641AF1A36/6/2026 12:51:16 AM19797916400.00
StagedboSmartSupervisionMom1_WA_Sys_00000032_641AF1A36/6/2026 12:51:16 AM19797916400.00
StagedboSmartSupervisionMom1_WA_Sys_00000008_641AF1A36/6/2026 12:51:16 AM19797916400.00
StagedboSmartSupervisionMom1_WA_Sys_00000030_641AF1A36/6/2026 12:51:16 AM19797916400.00
StagedboSmartSupervisionMom1PK_SmartSupervisionMom16/6/2026 12:51:16 AM19797916400.00
Stagesyssysschobjs_WA_Sys_0000000A_000000226/24/2025 9:13:37 AM266910650399.03
Stagesyssysiscols_WA_Sys_00000007_000000373/2/2026 10:04:26 AM10222393234.15
Stagesyssysschobjs_WA_Sys_00000009_000000221/22/2026 9:13:35 AM26846016224.14
DMS_bk_040923syssyscolpars_WA_Sys_00000009_000000294/22/2023 12:20:04 PM27694886176.45
DMS_bk_040923syssyscolpars_WA_Sys_00000008_000000294/22/2023 12:20:04 PM27694886176.45
DMS_BK_20syssyscolpars_WA_Sys_00000009_000000294/22/2023 12:20:04 PM27694135149.33
DMS_BK_20syssyscolpars_WA_Sys_00000008_000000294/22/2023 12:20:04 PM27694135149.33
OpheliaSuitesyssysrscolsclst3/21/2025 5:30:50 PM54796788123.89
OpheliaSuitesyssysrscols_WA_Sys_00000002_000000033/21/2025 5:30:51 PM54796788123.89
OpheliaSuitesyssysrscols_WA_Sys_00000005_000000033/21/2025 5:30:51 PM54796788123.89
DMSsyssysmultiobjrefs_WA_Sys_00000006_0000004B9/23/2025 2:26:16 PM40444510111.52
DMSsyssyscolpars_WA_Sys_00000009_000000295/29/2025 10:16:23 AM41854286102.41
DMSsyssyscolpars_WA_Sys_00000008_000000295/29/2025 10:16:23 AM41854286102.41
DMSsyssyscolpars_WA_Sys_00000007_000000295/29/2025 10:16:22 AM41854286102.41
OpheliaSuitesyssyscolpars_WA_Sys_00000008_000000292/25/2020 8:54:10 AM4353328975.56
OpheliaSuitesyssyscolpars_WA_Sys_00000009_000000292/25/2020 8:54:10 AM4353328975.56
DMS_2syssysxprops_WA_Sys_00000005_0000003111/29/2022 9:05:44 PM113168060.12
AgoraSSBsyssysrscols_WA_Sys_00000005_000000031/4/2024 5:06:30 PM134074755.75
AgoraSSBsyssysrscols_WA_Sys_00000002_000000031/4/2024 5:06:30 PM134074755.75
AgoraSSBsyssysrscolsclst1/4/2024 5:06:30 PM134074755.75
DMS_2syssysidxstatsnc9/25/2023 11:29:49 PM108660055.25
DMSsyssysxprops_WA_Sys_00000004_0000003112/16/2022 3:34:50 PM121664853.29
DMSsyssysxprops_WA_Sys_00000003_0000003112/16/2022 3:34:50 PM121664853.29
DMSsyssysxprops_WA_Sys_00000002_0000003112/16/2022 3:34:51 PM121664853.29
DMSsyssysxpropsclust12/16/2022 3:34:50 PM121664853.29
DMSGDEAsyssyscolpars_WA_Sys_0000000F_000000297/13/2023 9:11:09 AM109854049.18
DMSGDEAsyssyscolpars_WA_Sys_00000004_000000297/13/2023 9:18:17 AM109854049.18
OpheliaSuitesyssyssingleobjrefsclst9/26/2023 6:00:05 AM164280549.03
OpheliaSuitesyssyssingleobjrefsnc19/26/2023 6:00:05 AM164280549.03
OpheliaSuitesyssyssingleobjrefs_WA_Sys_00000001_0000004A9/26/2023 6:00:05 AM164280549.03
OpheliaSuitesyssyssingleobjrefs_WA_Sys_00000003_0000004A9/26/2023 6:00:05 AM164280549.03
DMS_2syssyscolpars_WA_Sys_00000009_000000291/18/2023 4:33:26 PM2686130248.47
DMS_2syssyscolpars_WA_Sys_00000008_000000291/18/2023 4:33:26 PM2686130248.47
DMS_2syssyssingleobjrefs_WA_Sys_00000003_0000004A9/17/2023 12:49:38 AM158571244.92
Stagesyssysiscols_WA_Sys_00000006_000000375/27/2026 10:59:41 PM104644742.73
DMSsyssysidxstatsnc3/11/2026 5:30:39 AM200484342.07
DMSsyssysidxstatsclst3/11/2026 5:30:39 AM200484342.07
DMSsyssysidxstats_WA_Sys_00000004_000000363/11/2026 5:30:39 AM200484342.07
DMSsyssyssingleobjrefsnc15/23/2025 11:02:12 AM187677241.15
DMSsyssyssingleobjrefsclst5/23/2025 11:02:12 AM187677241.15
DMS_bk_040923syssysschobjs_WA_Sys_0000000A_0000002210/13/2022 2:11:25 PM3290132340.21
DMS_BK_20syssysschobjs_WA_Sys_0000000A_0000002210/13/2022 2:11:25 PM3290128339.00
DMS_BK_20syssysmultiobjrefs_WA_Sys_00000001_0000004B6/13/2023 6:07:37 PM170566338.89
DMS_BK_20syssysmultiobjrefs_WA_Sys_00000005_0000004B6/14/2023 8:37:17 AM170566338.89
DMS_BK_20syssysmultiobjrefs_WA_Sys_00000003_0000004B6/14/2023 8:37:17 AM170566338.89
DMS_BK_20syssysmultiobjrefsnc16/13/2023 6:07:37 PM170566338.89
DMS_BK_20syssysmultiobjrefsclst6/13/2023 6:07:37 PM170566338.89
Stagesyssyscolpars_WA_Sys_00000005_000000296/4/2026 11:48:45 AM223386838.87
Stagesyssyscolpars_WA_Sys_0000000B_000000296/4/2026 11:48:44 AM223386838.87
Stagesyssyscolpars_WA_Sys_0000000D_000000296/4/2026 11:48:45 AM223386838.87

Indices faltantes sugeridos por SQL Server

DatabaseNameSchemaNameTableNameUserSeeksUserScansAvgTotalUserCostAvgUserImpactEstimatedImpactEqualityColumnsInequalityColumnsIncludedColumns
OpheliaSuitedboWF_SEGUI29004731.9599.97137185409.64[ETA_CONT][SEG_ESTE], [AUD_UFAC]
OpheliaSuitedboWF_SEGUI16401537.3896.5024330532.30[SEG_UENC], [SEG_ESTE][FLU_CONT], [ETA_CONT], [SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI]
OpheliaSuitedboWF_SEGUI10701066.6991.7610473130.10[SEG_ESTE][SEG_UENC]
OpheliaSuitedboWF_SEGUI6101556.8596.119127358.01[FLU_CONT], [ETA_CONT], [SEG_UENC], [SEG_ESTE][SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI]
OpheliaSuitedboWF_SEGUI4901375.8588.115940072.59[FLU_CONT], [ETA_CONT], [SEG_ESTE][SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI], [SEG_UENC]
OpheliaSuitedboWF_SEGUI4401535.8778.375296096.12[SEG_ESTE][FLU_CONT], [ETA_CONT], [SEG_SUBJ], [SEG_FREC], [SEG_FLIM], [SEG_UORI], [SEG_UENC]
OpheliaSuitedboWF_SEGUI4501106.6595.394750337.04[SEG_UENC], [SEG_ESTE][FLU_CONT], [SEG_SUBJ]
OpheliaSuitedboWF_SEGUI1901080.5899.972052492.69[SEG_UENC][SEG_ESTE]
DMSdboDMS_ReorderedDocuments545034.7499.691887396.09[ReferenceId][Tomo], [DateDocument], [Folios], [Size]
DMSdboDMS_ReorderedDocuments545034.5299.811877728.20[ReferenceId][CodeReference], [Tomo], [ReferenceRFId], [DateDocument], [Orden], [Folios], [Size], [HomePage], [EndPage], [CreationUser], [RegistrationDate], [ModificationUser], [ModificationDate]
OpheliaSuitedboWF_SEGUI120952.9488.081007219.47[EMP_CODI], [FLU_CONT], [ETA_CONT][SEG_FREC], [SEG_FLIM], [SEG_ESTE][SEG_SUBJ], [SEG_UORI], [SEG_UENC]
OpheliaSuitedboWF_SEGUI801121.0096.45864962.39[SEG_UENC][SEG_ESTE][FLU_CONT]
OpheliaSuitedboWF_SEGUI90640.4480.85466017.69[SEG_ESTE][ETA_CONT]
DMSdboRequestFileHistories1201758.6113.62287427.17[Status], [ProcessCode][RequestFileId], [CreationDate]
DMSdboRequestFileHistories300136.0457.98236628.96[CreationDate][RequestFileId], [Reason], [Status]
StagedboRadicacionVentUnica60242.5399.64144992.33[PROCESO], [Tipo Comunicacion][Radicado][Fecha y Hora Radicacion]
StagedboRadicacionVentUnica60242.5398.67143580.83[PROCESO], [Tipo Comunicacion][Fecha y Hora Radicacion], [Medio de Recepcion][Radicado]
DMSdboDMS_Procedures543201.5713.69116397.13[ProcessVersion], [ProcessType][ProceduresStateId][ResponseTime], [ResponsibleUserId], [DependenciesId], [ProcedureTypeId], [NameTypeId]
DMSdboRequestFiles50392.2459.03115769.07[ChannelId][FiledDate], [OriginId][FileNumber], [Subject], [PqrsTypeId], [ExperationDate]
OpheliaSuitedboWF_SEGUI101216.9288.40107576.06[FLU_CONT], [SEG_UENC][SEG_ESTE]
DMSdboRequestFiles30277.1387.0572371.43[FileNumber][ClientId], [ProcedureId], [FiledDate], [StatusId], [Subject], [DependencyId], [UserName], [ReceiverName], [SeriesId], [SubseriesId], [OriginId], [DocumentTypeId], [ExperationDate]
OpheliaSuitedboWF_CASOS17037.8199.7264093.21[EMP_CODI], [USU_CODI][CAS_FECI][CAS_DESC], [FLU_CONT], [CAS_FLIM], [CAS_HLIM], [CAS_HORI], [CAS_FECF], [CAS_HORF], [CAS_ESTA]
OpheliaSuitedboWF_SEGUI10779.8177.2260217.23[SEG_ESTE][FLU_CONT], [ETA_CONT]
DMSdboReviewDocumentCertification97301.8433.0059136.47[State][IdDocumentCertification], [IdDetailManagePeaceAndSave], [TypeUserApproving]
DMSdboDMS_Security37804.7030.6354407.37[UserName], [ValidateUser]
DMSdboDMS_Procedures213500.6830.3743841.08[ProceduresStateId], [VisibleWeb][ResponsibleUserId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId], [ProcessVersion], [IdTheme], [IdBussinnes]
DMSdboRequestFiles10414.0799.9941402.40[ApproverName]
DMSdboRequestFiles10414.1999.7641319.57[ApproverName]
DMSdboRequestFiles10416.3199.0541235.59[ApproverName][ClientId], [ProcedureId], [FileNumber], [FiledDate], [StatusId], [Subject], [DependencyId], [ReceiverName], [SeriesId], [SubseriesId], [OriginId], [CaseId], [DocumentTypeId], [ExperationDate], [ContactId], [CollaboratorDependencyId], [VersionCCD], [VersionTRD]
DMSdboDMS_Procedures213500.6826.9138846.35[VisibleWeb][ResponsibleUserId], [ProceduresStateId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId], [ProcessVersion], [IdTheme], [IdBussinnes]
DMSdboRequestFiles6086.8772.3837725.31[StatusId], [OriginId], [ReportedSmart][ComplaintOrigin][ClientId], [FileNumber], [PqrsTypeId]
DMSdboClassificationHistories192400.2289.6737573.86[DependencyCode][SubserieCode][ClassificationHeadId], [SerieCode]
DMSdboDocumentType22903.9738.3734901.27[Version][Name], [Code]
OpheliaSuitedboWF_FETAP579600.1153.6134539.28[EMP_CODI], [PTL_CODI], [PTL_VERS]
DMSdboReviewDocumentCertification35301.1185.0833341.91[IdDocumentCertification][IdDetailManagePeaceAndSave], [IdUserApproving], [State], [CreationDate], [ModificationDate]
OpheliaSuitedboWF_SEGUI17025.1074.7131880.77[EMP_CODI], [SEG_CONA], [SEG_ESTE][FLU_CONT], [SEG_FREC]
DMSdboDMS_Procedures213800.5925.0431823.03[ProceduresStateId], [VisibleWeb][IdTheme][Name], [ResponsibleUserId], [ProcedureTypeId], [NameTypeId], [ProcessVersion], [IdBussinnes]
DMSdboRequestFiles60437.7611.8531124.86[UserName][FiledDate][FileNumber]
DMSdboRequestFiles5061.0495.3729107.80[OriginId], [VersionCCD][FiledDate][DependencyId]
DMSdboRequestFiles5061.0495.2929083.38[OriginId][FiledDate][DependencyId], [VersionCCD]
DMSdboRequestFiles60437.7610.8328445.76[FileNumber], [FiledDate][UserName]
DMSdboDMS_Procedures213800.5921.4627273.25[VisibleWeb][IdTheme][Name], [ResponsibleUserId], [ProceduresStateId], [ProcedureTypeId], [NameTypeId], [ProcessVersion], [IdBussinnes]
DMSdboRequestFiles30181.5549.7527096.32[RequestTypeId], [MassiveConsecutive][StatusId][CaseId]
OpheliaSuitedboWF_CASOS6043.2499.3725778.03[EMP_CODI], [USU_CODI][CAS_FECI], [CAS_FECF][CAS_DESC], [FLU_CONT], [CAS_FLIM], [CAS_HLIM], [CAS_HORI], [CAS_HORF], [CAS_ESTA]
StagedbopqrsdConsolidated40248.1023.3423162.21[RADICADO_RESPUESTA_FINAL], [PROCESO]
OpheliaSuitedboWF_CASOS6037.5399.7122453.59[EMP_CODI], [USU_CODI][CAS_FECF][CAS_DESC], [FLU_CONT], [CAS_FLIM], [CAS_HLIM], [CAS_FECI], [CAS_HORI], [CAS_HORF], [CAS_ESTA]
DMSdboRequestFiles5044.4094.8421056.37[FiledDate][DependencyId]
OpheliaSuitedboWF_SEGUI101351.2014.6519795.07[EMP_CODI], [FLU_CONT], [ETA_CONT], [SEG_ESTE][SEG_FREC][SEG_HREC]
DMSdboRequestFilesClients29900.7488.6919586.15[RequestFilesId][ContactId]
DMSdboRequestFiles50181.5919.4317641.88[DependencyId][FileNumber], [FiledDate][ClientId], [ProcedureId], [StatusId], [Subject], [UserName], [ReceiverName], [SeriesId], [SubseriesId], [OriginId], [DocumentTypeId], [ExperationDate]

Indices no usados o de bajo uso

DatabaseNameSchemaNameTableNameIndexNameTypeDescUserSeeksUserScansUserLookupsUserUpdates
OpheliaSuitedboWF_IRUTAIDX_NC_WF_IRUTA_002NONCLUSTERED000677660
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_010NONCLUSTERED000146664
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_004NONCLUSTERED00028552
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_002NONCLUSTERED00028538
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_001NONCLUSTERED00028304
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_002NONCLUSTERED00028304
OpheliaSuitedboWF_PROCESS_QUEUEUX_WF_PROCESS_QUEUE_IDEMPOTENCYNONCLUSTERED0008946
DMSdboCasesRelationParentAndChildDX_NC_CasesRelationParentAndChild_ChildCaseNONCLUSTERED0004297
OpheliaSuitedboWF_PROCESS_QUEUEIX_WF_PROCESS_QUEUE_CREATED_BYNONCLUSTERED0002851
DMSdboEventsIDX_NC_Events_001NONCLUSTERED0002760
DMSdboConsecutiveReferenceHistoryIDX_NC_ConsecutiveReferenceHistory_001NONCLUSTERED0002295
DMSdboReassignmentTaskIX_ReassignmentTask_RetryNONCLUSTERED0002147
DMSdboRepresentativesIDX_NC_Representatives_002NONCLUSTERED000105
DMSdboRelatedTasksHistoryIDX_NC_RelatedTasksHistory_001NONCLUSTERED00067
DMSdboDMS_MassiveProcessLogIX_DMS_MassiveProcessLog_StateNONCLUSTERED00012

Deadlocks historicos - system_health

No hay datos.

Errores recientes SQL

LogDateProcessInfoText
6/3/2026 10:34:23 AMLogonError: 18456, Severity: 14, State: 8.
6/3/2026 10:34:23 AMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.2.44]
6/2/2026 2:54:54 PMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 2:54:54 PMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.179]
6/2/2026 2:54:50 PMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 2:54:50 PMLogonLogin failed for user 'opheliadms'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.179]
6/2/2026 2:54:47 PMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 2:54:47 PMLogonLogin failed for user 'opheliadms'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.179]
6/2/2026 11:46:54 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:54 AMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159]
6/2/2026 11:46:44 AMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159]
6/2/2026 11:46:44 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:41 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:41 AMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159]
6/2/2026 11:46:21 AMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159]
6/2/2026 11:46:21 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:09 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:09 AMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159]
6/2/2026 11:46:05 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:05 AMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.159]
6/1/2026 2:42:17 PMLogonError: 18456, Severity: 14, State: 8.
6/1/2026 2:42:17 PMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.25]
6/1/2026 2:41:49 PMLogonError: 18456, Severity: 14, State: 8.
6/1/2026 2:41:49 PMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.25]
5/31/2026 6:02:58 AMspid6sWarning: Failure to calculate super-latch promotion threshold.
5/29/2026 2:58:25 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:58:25 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:58:19 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:58:19 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:58:12 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:58:12 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:58:02 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:58:02 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:56 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:57:56 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:53 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:57:53 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:49 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:57:49 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:47 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:57:47 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:46 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:57:46 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:43 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]
5/29/2026 2:57:43 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:34 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.150]
5/29/2026 2:57:34 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:19 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.151]
5/29/2026 2:57:19 AMLogonError: 18456, Severity: 14, State: 38.
5/29/2026 2:57:18 AMLogonLogin failed for user 'ophelia'. Reason: Failed to open the explicitly specified database 'OpheliaSuite'. [CLIENT: 10.238.99.153]

Tareas Ophelia en cola por servidor (estado Q)

ServidorIPCantidad
10.238.99.1501
10.238.99.1511

Indices fragmentados - todas las bases de datos (TOP 100 por impacto)

base_datosesquematablaindicetype_descfragmentacion_pctpage_counttamano_mbaccion_recomendada
OpheliaSuitedboWF_SEGUIPK_WF_SEGUICLUSTERED48.59641289850100.8REBUILD
DrivedboDRIVE_METADATAPK__DRIVE_ME__DED88B1C6A0453BFCLUSTERED90.848347196521.2REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_009NONCLUSTERED96.396593445151.1REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_002NONCLUSTERED48.2411865279269.7REBUILD
OpheliaSuitedboWF_SEGUIIN_WF_SEGUI_02NONCLUSTERED39.49142853011160.4REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_001NONCLUSTERED47.2011803269221.3REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_006NONCLUSTERED69.897607875943.6REBUILD
OpheliaSuitedboWF_LOGPLPK_WF_LOGPLCLUSTERED46.5810954128557.9REBUILD
OpheliaSuitedboWF_IRUTAPK_WF_IRUTACLUSTERED35.49133897310460.7REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_004NONCLUSTERED35.8612395909684.3REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_003NONCLUSTERED47.418948236990.8REBUILD
OpheliaSuitedboWF_IRUTAIDX_NC_WF_IRUTA_001NONCLUSTERED20.38157600212312.5REORGANIZE
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_007NONCLUSTERED37.307806126098.5REBUILD
OpheliaSuitedboWF_IRUTAIDX_NC_WF_IRUTA_002NONCLUSTERED23.3711249948789.0REORGANIZE
DMSdboDMS_IndexesPK__DMS_Inde__3214EC0764BB43FACLUSTERED45.805577534357.4REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_010NONCLUSTERED95.032268251772.1REBUILD
DrivedboDRIVE_METADATAIX_DRIVE_METADATA_FolderCodeNONCLUSTERED86.632377961857.8REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_002NONCLUSTERED82.042451711915.4REBUILD
DrivedboDRIVE_METADATAUQ__DRIVE_ME__6F0F98BEF15CEBCCNONCLUSTERED71.462304591800.5REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_008NONCLUSTERED10.47155445312144.2REORGANIZE
DrivedboDRIVE_FOLDERPK__DRIVE_FO__DED88B1C73D9DEFECLUSTERED93.191602271251.8REBUILD
OpheliaSuitedboWF_SEGUIIN_WF_SEGUI_01NONCLUSTERED6.65218939117104.6NO ACCION
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_003NONCLUSTERED65.251296761013.1REBUILD
DMSdboRequestEmailPK__tmp_ms_x__3214EC0709EC20FCCLUSTERED34.892206491723.8REBUILD
OpheliaSuitedboWF_FPLANUQ_WF_FPLAN_001NONCLUSTERED32.912124801660.0REBUILD
DMSdboPQRSDWebProcessLogPK__PQRSDWeb__3214EC07598FFB3BCLUSTERED20.193298332576.8REORGANIZE
OpheliaSuitedboWF_FPLANIDX_NC_WF_FPLAN_001NONCLUSTERED22.992565772004.5REORGANIZE
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_004NONCLUSTERED95.0459221462.7REBUILD
DrivedboDRIVE_FOLDERIX_DRIVE_FOLDER_CodeNONCLUSTERED94.9759179462.3REBUILD
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_001NONCLUSTERED45.91113883889.7REBUILD
OpheliaSuitedboWF_FPLANPK_WF_FPLANCLUSTERED11.133956403090.9REORGANIZE
DMSdboDMS_ReorderedDocumentsPK_DMS_ReorderedDocumentsCLUSTERED75.5150634395.6REBUILD
DrivedboDRIVE_FOLDERUQ__DRIVE_FO__A25C5AA750312A26NONCLUSTERED74.5742489331.9REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_005NONCLUSTERED24.19113254884.8REORGANIZE
OpheliaSuitedboWF_FPLANIDX_NC_WF_FPLAN_002NONCLUSTERED8.383073582401.2NO ACCION
DMSdboReferencesRequestFileIDX_NC_ReferencesRequestFile_00NONCLUSTERED28.8984599660.9REORGANIZE
DMSdboReferencesRequestFilePK_ReferencesRequestFileCLUSTERED24.7388105688.3REORGANIZE
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_003NONCLUSTERED34.7057525449.4REBUILD
DMSdboRequestFilesPK__tmp_ms_x__3214EC077390A34DCLUSTERED3.085616324387.8NO ACCION
OpheliaSuitedboWF_VBPERPK_WF_VBPERCLUSTERED48.2934964273.2REBUILD
DMSdboRequestFilesIDX_NC_RequestFiles_012NONCLUSTERED22.0869438542.5REORGANIZE
DMSdboRadicadeHistoryPK__tmp_ms_x__3214EC078C329747CLUSTERED26.8848303377.4REORGANIZE
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_005NONCLUSTERED7.591598891249.1NO ACCION
DMSdboDMS_ReorderedDocumentsIX_DMS_ReorderedDocuments_001NONCLUSTERED47.8524094188.2REBUILD
DMSdboManagePeaceAndSaveDetailScopePK_ManagePeaceAndSaveDetailScopeCLUSTERED23.1947378370.1REORGANIZE
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_005NONCLUSTERED25.8536901288.3REORGANIZE
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_011NONCLUSTERED14.7254095422.6REORGANIZE
DMSdboDMS_IndexesIDX_NC_DMS_Indexes_002NONCLUSTERED17.8444388346.8REORGANIZE
DMSdboReferencesRequestFileIDX_NC_ReferencesRequestFile_002NONCLUSTERED48.3515468120.8REBUILD
DMSdboContactsPK__Contacts__3214EC07786292A4CLUSTERED13.9952598410.9REORGANIZE
DMSdboRequestEmailIDX_RequestEmailV_DateAffairSenderNONCLUSTERED30.7023889186.6REBUILD
DMSdboDMS_IndexesIDX_NC_DMS_Indexes_001NONCLUSTERED22.7329828233.0REORGANIZE
DMSdboRequestFilesIDX_NC_RequestFiles_006NONCLUSTERED19.0935186274.9REORGANIZE
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_002NONCLUSTERED19.0535053273.9REORGANIZE
DMSdboDMS_ReferencesIDX_NC_DMS_References_007NONCLUSTERED48.571222195.5REBUILD
DMSdboRequestFilesIDX_NC_RequestFiles_004NONCLUSTERED12.4845480355.3REORGANIZE
DMSdboRequestFilesIDX_NC_RequestFiles_015NONCLUSTERED31.5217821139.2REBUILD
DMSdboRequestFilesIDX_NC_RequestFiles_013NONCLUSTERED28.5317724138.5REORGANIZE
OpheliaSuitedboWF_ICOMPPK_WF_ICOMPCLUSTERED4.49100480785.0NO ACCION
DMSdboRequestFilesStampedIDX_NC_RequestFilesStamped_001NONCLUSTERED25.2516650130.1REORGANIZE
StagedboRequestFilesExpirationDateidx_nc_RequestFilesExpirationDate_001NONCLUSTERED45.61876468.5REBUILD
OpheliaSuitedboWF_RCPROIN_WF_RCPRO_01NONCLUSTERED9.6140894319.5NO ACCION
DMSdboRadicadeHistoryIDX_NC_RadicadeHistory_002NONCLUSTERED28.2913622106.4REORGANIZE
DMSdboGeneralErrorsLogPK__GeneralE__3214EC07DE39B021CLUSTERED12.2630765240.4REORGANIZE
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_002NONCLUSTERED14.8424757193.4REORGANIZE
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_002NONCLUSTERED9.1939885311.6NO ACCION
DMSdboRequestFilesDX_NC_RequestFiles_002NONCLUSTERED27.3813125102.5REORGANIZE
DMSdboRadicadeHistoryIDX_NC_RadicadeHistory_001NONCLUSTERED15.6722460175.5REORGANIZE
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_001NONCLUSTERED8.4640727318.2NO ACCION
DMSdboRequestFilesIX_RequestFiles_MassiveConsecutiveNONCLUSTERED34.42982176.7REBUILD
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_001NONCLUSTERED14.3122605176.6REORGANIZE
DMSdboRadicadeHistoryIDX_NC_RadicadeHistory_003NONCLUSTERED34.63908170.9REBUILD
OpheliaSuitedboWF_RCPROPK_WF_RCPROCLUSTERED4.7065284510.0NO ACCION
DMSdboEventsPK__Events__3214EC07909701EDCLUSTERED31.90959374.9REBUILD
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_003NONCLUSTERED7.4839755310.6NO ACCION
DMSdboRepresentativesPK_RepresentativesCLUSTERED45.16655051.2REBUILD
DMSdboRequestFilesIX_RequestFiles_FiledDateNONCLUSTERED26.881092485.3REORGANIZE
DMSdboSmartReportedComplaintFilesPK__SmartRep__3214EC07AFE49E42CLUSTERED45.03512340.0REBUILD
DrivedboFILE_METADATAPK_FILE_METADATACLUSTERED99.22229517.9REBUILD
DMSdboDMS_ReferencesPK__tmp_ms_x__3214EC0766F9A7BBCLUSTERED14.0716036125.3REORGANIZE
DMSdboRepresentativesIDX_NC_Representatives_003NONCLUSTERED37.67584045.6REBUILD
OpheliaSuitedboWF_CASOSPK_WF_CASOSCLUSTERED1.171741601360.6NO ACCION
DMSdboDMS_ReferencesSummaryPK_DMS_ReferencesSummaryCLUSTERED50.95372129.1REBUILD
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_001NONCLUSTERED0.433797902967.1NO ACCION
DMSdboSmartProcessLogPK__SmartPro__3214EC07387BAEFFCLUSTERED46.94336426.3REBUILD
DMSdboDMS_ReferencesIDX_NC_DMS_References_009NONCLUSTERED42.07372529.1REBUILD
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_004NONCLUSTERED0.851800801406.9NO ACCION
DMSdboCopiesCommunicationIDX_NC_CopiesCommunication_001NONCLUSTERED29.34521240.7REORGANIZE
DMSdboManagePeaceAndSaveDetailScopeIDX_NC_ManagePeaceAndSaveDetailScope_001NONCLUSTERED5.2128316221.2NO ACCION
DMSdboClientsPK__Clients__3214EC075B672D4ACLUSTERED5.3625935202.6NO ACCION
DMSdboRequestFileHistoriesPK__RequestF__3214EC07B438AE64CLUSTERED0.363613362822.9NO ACCION
DMSdboContactsIDX_NC_Contacts_001NONCLUSTERED15.50672752.6REORGANIZE
DMSdboRepresentativesIDX_NC_Representatives_001NONCLUSTERED27.64367228.7REORGANIZE
DMSdboRequestFilesIDX_NC_RequestFiles_016NONCLUSTERED5.3417389135.9NO ACCION
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_002NONCLUSTERED0.452041401594.8NO ACCION
DMSGDEAdboDIMRADICACIONPk_RadicacionCLUSTERED48.76184814.4REBUILD
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_006NONCLUSTERED0.471793961401.5NO ACCION
DMSdboPQRSDWebProcessLogIX_PQRSDWebProcessLog_BeginQueueNONCLUSTERED17.77445734.8REORGANIZE
OpheliaSuitedboWF_PROCESS_QUEUEPK_WF_PROCESS_QUEUECLUSTERED0.6875046586.3NO ACCION
OpheliaSuitedboWF_DEVOLPK_WF_DEVOLCLUSTERED33.9711078.6REBUILD

Guía de mantenimiento de índices

CondiciónAcciónComentario
Fragmentación menor a 10%NO ACCIÓNNo justifica mantenimiento.
Fragmentación entre 10% y 30% y page_count >= 1000REORGANIZEOperación más liviana, normalmente online.
Fragmentación mayor o igual a 30% y page_count >= 1000REBUILDProgramar en ventana. Validar edición, espacio en disco, TempDB y log.
Índice pequeño con page_count menor a 1000NO ACCIÓNLa fragmentación en índices pequeños suele ser ruido.

Nota: para índices grandes como PK_WF_SEGUI, si el resultado recomienda REBUILD, no ejecutarlo en hora pico. Revisar espacio libre, TempDB, transaction log y si la edición permite ONLINE = ON.