Diagnóstico SQL Server - DWSGDASQL2

Resumen Ejecutivo SQL

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

Servidor SQL: SRVCLSGDEA\SGDEAPRY,1633

Host: DWSGDASQL2

Fecha: 06/06/2026 10:05:35

Recomendaciones

Alertas consolidadas

Información del sistema

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

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.0767.49
D:TEMP299.9878.5726.19
E:DATA5222.38684.2613.1
F:LOG299.98290.9796.99
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 time7.3230.511.73
\\dwsgdasql2\memory\available mbytes760776567644.67
\\dwsgdasql2\system\processor queue length000
\\dwsgdasql2\physicaldisk(_total)\% disk time8.3410.069
\\dwsgdasql2\physicaldisk(_total)\current disk queue length020.67

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
614394499945000176312294

Bases de datos

DatabaseNameStateRecoveryModelCompatibilityLevelSizeMBCreateDate
OpheliaSuiteONLINEFULL15044946101/25/2023 11:42:38 AM
tempdbONLINESIMPLE1502243785/29/2026 2:36:28 AM
DMSONLINEFULL150971573/9/2024 11:45:05 PM
DriveONLINEFULL1503476411/9/2023 7:00:50 PM
StageONLINEFULL150115945/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
MicroSQLDWSGDAAPP2ophelia137
MicroSQLDWSGDAAPP3ophelia134
MicroSQLDWSGDAAPP1ophelia117
MicroSQLDWSGDAAPP1opheliadms22
MicroSQLDWSGDAAPP4opheliadms8
ODKDWSGDAAPP1ophelia6
MicroSQLDWSGDAAPP3opheliadms6
ODKDWSGDAAPP3ophelia6
ODKDWSGDAAPP2ophelia5
MicroSQLDWSGDAAPP2opheliadms5
.Net SqlClient Data ProviderFASECOLDAVMmonitoreosaas5
Core Microsoft SqlClient Data ProviderDWSGDAAPP2opheliadms4
Core Microsoft SqlClient Data ProviderDWSGDAAPP1ophelia3
Core Microsoft SqlClient Data ProviderDWSGDAAPP1opheliadms3
Core Microsoft SqlClient Data ProviderDWSGDAAPP2ophelia3
Core Microsoft SqlClient Data ProviderDWSGDAAPP3opheliadms3
Core .Net SqlClient Data ProviderDWSGDAAPP2ophelia2
Core .Net SqlClient Data ProviderDWSGDAAPP3ophelia2
Core Microsoft SqlClient Data ProviderDWSGDAAPP3ophelia2
Microsoft SQL Server Management StudioDWSGDASQL2DIGITALWARE\DominnigM2
Microsoft® Windows® Operating SystemDWSGDASQL2NT AUTHORITY\SYSTEM1
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 .Net SqlClient Data ProviderDWSGDAAPP1ophelia1
DWSGDAAPP1ophelia1
.Net SqlClient Data ProviderDWSGDASQL2ophelia1
Core Microsoft SqlClient Data ProviderDWSGDAAPP4ophelia1
Core Microsoft SqlClient Data ProviderDWSGDAMON2opheliadms1
EFCore/10.0.3 (Microsoft Windows 10.0.17763 X64)DWSGDAAPP1ophelia1
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

Sesiones activas

session_idlogin_namehost_nameprogram_namestatuscommandwait_typewait_timecpu_timelogical_readsDatabaseName
51NT AUTHORITY\SYSTEMDWSGDASQL2Microsoft® Windows® Operating SystemrunningEXECUTESP_SERVER_DIAGNOSTICS_SLEEP17837633master
506opheliaDWSGDASQL2.Net SqlClient Data ProviderrunningSELECT020master

Bloqueos activos

No hay datos.

Transacciones abiertas (> 5 seg)

SessionIdHostAplicacionUsuarioInicioTransaccionSegundosAbiertaTipoTransaccionUltimaConsulta
322DWSGDAAPP3MicroSQLophelia6/5/2026 3:12:16 PM67741Read/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 PM67552Read/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 PM67531Read/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 PM67223Read/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 PM67223Read/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 PM67129Read/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 PM67077Read/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 PM66896Read/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 PM66601Read/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 PM66495Read/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 PM66262Read/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 PM66262Read/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 PM66199Read/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 PM66082Read/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 PM65924Read/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 PM65528Read/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 PM65409Read/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 PM65342Read/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 PM65122Read/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 PM65117Read/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 PM64989Read/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 PM64757Read/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 PM64415Read/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 PM64289Read/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 PM63965Read/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 PM63869Read/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 PM63799Read/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 PM63614Read/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 PM63592Read/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 PM63465Read/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 PM63330Read/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 PM63242Read/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 PM62987Read/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 PM62689Read/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 PM62432Read/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 PM62378Read/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 PM62138Read/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 PM61856Read/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 PM61500Read/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 PM61305Read/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 PM61182Read/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 PM59231Read/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 PM59003Read/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 PM58733Read/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 PM58070Read/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 PM58025Read/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 PM57162Read/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 PM42070Read/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 AM7011Read/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 AM6252Read/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 AM5877Read/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 AM5840Read/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 AM5532Read/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 AM5146Read/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 AM4132Read/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 AM3958Read/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 AM3944Read/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 AM3944Read/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 AM3687Read/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 AM3382Read/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 AM2848Read/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 AM2664Read/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 AM2664Read/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 AM2623Read/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 AM2434Read/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 AM1286Read/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 AM1040Read/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 AM1020Read/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 AM823Read/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 AM721Read/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 AM531Read/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 AM433Read/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 AM334Read/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 AM333Read/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 AM235Read/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)

Wait Stats

wait_typewaiting_tasks_countwait_time_msAvgWaitMssignal_wait_time_ms
SOS_WORK_DISPATCHER11259732591195422959809.0053284722
CXPACKET15515904713936445178.0039851207
CXCONSUMER29328035011880172254.0078268934
ASYNC_NETWORK_IO1269307416596789013.004124617
PAGEIOLATCH_SH1022749041566524171.005569148
SOS_SCHEDULER_YIELD1434106621275904730.00127288717
BACKUPBUFFER9689080870432428.005256438
PREEMPTIVE_XE_DISPATCHER68579484114299140.000
LCK_M_IS40318101197420097.003491
BPSORT15971090576882863.007296798
BACKUPIO33988615537925416.001309216
ASYNC_IO_COMPLETION5913715969862875.00131
LATCH_EX9725875242238412.004679384
LCK_M_IX22312384791310689.003310
PAGEIOLATCH_EX5323012187921133.00550083
WRITELOG3600163158261504.001797043
LCK_M_X3969152122633832.008827
PARALLEL_REDO_WORKER_WAIT_WORK1690398108029516.0021139
LCK_M_SCH_S966978334110127.001194
RESERVED_MEMORY_ALLOCATION_EXT327741744191471010.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
168333271619837904529135484084SELECT [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
2376207090687123404943108SELECT 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'
239099257941512568831125601SELECT 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
108877216576675576498777751SELECT 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]
7732844642653516023758918SELECT 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
119612912302444511933331SELECT 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'
128652228652212239137369815INSERT 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'
119072828822329676212907188SELECT COUNT(*) FROM [ReassignmentTask] AS [r] WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0
23852706931132792283197379SELECT 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
12421532421532264458199952SELECT * FROM dbo.V_RPTG_Radicados WHERE Radicado <> '0'
14003212746152217077198846SELECT 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)
14212208910142197237391529SELECT 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]
2390205799862710958201WITH 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
3095517988352166644331SELECT 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
23901758187321343549054SELECT * 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
10161256161258768338778915select 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
329159513884301396436579220SELECT COUNT(*) FROM GN_DIASN WHERE CCA_CONT= @ AND DIA_NOTR > @_1 AND DIA_NOTR <= @_2
72712016516514155344604396SELECT 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
39115012294933352134185SELECT FORMAT(RF.FiledDate, 'dd-MM-yyyy HH:mm') AS 'Fecha radicado' , RF.FileNumber AS 'Radicado' , RF.[Subject] AS 'Asunto' FROM [dbo].[REQUESTFILE_VW] RF INNER JOIN [dbo].[CLIENTS_VW] C ON C.Id = RF.ClientId WHERE C.NumberIdentification = @NIdentification ORDER BY Radicado DESC

