Ejemplo con datos simulados · Probalo gratis con tu servidor
nexadba
Monthly summary · November 2026

Sample Distributors Inc.

Server ERP production (sample)

La salud del servidor mejoró de 24 a 44 puntos. Estuvo disponible el 99,90% del tiempo. Hubo 16 alertas, 12 de prioridad alta o crítica. Atención: el disco D:\ se llena en unos 11 días. Se aplicaron 2 mejoras; 1 ya muestra resultados medibles.

Health
44 ▲
started the month at 24
Availability
99,90%
2.016 checks
Alerts
16
3 critical · 9 high · 4 medium
Average CPU
20%
95% of the time under 52%

Health over time

Top alerts

AlertTimes
High CPU2
Deadlocks2
Drive D:\ will be full in about 11 days1
The job “Exportación a Reportes_DW” has been running for 1 h 55 min1
xp_cmdshell is enabled1

Operation

IndicatorValue
Blocking (minutes with blocked sessions)70
Job runs273
Failed jobs9
Backups taken730

Disk space

DriveFreeFull in
C:\62 GBno risk
D:\44 GB11 days
E:\199 GB95 days

Most resource-intensive queries

QueryExecutionsAvg ms
UPDATE dbo.Comprobantes SET Estado = 'AUTORIZADO', CAE = @cae, VtoCAE = @vto WHERE PuntoVenta = @pv AND Numero = @nro193.204644,4
SELECT YEAR(v.Fecha) AS Anio, MONTH(v.Fecha) AS Mes, a.Rubro, SUM(v.Importe) FROM dbo.VentasDetalle v JOIN dbo.Articulos a ON a.IdArticulo =1.22537.824,5
SELECT r.*, d.Direccion FROM dbo.Remitos r JOIN dbo.Destinos d ON d.Id = r.IdDestino WHERE UPPER(r.Patente) LIKE '%' + @patente + '%' ORDER 26.7241.472,0
SELECT * FROM dbo.Pedidos p INNER JOIN dbo.Clientes c ON c.IdCliente = p.IdCliente WHERE p.NroComprobante = @P1 AND p.Estado <> 'ANULADO'599.29459,3
SELECT Precio, Stock, Descripcion, IdRubro, Iva FROM dbo.Articulos WHERE CodigoBarras = @codigo3.201.0515,5

Security

Change or risk detected
xp_cmdshell is enabled
New server administrator: soporte_externo

Improvements applied this month

ImprovementResult
Index IX_Remitos_Patente and search without UPPER/LIKE on LogisticaThis query went from 1.792 ms to 43,4 ms per execution (−98%). (partial measurement: 30 h)
MAXDOP 4 and cost threshold for parallelism 50Measuring: the first comparison will show up in a couple of hours.

Pending recommended improvements

TopicWhat to do
1 database(s) without a full backup in the last 7 daysSchedule FULL backups at least weekly (ideally daily) and test restores.
Max server memory not cappedSet 'max server memory' leaving 10–20% free for Windows (suggested: 52,428 MB).
1 database(s) in FULL recovery without log backupsSchedule log backups every 15-60 minutes, or switch the database to SIMPLE if point-in-time recovery isn't needed.
The database spends a lot of time reading from diskCreate the missing indexes from this report, review the queries that read the most and consider more RAM.
Frequent blocking between queriesShorten transactions, index the WHERE columns of UPDATE/DELETE and consider READ_COMMITTED_SNAPSHOT.

Resumen automático de NexaDBA. Se envía el primer día de cada mes.