Archivos SQL más pesados

DatabaseNameLogicalNamePhysicalNameFileTypeSizeMBMaxSizeMBIsPercentGrowth
OpheliaSuiteOpheliaSuiteDMSE:\SGDEA\OpheliaSuite.mdfROWS4491718-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.ldfLOG28912097152False
DMS_BK_20DMSE:\SGDEA\DMS_BK_20.mdfROWS2184-1False
DMSDMS_logF:\LOG\DMS_log.ldfLOG17392097152False
StageStage_logF:\LOG\Stage_log.ldfLOG7792097152False
AgoraSSBAgoraE:\SGDEA\Agora.mdfROWS436-1False

Volumenes fisicos SQL

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

Uso interno de archivos por base

DatabaseNameLogicalNameFileTypePhysicalNameSizeGBUsedGBFreeInternalGBUsedPctGrowthConfigMaxSizeGB
OpheliaSuiteOpheliaSuiteDMSROWSE:\SGDEA\OpheliaSuite.mdf4386.444385.041.4099.9764.000000 MBSin limite
OpheliaSuiteOpheliaSuiteDMS_logLOGF:\LOG\OpheliaSuite_log.ldf2.822.820.0099.8364.000000 MB2048.00 GB
AgoraSSBAgoraROWSE:\SGDEA\Agora.mdf0.430.410.0296.3564.000000 MBSin limite
DMSDMSROWSE:\SGDEA\DMS.mdf50.8048.412.3895.3164.000000 MBSin limite
DMSDMS_BROWSE:\SGDEA\DMS_B.ndf42.3840.401.9995.3164.000000 MBSin limite
DMSDMS_logLOGF:\LOG\DMS_log.ldf1.821.710.1193.9264.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
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
StageStage_logLOGF:\LOG\Stage_log.ldf0.760.570.2074.2264.000000 MB2048.00 GB
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.0364.000000 MB2048.00 GB
DriveDrive_logLOGF:\LOG\Drive_log.ldf0.270.070.2026.3464.000000 MB2048.00 GB
DWMaintenanceDWMaintenance_logLOGE:\DATA\MSSQL15.SGDEAPRY\MSSQL\DATA\DWMaintenance_log0.010.000.0116.7764.000000 MB2048.00 GB
DMS_bk_040923DMS_logLOGF:\LOG\DMS_bk_040923_log.ldf0.010.000.0115.3864.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.2064.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
OpheliaSuite2.8299.830
DMS1.8293.920
Stage0.7674.220
msdb0.0063.090
ProcessTable0.0157.370
master0.0057.080
model0.0732.090
DMS_BK_200.0131.070
Drive0.2726.340
DWMaintenance0.0116.830
DMS_bk_0409230.0115.420
DMS_20.0112.930
Calendario0.009.990
EstructuraImportacion0.108.480
AgoraSSB0.108.210
ImperiumReportCache0.107.070
DMSGDEA0.026.310
DBA0.072.710
AgoraSSB_OLD0.071.810
tempdb0.871.220

Autogrowths recientes - 7 dias

EventNameDatabaseNameFileNameStartTimeDurationMsGrowthMBHostNameApplicationNameLoginName
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
Log File Auto GrowDMSDMS_log6/6/2026 12:44:46 AM114.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:45 AM103.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:38 AM127.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:31 AM106.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:26 AM106.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:23 AM114.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:21 AM107.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:17 AM113.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:17 AM143.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:16 AM113.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowDMSDMS_log6/6/2026 12:44:16 AM154.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:43:55 AM106.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:43:36 AM107.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:43:20 AM97.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:43:01 AM103.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:42:53 AM103.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:42:48 AM116.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:42:43 AM120.0064.00SRVCLSGDEASQLAgent - TSQL JobStep (Job 0x20A3B74AE9C9A0468EACCDDC5A51DDF2 : Step 1)DIGITALWARE\SCVSGDA-AGENT
Log File Auto GrowOpheliaSuiteOpheliaSuiteDMS_log6/6/2026 12:42:38 AM103.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 AM1546/6/2026 12:30:33 AM
AgoraSSB_OLDFULL5/31/2026 12:32:12 AM1546/6/2026 12:30:36 AM
CalendarioFULL5/31/2026 12:32:14 AM1546/6/2026 12:30:38 AM
DBAFULL5/31/2026 12:32:17 AM1546/6/2026 12:30:41 AM
DMSFULL5/31/2026 12:49:35 AM1546/6/2026 12:32:06 AM
DMS_2FULL5/31/2026 12:49:42 AM1546/6/2026 12:32:08 AM
DMS_bk_040923FULL5/31/2026 12:50:20 AM1546/6/2026 12:32:10 AM
DMS_BK_20FULL5/31/2026 12:50:40 AM1546/6/2026 12:32:11 AM
DMSGDEAFULL5/31/2026 12:50:42 AM1546/6/2026 12:32:13 AM
DriveFULL5/31/2026 12:55:44 AM1546/6/2026 12:33:03 AM
DWMaintenanceFULL5/31/2026 12:55:46 AM1546/6/2026 12:33:06 AM
EstructuraImportacionFULL5/31/2026 12:55:48 AM1546/6/2026 12:33:08 AM
ImperiumReportCacheFULL5/31/2026 12:55:50 AM1546/6/2026 12:33:10 AM
OpheliaSuiteFULL5/31/2026 8:38:16 AM1466/6/2026 12:39:33 AM
ProcessTableFULL5/31/2026 8:38:19 AM1466/6/2026 12:39:35 AM
StageFULL5/31/2026 8:38:42 AM1466/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.9410.98882.961.2364.000000000000 MB
temp10ROWSD:\TEMPDB\temp10.mdf30709.251362.2529347.004.4464.000000000000 MB
temp11ROWSD:\TEMPDB\temp11.mdf13169.50682.8112486.695.1864.000000000000 MB
temp2ROWSD:\TEMPDB\temp2.mdf250.009.75240.253.9064.000000000000 MB
temp3ROWSD:\TEMPDB\temp3.mdf300.009.81290.193.2764.000000000000 MB
temp4ROWSD:\TEMPDB\temp4.mdf21358.131248.6320109.505.8564.000000000000 MB
temp5ROWSD:\TEMPDB\temp5.mdf30735.751270.3129465.444.1364.000000000000 MB
temp6ROWSD:\TEMPDB\temp6.mdf31071.811255.4429816.384.0464.000000000000 MB
temp7ROWSD:\TEMPDB\temp7.mdf30755.941280.1929475.754.1664.000000000000 MB
temp8ROWSD:\TEMPDB\temp8.mdf29267.191257.0628010.134.3064.000000000000 MB
temp9ROWSD:\TEMPDB\temp9.mdf23991.001252.3822738.635.2264.000000000000 MB
tempdevROWSD:\TEMPDB\tempdev.mdf12644.19627.9412016.254.9764.000000000000 MB

TempDB - consumidores principales

SessionIdLoginNameHostNameProgramNameDatabaseNamestatuscommandTempdbAllocatedMBTempdbDeallocatedMBQueryText
705opheliaDWSGDAAPP1Core .Net SqlClient Data Provider3.693.88
85DIGITALWARE\SCVSGDA-AGENTSRVCLSGDEASQLAgent - Generic Refresher1.190.69
502monitoreosaasFASECOLDAVM.Net SqlClient Data Provider0.440.44
518opheliadmsDWSGDAAPP1Core Microsoft SqlClient Data Provider0.060.06
379opheliadmsDWSGDAAPP3Core Microsoft SqlClient Data Provider0.060.06
168DIGITALWARE\DominnigMDWSGDASQL2Microsoft SQL Server Management Studio0.060.06
169opheliaDWSGDAAPP2MicroSQL0.000.00
170opheliaDWSGDAAPP2MicroSQL0.000.00
171opheliaDWSGDAAPP2MicroSQL0.000.00
172opheliaDWSGDAAPP2MicroSQL0.000.00
173opheliaDWSGDAAPP2MicroSQL0.000.00
174opheliaDWSGDAAPP2ODK0.000.00
175opheliaDWSGDAAPP3MicroSQL0.000.00
176opheliaDWSGDAAPP1MicroSQL0.000.00
177opheliaDWSGDAAPP2MicroSQL0.000.00
178opheliaDWSGDAAPP2MicroSQL0.000.00
179opheliaDWSGDAAPP2MicroSQL0.000.00
180opheliaDWSGDAAPP3MicroSQL0.000.00
181opheliaDWSGDAAPP2MicroSQL0.000.00
182opheliadmsDWSGDAAPP1MicroSQL0.000.00
183opheliaDWSGDAAPP3MicroSQL0.000.00
184opheliaDWSGDAAPP3MicroSQL0.000.00
185opheliaDWSGDAAPP3ODK0.000.00
186opheliaDWSGDAAPP1MicroSQL0.000.00
187opheliadmsDWSGDAAPP1MicroSQL0.000.00
188opheliaDWSGDAAPP1MicroSQL0.000.00
189opheliaDWSGDAAPP2MicroSQL0.000.00
190opheliadmsDWSGDAAPP1MicroSQL0.000.00
191opheliaDWSGDAAPP1MicroSQL0.000.00
192opheliadmsDWSGDAAPP1MicroSQL0.000.00

Top Queries Logical Reads

ExecutionsTotalLogicalReadsAvgLogicalReadsCPUTimeMsElapsedMsDatabaseNameQueryText
1681354840848064523332716904529SELECT [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
10970995308109073727640762452SELECT 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]
7274460439661354120165141553SELECT 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
1038778915387789116125687683select 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
13736981537369815286522122391StageINSERT 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
11990129971601084285014299138SELECT COUNT(*) FROM [ReassignmentTask] AS [r] WHERE [r].[Status] = N'Processing' AND [r].[ProcessingServer] = @__serverIp_0
23861118889746895978279635SELECT 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
56935810413884188400784426SELECT 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
181999528199952242153226445SELECT * FROM dbo.V_RPTG_Radicados WHERE Radicado <> '0'
143627469679520211277222271SELECT 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]
141537276096514215215224359SELECT 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)
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]
369542602318086180499158352DMSSELECT 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
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]
2390690408328884593356594SELECT 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
2390663302827754321660535SELECT 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
330073465974601139325140127SELECT COUNT(*) FROM GN_DIASN WHERE CCA_CONT= @ AND DIA_NOTR > @_1 AND DIA_NOTR <= @_2
2390603746925263682349258SELECT 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
1545777254577722153315064StageINSERT INTO [dbo].[SmartSupervisionMom1] (RADICADO_SFC_FIDUGESTOR, TIPO_DE_PQR, RADICADO_FIDUGESTOR, FECHA_RADICADO_RECIBIDO, HORA_RADICADO_RECIBIDO, MES_AÑO, CLASIFICACION_SFC_PRODUCTO, CANAL, MACROMOTIVO, USUARIO_ACTUAL, DEPENDENCIA_ACTUAL, FUNCIONARIO_QUE_RESPONDE, DEPENDENCIA_QUE_RESPONDE, ESTADO_SFC_MOMENTO_1, ESTADO_DE_LA_TRASMISION, FECHA_DE_TRASMISION, TIPO_DE_ERROR, FECHA_DE_LA_GESTION, TIPO_DE_RESPUESTA, RADICADO_DE_RESPUESTA_MOMENTO_3, FECHA_DE_RESPUESTA, HORA_DE_RESPUESTA, SE_ENVIO_MOMENTO_3, TIPO_DE_ERROR_MOMENTO_3, ENTE_DE_CONTROL, ESCALAMIENTO_AL_DEFENSOR_DEL_CONSUMIDOR, QUEJA_EXPRES, REPLICA, FECHA_DE_TRASMISION_MOMENTO_3, ESTADO_DE_LA_QUEJA_O_RECLAMO, PROCEDENTE, FAVORABILIDAD, A_FAVOR_DE, INADMITIDA_O_RECHAZADA_POR_LA_ENTIDAD, TRASLADO_A_LA_SUPERINTENDENCIA, ACEPTACION, RECTIFICACION, DESISTIMIENTO, REMITENTE, TIPO_DE_SOLICITUD, DETALLE_DE_LA_SOLICITUD, ESPECIFICACION_DE_LA_SOLICITUD, AFILIADO_AL_FOMAG, TIPO_DE_AFILIADO, ASUNTO, ACTUALIZO_MOMENTO_4, FECHA_ACTUALIZACION, AÑO_FIL, MES_FIL, DEPENDENCIA_FIL, RN, [TIPO_DE_FRAUDE], [MODALIDAD_DE_FRAUDE], [MONTO_RECLAMADO], [MONTO_RECONOCIDO]) --CONSULTA PRINCIPAL SELECT [RADICADO_SFC_FIDUGESTOR] ,[TIPO_DE_PQR] ,[RADICADO_FIDUGESTOR] ,[FECHA_RADICADO_RECIBIDO] ,[HORA_RADICADO_RECIBIDO] ,[MES_AÑO] ,[CLASIFICACION_SFC_PRODUCTO] ,[CANAL] ,[MACROMOTIVO] ,[USUARIO_ACTUAL] ,[DEPENDENCIA_ACTUAL] ,[FUNCIONARIO_QUE_RESPONDE] ,[DEPENDENCIA_QUE_RESPONDE] ,[ESTADO_SFC_MOMENTO_1] ,[ESTADO_DE_LA_TRASMISION] ,[FECHA_DE_TRASMISION] ,[TIPO_DE_ERROR] ,[FECHA_DE_LA_GESTION] ,[TIPO_DE_RESPUESTA] ,[RADICADO_DE_RESPUESTA_MOMENTO_3] ,[FECHA_DE_RESPUESTA] ,[HORA_DE_RESPUESTA] ,[SE_ENVIO_MOMENTO_3] ,[TIPO_DE_ERROR_MOMENTO_3] ,[ENTE_DE_CONTROL] ,[ESCALAMIENTO_AL_DEFENSOR_DEL_CONSUMIDOR] ,[QUEJA_EXPRES] ,[REPLICA] ,[FECHA_DE_TRASMISION_MOMENTO_3] ,[ESTADO_DE_LA_QUEJA_O_RECLAMO] ,[PROCEDENTE] ,[FAVORABILIDAD] ,[A_FAVOR_DE] ,[INADMITIDA_O_RECHAZADA_POR_LA_ENTIDAD] ,[TRASLADO_A_LA_SUPERINTENDENCIA] ,[ACEPTACION] ,[RECTIFICACION] ,[DESISTIMIENTO] ,[REMITENTE] ,[TIPO_DE_SOLICITUD] ,[DETALLE_DE_LA_SOLICITUD] ,[ESPECIFICACION_DE_LA_SOLICITUD] ,[AFILIADO_AL_FOMAG] ,[TIPO_DE_AFILIADO] ,[ASUNTO] ,[ACTUALIZO_MOMENTO_4] ,[FECHA_ACTUALIZACION] ,[AÑO_FIL] ,[MES_FIL] ,[DEPENDENCIA_FIL] ,[RN] ,[TIPO_DE_FRAUDE] ,[MODALIDAD_DE_FRAUDE] ,[MONTO_RECLAMADO] ,[MONTO_RECONOCIDO] FROM ( SELECT SmartAddicionalRequestFiles.ComplaintCode [RADICADO_SFC_FIDUGESTOR] ,PqrsType.Name [TIPO_DE_PQR] ,RequestFiles.FileNumber [RADICADO_FIDUGESTOR] ,CONVERT(VARCHAR,CONVERT(DATE,SmartAddicionalRequestFiles.CreationDate)) [FECHA_RADICADO_RECIBIDO] ,RIGHT( CONVERT(DATETIME, SmartAddicionalRequestFiles.CreationDate, 108),8) [HORA_RADICADO_RECIBIDO] ,CONCAT(DATENAME (MONTH, DATEADD(MONTH, MONTH(SmartAddicionalRequestFiles.CreationDate) - 1, '1900-01-01')),' - ',YEAR(SmartAddicionalRequestFiles.CreationDate)) [MES_AÑO] ,producto.Name [CLASIFICACION_SFC_PRODUCTO] ,canalpqr.Name [CANAL] ,Motivo.Name [MACROMOTIVO] ,CONCAT(Users.Name,' ', Users.Surnames ) [USUARIO_ACTUAL] ,Dependencies.Name [DEPENDENCIA_ACTUAL] ,Dependencies.Name [DEPENDENCIA_QUE_RESPONDE] --,CAST(COALESCE(Dependencies4.Name, Dependencies.Name, Dependencies3.Name, CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(100)) AS [DEPENDENCIA_QUE_RESPONDE] ,CAST(IIF(CONCAT(Users.Name, ' ', Users.Surnames) = '', CONCAT(Users1.Name, ' ', Users1.Surnames), CONCAT(Users.Name, ' ', Users.Surnames)) AS VARCHAR(50)) AS [FUNCIONARIO_QUE_RESPONDE] ,'Recibida' [ESTADO_SFC_MOMENTO_1] ,CASE WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN 'Enviada' ELSE 'No Enviada' END [ESTADO_DE_LA_TRASMISION] ,CASE WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN CONVERT(VARCHAR,CONVERT(DATE,smartprocesslog.RegistrationDate)) END [FECHA_DE_TRASMISION] ,CASE WHEN smartprocesslog.Status IN ('FINALIZADO','EXITOSO') THEN 'N/A' WHEN smartprocesslog.Status NOT IN ('FINALIZADO','EXITOSO') THEN CAST(smartprocesslog.Observations AS NVARCHAR(MAX)) END [TIPO_DE_ERROR] , CONVERT(VARCHAR,CONVERT(DATE,RequestFileHistories1.CreationDate)) [FECHA_DE_LA_GESTION] ,CASE WHEN RequestFilesRespuestaParcial.FiledDate IS NOT NULL AND RequestFilesRespuestaDefinitiva.FiledDate IS NULL THEN 'Respuesta Parcial' WHEN RequestFilesRespuestaDefinitiva.FiledDate 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] --,CAST(ISNULL(RequestFilesRespuestaDefinitiva.FiledDate, RequestFilesRespuestaParcial.FiledDate) AS DATE) AS [FECHA_DE_RESPUESTA] --,CAST(ISNULL(RequestFilesRespuestaDefinitiva.FiledDate, RequestFilesRespuestaParcial.FiledDate) AS TIME) AS [HORA_DE_RESPUESTA] --MOMENT_3 ,CASE WHEN smartprocesslogMom3.TieneEnvio = 1 THEN 'Enviada' ELSE 'No Enviada' END AS [SE_ENVIO_MOMENTO_3] ,CASE WHEN smartprocesslogMom3.TieneEnvio = 1 THEN 'N/A' ELSE CAST(smartprocesslogMom3.Observations AS VARCHAR(8000)) END AS [TIPO_DE_ERROR_MOMENTO_3] ,EnteControl.Name [ENTE_DE_CONTROL] ,CASE WHEN SmartAddicionalRequestFiles.EscalationDCF IN ('1','2') THEN 'Si' ELSE 'No' END [ESCALAMIENTO_AL_DEFENSOR_DEL_CONSUMIDOR] ,CASE WHEN SmartAddicionalRequestFiles.ComplaintExpress IN ('1','2') THEN 'Si' ELSE 'No' END [QUEJA_EXPRES] ,CASE WHEN SmartAddicionalRequestFiles.Replica IN ('1') THEN 'Si' ELSE 'No' END [REPLICA] ,CONVERT(VARCHAR,CONVERT(DATE,smartprocesslogMom3.RegistrationDate)) [FECHA_DE_TRASMISION_MOMENTO_3] ,CASE WHEN smartprocesslogMom3.TieneEnvio = 1 THEN 'Cerrado' ELSE 'Abierto' END AS [ESTADO_DE_LA_QUEJA_O_RECLAMO] ,SmartAddicionalRequestFiles.ComingFromProcedure [PROCEDENTE] ,Favorabilidad.Name [FAVORABILIDAD] ,SmartAddicionalRequestFiles.FavorConsumerProcedure [A_FAVOR_DE] ,CASE WHEN SmartAddicionalRequestFiles.RefusedEntityProcedure='1' THEN 'Si' ELSE 'No' END [INADMITIDA_O_RECHAZADA_POR_LA_ENTIDAD] ,SmartAddicionalRequestFiles.SuperFRemittedProcedure [TRASLADO_A_LA_SUPERINTENDENCIA] ,AFavorDe.Name [ACEPTACION] ,Rectificacion.Name [RECTIFICACION] ,Desistimiento.Name [DESISTIMIENTO] ,Clients.NumberIdentification [REMITENTE] ,NameType.Name [TIPO_DE_SOLICITUD] ,ProcedureType.Name [DETALLE_DE_LA_SOLICITUD] ,SpecificationType.Name [ESPECIFICACION_DE_LA_SOLICITUD] ,CASE WHEN Clients.AffiliatedFomag='1' THEN 'Si' ELSE 'No' END [AFILIADO_AL_FOMAG] ,AffiliateType.Code [TIPO_DE_AFILIADO] ,RequestFiles.Subject [ASUNTO] ,CASE WHEN Clients.OriginRegistry='SmartSupervision' AND RequestFiles.ReportedSmart='1' THEN 'Si' WHEN Clients.OriginRegistry NOT IN ('SmartSupervision') THEN 'No' END [ACTUALIZO_MOMENTO_4] ,CASE WHEN RequestFiles.ReportedSmart='1' THEN CONVERT(VARCHAR,CONVERT(DATE,Clients.ModificationDate)) END [FECHA_ACTUALIZACION] ,CONVERT(INT,YEAR(RequestFiles.FiledDate)) [AÑO_FIL] ,MONTH(RequestFiles.FiledDate) [MES_FIL] ,ISNULL(Dependencies.code,0) [DEPENDENCIA_FIL] ,ROW_NUMBER() OVER (PARTITION BY SmartAddicionalRequestFiles.ComplaintCode,RequestFiles.FileNumber ORDER BY SmartAddicionalRequestFiles.ComplaintCode) AS RN -- Se extraen los archivos de solicitud desde la tabla RequestFiles -- 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] FROM DMS.DBO.RequestFiles -- Se obtiene el historial más reciente de cada solicitud LEFT JOIN DMS.DBO.RequestFileHistories ON RequestFileHistories.RequestFileId = RequestFiles.Id AND RequestFileHistories.CreationDate = ( SELECT MAX(CreationDate) FROM DMS.DBO.RequestFileHistories A WHERE A.RequestFileId = RequestFileHistories.RequestFileId AND ProcessCode !='615' ) -- Se obtiene el historial más antiguo con una dependencia asignada LEFT JOIN DMS.DBO.RequestFileHistories RequestFileHistories1 ON RequestFileHistories1.RequestFileId = RequestFiles.Id AND RequestFileHistories1.CreationDate = ( SELECT MIN(CreationDate) FROM DMS.DBO.RequestFileHistories A WHERE A.RequestFileId = RequestFileHistories1.RequestFileId AND DependencyId IS NOT NULL AND ProcessCode !='615' ) -- Se unen los historiales de momentos y reclasificaciones LEFT JOIN DMS.DBO.RequestFileHistories RequestFileHistoriesMomentos ON RequestFileHistoriesMomentos.RequestFileId = RequestFiles.Id LEFT JOIN DMS.DBO.RequestFileHistories RequestFileHistoriesReclas ON RequestFileHistoriesReclas.RequestFileId = RequestFiles.Id AND RequestFileHistoriesReclas.Status IN ('31b6159d-de9d-4cba-9508-4d9d4ee2faf7') -- Se unen los datos de clientes y usuarios LEFT JOIN DMS.DBO.clients ON clients.Id = RequestFiles.clientid LEFT JOIN [Stage].[dbo].[Users_Stage] Users ON Users.UserName = RequestFileHistories.UserName LEFT JOIN [Stage].[dbo].[Users_Stage] Users1 ON Users1.UserName = RequestFileHistories1.UserName -- Se unen las dependencias relacionadas con el historial de solicitudes LEFT JOIN DMS.DBO.Dependencies ON Dependencies.Id = RequestFileHistories.DependencyId LEFT JOIN DMS.DBO.Dependencies Dependencies1 ON Dependencies1.Id = RequestFileHistories1.DependencyId -- Se extraen datos adicionales sobre la solicitud LEFT JOIN DMS.DBO.SmartAddicionalRequestFiles ON SmartAddicionalRequestFiles.RequestFilesId = RequestFiles.Id LEFT JOIN DMS.DBO.[TYPESTATEREQUEST_VW] ESTADO ON ESTADO.Id = RequestFiles.StatusId LEFT JOIN DMS.DBO.[TYPESTATEREQUEST_VW] ESTADOMomentos ON ESTADOMomentos.Id = RequestFileHistoriesMomentos.Status -- Se unen detalles de la solicitud como producto, canal, motivo, admisión, etc. 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 -- Se unen datos de solicitudes relacionadas --LEFT JOIN DMS.DBO.RelatedRequestFiles ON RelatedRequestFiles.ParentId = RequestFiles.Id --LEFT JOIN DMS.DBO.RequestFiles RequestFiles1 ON RelatedRequestFiles.requestfileId = RequestFiles1.Id --LEFT JOIN DMS.DBO.TypeDetail StatusMomento3 ON StatusMomento3.Id = RequestFiles1.StatusId -- Se unen datos de solicitudes relacionadas LEFT JOIN (--LEFT JOIN con RequestFilesRespuestaParcial y RequestFilesRespuestaDefinitiva para obtener las respuestas parciales y definitivas SELECT B.ParentId,C.FiledDate,C.FileNumber,ChannelId,UserName,ROW_NUMBER() OVER(PARTITION BY B.ParentId ORDER BY C.FiledDate ASC,C.FileNumber,B.ParentId,ChannelId,UserName)NumberFile FROM dms.dbo.RelatedRequestFiles B INNER JOIN dms.dbo.RequestFiles C ON B.RequestFileId=C.Id WHERE C.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND C.ResposnseText=2)RequestFilesRespuestaParcial ON RequestFiles.Id=RequestFilesRespuestaParcial.ParentId AND RequestFilesRespuestaParcial.NumberFile=1 LEFT JOIN (-- LEFT JOIN con otras respuestas definitivas para obtener la última respuesta definitiva SELECT B.ParentId,C.FiledDate,C.FileNumber,ChannelId,UserName,ROW_NUMBER() OVER(PARTITION BY B.ParentId ORDER BY C.FiledDate DESC,C.FileNumber,B.ParentId,ChannelId,UserName)NumberFile FROM dms.dbo.RelatedRequestFiles B INNER JOIN dms.dbo.RequestFiles C ON B.RequestFileId=C.Id WHERE C.RequestTypeId='956FE4FE-E0C0-4F50-B742-DB431F9F536B' AND C.ResposnseText=1) RequestFilesRespuestaDefinitiva ON RequestFiles.Id=RequestFilesRespuestaDefinitiva.ParentId AND RequestFilesRespuestaDefinitiva.NumberFile=1 LEFT JOIN DMS.DBO.TypeDetail StatusMomento3 ON StatusMomento3.Id = RequestFileHistories.Status -- Se extraen datos del tipo de radicado y afiliado LEFT JOIN DMS.DBO.[TYPEORIGIN_VW] TIPORADICADO ON RequestFiles.RequestTypeId = TIPORADICADO.Id LEFT JOIN DMS.DBO.[TYPEAFFILIATE_VW] AffiliateType ON Clients.AffiliateTypeId = AffiliateType.Id -- Se extraen datos de procedimientos y especificaciones 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 LEFT JOIN DMS.DBO.PQRSDType PqrsType ON PqrsType.Id = RequestFiles.PqrsTypeId -- Se unen datos de entidades de control LEFT JOIN DMS.DBO.TypeDetail EnteControl ON EnteControl.Id = SmartAddicionalRequestFiles.ControlEntity -- Se obtiene el registro más reciente del proceso de supervisión en el "Momento 1" para cada solicitud. -- Esto permite identificar el estado más actualizado de este proceso asociado al número de radicado y documento del cliente. LEFT JOIN DMS.DBO.smartprocesslog ON smartprocesslog.FileNumber = RequestFiles.FileNumber AND smartprocesslog.ClientDocumentNumber = Clients.NumberIdentification AND Process = 'MOMENTO_1' AND smartprocesslog.RegistrationDate = ( -- Se selecciona la fecha de registro más reciente dentro del proceso "MOMENTO_1" SELECT MAX(RegistrationDate) FROM DMS.DBO.smartprocesslog A WHERE RequestFiles.FileNumber = A.FileNumber AND Clients.NumberIdentification = A.ClientDocumentNumber AND A.Process = 'MOMENTO_1' ) --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 -- Se obtiene el registro más reciente del proceso de supervisión en el "Momento 3" cuando el subproceso es "REPORTE_QUEJA". -- Se busca determinar el último estado registrado de este proceso, priorizando estados exitosos o fallidos si existen. OUTER APPLY ( SELECT TOP 1 SP.RegistrationDate, SP.Status, SP.Observations, CASE WHEN SP.Status IN ('EXITOSO','FINALIZADO') THEN 1 ELSE 0 END AS TieneEnvio FROM DMS.DBO.smartprocesslog SP WHERE SP.FileNumber = RequestFiles.FileNumber --AND SP.ClientDocumentNumber = Clients.NumberIdentification AND SP.Process = 'MOMENTO_3' AND SP.SubProcess = 'REPORTE_QUEJA' ORDER BY CASE WHEN SP.Status IN ('EXITOSO','FINALIZADO') THEN 1 WHEN SP.Status = 'FALLIDO' THEN 2 ELSE 3 END, SP.RegistrationDate DESC ) smartprocesslogMom3 WHERE RequestFiles.OriginId='2A1B3A5A-6FEC-4234-A24E-B87A1710ECE7' AND PqrsType.Code IN ('QejSFC','QuejEx') AND ESTADO.Name <>'Anulado' AND RequestFiles.FileNumber IS NOT NULL AND SmartAddicionalRequestFiles.ComplaintCode IS NOT NULL --revisar --Se agregan los siguientes estados por caso SAC 961822 AND RequestFileHistories.Status NOT IN ('4139c0b6-68ff-4e79-9796-36c04a9891c8','6a4c1604-0097-48e4-8c4c-ae1b735ed425' ,'8d6acd5a-d128-45b0-b1a5-f9c0fef90708','EF7B7E43-9151-422A-9A2C-6E3B6C53BC85') AND RequestFileHistories.ProcessCode !='615' ) AS Momento WHERE RN = 1

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
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
StagedboSmartSupervisionMom2_WA_Sys_0000001B_394FC3D86/6/2026 12:51:16 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_00000037_394FC3D86/6/2026 12:51:16 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_00000038_394FC3D86/6/2026 12:51:16 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_00000036_394FC3D86/6/2026 12:51:16 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_00000019_394FC3D86/6/2026 12:51:16 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_00000011_394FC3D86/6/2026 12:51:16 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_0000001D_394FC3D86/6/2026 12:51:16 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_0000001E_394FC3D86/6/2026 12:51:16 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_00000003_394FC3D86/6/2026 12:51:15 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_00000034_394FC3D86/6/2026 12:51:15 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_00000035_394FC3D86/6/2026 12:51:15 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_00000009_394FC3D86/6/2026 12:51:15 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_0000000B_394FC3D86/6/2026 12:51:15 AM5370771074169200.00
StagedboSmartSupervisionMom2_WA_Sys_00000033_394FC3D86/6/2026 12:51:15 AM5370771074169200.00
StagedboSmartSupervisionMom2PK__SmartSup__3214EC0733D5295D6/6/2026 12:51:15 AM5370771074169200.00
StagedboSmartSupervisionMom1_WA_Sys_00000006_641AF1A36/6/2026 12:51:16 AM19793958200.00
StagedboSmartSupervisionMom1_WA_Sys_00000017_641AF1A36/6/2026 12:51:16 AM19793958200.00
StagedboSmartSupervisionMom1_WA_Sys_00000013_641AF1A36/6/2026 12:51:16 AM19793958200.00
StagedboSmartSupervisionMom1_WA_Sys_00000018_641AF1A36/6/2026 12:51:16 AM19793958200.00
StagedboSmartSupervisionMom1_WA_Sys_00000031_641AF1A36/6/2026 12:51:16 AM19793958200.00
StagedboSmartSupervisionMom1_WA_Sys_00000032_641AF1A36/6/2026 12:51:16 AM19793958200.00
StagedboSmartSupervisionMom1_WA_Sys_00000008_641AF1A36/6/2026 12:51:16 AM19793958200.00
StagedboSmartSupervisionMom1_WA_Sys_00000030_641AF1A36/6/2026 12:51:16 AM19793958200.00
StagedboSmartSupervisionMom1PK_SmartSupervisionMom16/6/2026 12:51:16 AM19793958200.00
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
DMSdboRelatedRequestFiles_WA_Sys_00000003_55DFB4D96/6/2026 7:55:46 AM58995147568480.63
DMSdboRelatedRequestFilesIDX_NC_RelatedRequestFiles_0026/6/2026 7:55:47 AM58995147568480.63
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
DMSdboRequestFiles_WA_Sys_0000001F_33FF9E216/6/2026 4:30:00 AM188195883982244.62
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

Indices faltantes sugeridos por SQL Server

DatabaseNameSchemaNameTableNameUserSeeksUserScansAvgTotalUserCostAvgUserImpactEstimatedImpactEqualityColumnsInequalityColumnsIncludedColumns
OpheliaSuitedboWF_SEGUI28604731.4099.97135277330.88[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]
DMSdboRequestFileHistories290136.0557.99228791.38[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_Procedures543001.5713.69116354.25[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]
DMSdboRequestFiles10414.0799.9941402.40[ApproverName]
DMSdboRequestFiles10414.1999.7641319.57[ApproverName]
DMSdboDMS_Procedures201000.6830.3841282.65[ProceduresStateId], [VisibleWeb][ResponsibleUserId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId], [ProcessVersion], [IdTheme], [IdBussinnes]
DMSdboRequestFiles10416.3199.0541235.59[ApproverName][ClientId], [ProcedureId], [FileNumber], [FiledDate], [StatusId], [Subject], [DependencyId], [ReceiverName], [SeriesId], [SubseriesId], [OriginId], [CaseId], [DocumentTypeId], [ExperationDate], [ContactId], [CollaboratorDependencyId], [VersionCCD], [VersionTRD]
DMSdboDMS_Security27604.7530.3239727.47[UserName], [ValidateUser]
DMSdboRequestFiles6086.8772.3837725.31[StatusId], [OriginId], [ReportedSmart][ComplaintOrigin][ClientId], [FileNumber], [PqrsTypeId]
DMSdboClassificationHistories192200.2289.6737531.79[DependencyCode][SubserieCode][ClassificationHeadId], [SerieCode]
DMSdboDMS_Procedures201000.6826.9136567.35[VisibleWeb][ResponsibleUserId], [ProceduresStateId], [ProcedureTypeId], [SpecificationTypeId], [NameTypeId], [ProcessVersion], [IdTheme], [IdBussinnes]
DMSdboDocumentType22903.9738.3734901.27[Version][Name], [Code]
OpheliaSuitedboWF_FETAP578700.1153.6134485.69[EMP_CODI], [PTL_CODI], [PTL_VERS]
DMSdboReviewDocumentCertification35201.1185.0733241.69[IdDocumentCertification][IdDetailManagePeaceAndSave], [IdUserApproving], [State], [CreationDate], [ModificationDate]
OpheliaSuitedboWF_SEGUI17025.1074.7131880.77[EMP_CODI], [SEG_CONA], [SEG_ESTE][FLU_CONT], [SEG_FREC]
DMSdboRequestFiles60437.7611.8531124.86[UserName][FiledDate][FileNumber]
DMSdboDMS_Procedures201300.5925.0529970.05[ProceduresStateId], [VisibleWeb][IdTheme][Name], [ResponsibleUserId], [ProcedureTypeId], [NameTypeId], [ProcessVersion], [IdBussinnes]
DMSdboRequestFiles5061.0495.3729107.80[OriginId], [VersionCCD][FiledDate][DependencyId]
DMSdboRequestFiles5061.0495.2929083.38[OriginId][FiledDate][DependencyId], [VersionCCD]
DMSdboRequestFiles60437.7610.8328445.76[FileNumber], [FiledDate][UserName]
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]
DMSdboDMS_Procedures201300.5921.4625674.94[VisibleWeb][IdTheme][Name], [ResponsibleUserId], [ProceduresStateId], [ProcedureTypeId], [NameTypeId], [ProcessVersion], [IdBussinnes]
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]
DMSdboRequestFiles3060.7696.0117499.66[StatusId], [OriginId], [ComplaintOrigin][FileNumber]

Indices no usados o de bajo uso

DatabaseNameSchemaNameTableNameIndexNameTypeDescUserSeeksUserScansUserLookupsUserUpdates
OpheliaSuitedboWF_IRUTAIDX_NC_WF_IRUTA_002NONCLUSTERED000672482
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_010NONCLUSTERED000146067
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_002NONCLUSTERED00028425
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_004NONCLUSTERED00028351
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_001NONCLUSTERED00028103
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_002NONCLUSTERED00028103
OpheliaSuitedboWF_PROCESS_QUEUEUX_WF_PROCESS_QUEUE_IDEMPOTENCYNONCLUSTERED0008813
DMSdboCasesRelationParentAndChildDX_NC_CasesRelationParentAndChild_ChildCaseNONCLUSTERED0004291
OpheliaSuitedboWF_PROCESS_QUEUEIX_WF_PROCESS_QUEUE_CREATED_BYNONCLUSTERED0002807
DMSdboEventsIDX_NC_Events_001NONCLUSTERED0002751
DMSdboConsecutiveReferenceHistoryIDX_NC_ConsecutiveReferenceHistory_001NONCLUSTERED0002287
DMSdboReassignmentTaskIX_ReassignmentTask_RetryNONCLUSTERED0002147
DMSdboRepresentativesIDX_NC_Representatives_002NONCLUSTERED000102
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 AMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.2.44]
6/3/2026 10:34:23 AMLogonError: 18456, Severity: 14, State: 8.
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 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:41 AMLogonError: 18456, Severity: 14, State: 8.
6/2/2026 11:46:21 AMLogonError: 18456, Severity: 14, State: 8.
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: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 PMLogonLogin failed for user 'ophelia'. Reason: Password did not match that for the login provided. [CLIENT: 10.212.132.25]
6/1/2026 2:42:17 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]
6/1/2026 2:41:49 PMLogonError: 18456, Severity: 14, State: 8.
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)

No hay datos.

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

base_datosesquematablaindicetype_descfragmentacion_pctpage_counttamano_mbaccion_recomendada
OpheliaSuitedboWF_SEGUIPK_WF_SEGUICLUSTERED48.59641222550095.5REBUILD
DrivedboDRIVE_METADATAPK__DRIVE_ME__DED88B1C6A0453BFCLUSTERED90.848347006521.1REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_009NONCLUSTERED96.396592775150.6REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_002NONCLUSTERED48.1911860769266.2REBUILD
OpheliaSuitedboWF_SEGUIIN_WF_SEGUI_02NONCLUSTERED39.47142826411158.3REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_001NONCLUSTERED47.1511799169218.1REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_006NONCLUSTERED69.887607485943.3REBUILD
OpheliaSuitedboWF_LOGPLPK_WF_LOGPLCLUSTERED46.5810954128557.9REBUILD
OpheliaSuitedboWF_IRUTAPK_WF_IRUTACLUSTERED35.48133880610459.4REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_004NONCLUSTERED35.8512394909683.5REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_003NONCLUSTERED47.398945906989.0REBUILD
OpheliaSuitedboWF_IRUTAIDX_NC_WF_IRUTA_001NONCLUSTERED20.36157581012311.0REORGANIZE
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_007NONCLUSTERED37.287804706097.4REBUILD
OpheliaSuitedboWF_IRUTAIDX_NC_WF_IRUTA_002NONCLUSTERED23.3611248938788.2REORGANIZE
DMSdboDMS_IndexesPK__DMS_Inde__3214EC0764BB43FACLUSTERED45.785576954357.0REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_010NONCLUSTERED95.042268171772.0REBUILD
DrivedboDRIVE_METADATAIX_DRIVE_METADATA_FolderCodeNONCLUSTERED86.632377911857.7REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_002NONCLUSTERED82.032451611915.3REBUILD
DrivedboDRIVE_METADATAUQ__DRIVE_ME__6F0F98BEF15CEBCCNONCLUSTERED71.422303811799.9REBUILD
OpheliaSuitedboWF_SEGUIIDX_NC_WF_SEGUI_008NONCLUSTERED10.45155426012142.7REORGANIZE
DrivedboDRIVE_FOLDERPK__DRIVE_FO__DED88B1C73D9DEFECLUSTERED93.191602131251.7REBUILD
OpheliaSuitedboWF_SEGUIIN_WF_SEGUI_01NONCLUSTERED6.61218878017099.8NO ACCION
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_003NONCLUSTERED65.251296741013.1REBUILD
DMSdboRequestEmailPK__tmp_ms_x__3214EC0709EC20FCCLUSTERED34.892206451723.8REBUILD
OpheliaSuitedboWF_FPLANUQ_WF_FPLAN_001NONCLUSTERED32.732122481658.2REBUILD
DMSdboPQRSDWebProcessLogPK__PQRSDWeb__3214EC07598FFB3BCLUSTERED20.173297892576.5REORGANIZE
OpheliaSuitedboWF_FPLANIDX_NC_WF_FPLAN_001NONCLUSTERED22.952565262004.1REORGANIZE
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_004NONCLUSTERED95.0459218462.6REBUILD
DrivedboDRIVE_FOLDERIX_DRIVE_FOLDER_CodeNONCLUSTERED94.9759179462.3REBUILD
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_001NONCLUSTERED45.89113864889.6REBUILD
OpheliaSuitedboWF_FPLANPK_WF_FPLANCLUSTERED11.113956113090.7REORGANIZE
DMSdboDMS_ReorderedDocumentsPK_DMS_ReorderedDocumentsCLUSTERED75.5150634395.6REBUILD
DrivedboDRIVE_FOLDERUQ__DRIVE_FO__A25C5AA750312A26NONCLUSTERED74.5542478331.9REBUILD
DrivedboDRIVE_METADATAIDX_NC_DRIVE_METADATA_005NONCLUSTERED24.19113250884.8REORGANIZE
OpheliaSuitedboWF_FPLANIDX_NC_WF_FPLAN_002NONCLUSTERED8.373073352401.1NO ACCION
DMSdboReferencesRequestFileIDX_NC_ReferencesRequestFile_00NONCLUSTERED28.8784586660.8REORGANIZE
DMSdboReferencesRequestFilePK_ReferencesRequestFileCLUSTERED24.6888080688.1REORGANIZE
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_003NONCLUSTERED34.7057524449.4REBUILD
DMSdboRequestFilesPK__tmp_ms_x__3214EC077390A34DCLUSTERED3.045614994386.7NO ACCION
OpheliaSuitedboWF_VBPERPK_WF_VBPERCLUSTERED48.2734960273.1REBUILD
DMSdboRequestFilesIDX_NC_RequestFiles_012NONCLUSTERED22.0569419542.3REORGANIZE
DMSdboRadicadeHistoryPK__tmp_ms_x__3214EC078C329747CLUSTERED26.8548291377.3REORGANIZE
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_005NONCLUSTERED7.571598681249.0NO ACCION
DMSdboDMS_ReorderedDocumentsIX_DMS_ReorderedDocuments_001NONCLUSTERED47.8524094188.2REBUILD
DMSdboManagePeaceAndSaveDetailScopePK_ManagePeaceAndSaveDetailScopeCLUSTERED23.1947378370.1REORGANIZE
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_005NONCLUSTERED25.8536900288.3REORGANIZE
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_011NONCLUSTERED14.7154090422.6REORGANIZE
DMSdboDMS_IndexesIDX_NC_DMS_Indexes_002NONCLUSTERED17.8444386346.8REORGANIZE
DMSdboReferencesRequestFileIDX_NC_ReferencesRequestFile_002NONCLUSTERED48.3515467120.8REBUILD
DMSdboRequestEmailIDX_RequestEmailV_DateAffairSenderNONCLUSTERED30.7023889186.6REBUILD
DMSdboContactsPK__Contacts__3214EC07786292A4CLUSTERED13.9352581410.8REORGANIZE
DMSdboDMS_IndexesIDX_NC_DMS_Indexes_001NONCLUSTERED22.7029824233.0REORGANIZE
DMSdboRequestFilesIDX_NC_RequestFiles_006NONCLUSTERED19.0935184274.9REORGANIZE
OpheliaSuitedboWF_CASOSIDX_NC_WF_CASOS_002NONCLUSTERED19.0435051273.8REORGANIZE
DMSdboDMS_ReferencesIDX_NC_DMS_References_007NONCLUSTERED48.561221795.4REBUILD
DMSdboRequestFilesIDX_NC_RequestFiles_004NONCLUSTERED12.4345467355.2REORGANIZE
DMSdboRequestFilesIDX_NC_RequestFiles_015NONCLUSTERED31.4917813139.2REBUILD
DMSdboRequestFilesIDX_NC_RequestFiles_013NONCLUSTERED28.4517716138.4REORGANIZE
OpheliaSuitedboWF_ICOMPPK_WF_ICOMPCLUSTERED4.45100457784.8NO ACCION
DMSdboRequestFilesStampedIDX_NC_RequestFilesStamped_001NONCLUSTERED24.9616617129.8REORGANIZE
StagedboRequestFilesExpirationDateidx_nc_RequestFilesExpirationDate_001NONCLUSTERED45.61876468.5REBUILD
OpheliaSuitedboWF_RCPROIN_WF_RCPRO_01NONCLUSTERED9.5940891319.5NO ACCION
DMSdboRadicadeHistoryIDX_NC_RadicadeHistory_002NONCLUSTERED28.2813619106.4REORGANIZE
DMSdboGeneralErrorsLogPK__GeneralE__3214EC07DE39B021CLUSTERED12.2630765240.4REORGANIZE
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_002NONCLUSTERED14.8424756193.4REORGANIZE
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_002NONCLUSTERED9.1939884311.6NO ACCION
DMSdboRequestFilesDX_NC_RequestFiles_002NONCLUSTERED27.2213110102.4REORGANIZE
DMSdboRadicadeHistoryIDX_NC_RadicadeHistory_001NONCLUSTERED15.6822455175.4REORGANIZE
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_001NONCLUSTERED8.4440724318.2NO ACCION
DMSdboRequestFilesIX_RequestFiles_MassiveConsecutiveNONCLUSTERED34.36981676.7REBUILD
DrivedboDRIVE_FOLDERIDX_NC_DRIVE_FOLDER_001NONCLUSTERED14.3122603176.6REORGANIZE
DMSdboRadicadeHistoryIDX_NC_RadicadeHistory_003NONCLUSTERED34.63908070.9REBUILD
DMSdboEventsPK__Events__3214EC07909701EDCLUSTERED31.87959174.9REBUILD
OpheliaSuitedboWF_RCPROPK_WF_RCPROCLUSTERED4.6865279510.0NO ACCION
OpheliaSuitedboWF_RCPROIDX_NC_WF_RCPRO_003NONCLUSTERED7.4739753310.6NO ACCION
DMSdboRepresentativesPK_RepresentativesCLUSTERED45.13654851.2REBUILD
DMSdboRequestFilesIX_RequestFiles_FiledDateNONCLUSTERED26.881092485.3REORGANIZE
DMSdboSmartReportedComplaintFilesPK__SmartRep__3214EC07AFE49E42CLUSTERED45.00512240.0REBUILD
DrivedboFILE_METADATAPK_FILE_METADATACLUSTERED99.22229517.9REBUILD
DMSdboDMS_ReferencesPK__tmp_ms_x__3214EC0766F9A7BBCLUSTERED14.0616035125.3REORGANIZE
DMSdboRepresentativesIDX_NC_Representatives_003NONCLUSTERED37.64583945.6REBUILD
OpheliaSuitedboWF_CASOSPK_WF_CASOSCLUSTERED1.161741471360.5NO ACCION
DMSdboDMS_ReferencesSummaryPK_DMS_ReferencesSummaryCLUSTERED50.95372129.1REBUILD
DMSdboSmartProcessLogPK__SmartPro__3214EC07387BAEFFCLUSTERED46.94336426.3REBUILD
DMSdboDMS_ReferencesIDX_NC_DMS_References_009NONCLUSTERED42.07372529.1REBUILD
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_001NONCLUSTERED0.413797672966.9NO ACCION
DMSdboCopiesCommunicationIDX_NC_CopiesCommunication_001NONCLUSTERED29.34521240.7REORGANIZE
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_004NONCLUSTERED0.841800651406.8NO ACCION
DMSdboManagePeaceAndSaveDetailScopeIDX_NC_ManagePeaceAndSaveDetailScope_001NONCLUSTERED5.2128316221.2NO ACCION
DMSdboClientsPK__Clients__3214EC075B672D4ACLUSTERED5.3525934202.6NO ACCION
DMSdboRequestFileHistoriesPK__RequestF__3214EC07B438AE64CLUSTERED0.363613182822.8NO ACCION
DMSdboContactsIDX_NC_Contacts_001NONCLUSTERED15.37672052.5REORGANIZE
DMSdboRepresentativesIDX_NC_Representatives_001NONCLUSTERED27.59367128.7REORGANIZE
DMSdboRequestFilesIDX_NC_RequestFiles_016NONCLUSTERED5.3417387135.8NO ACCION
DMSGDEAdboDIMRADICACIONPk_RadicacionCLUSTERED48.76184814.4REBUILD
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_002NONCLUSTERED0.442041211594.7NO ACCION
DMSdboRequestFileHistoriesIDX_NC_RequestFileHistories_006NONCLUSTERED0.461793841401.4NO ACCION
DMSdboPQRSDWebProcessLogIX_PQRSDWebProcessLog_BeginQueueNONCLUSTERED17.73445534.8REORGANIZE
OpheliaSuitedboWF_PROCESS_QUEUEPK_WF_PROCESS_QUEUECLUSTERED0.6875002586.0NO 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.