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% |
| Alert | Times |
|---|---|
| High CPU | 2 |
| Deadlocks | 2 |
| Drive D:\ will be full in about 11 days | 1 |
| The job “Exportación a Reportes_DW” has been running for 1 h 55 min | 1 |
| xp_cmdshell is enabled | 1 |
| Indicator | Value |
|---|---|
| Blocking (minutes with blocked sessions) | 70 |
| Job runs | 273 |
| Failed jobs | 9 |
| Backups taken | 730 |
| Drive | Free | Full in |
|---|---|---|
| C:\ | 62 GB | no risk |
| D:\ | 44 GB | 11 days |
| E:\ | 199 GB | 95 days |
| Query | Executions | Avg ms |
|---|---|---|
| UPDATE dbo.Comprobantes SET Estado = 'AUTORIZADO', CAE = @cae, VtoCAE = @vto WHERE PuntoVenta = @pv AND Numero = @nro | 193.204 | 644,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.225 | 37.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.724 | 1.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.294 | 59,3 |
| SELECT Precio, Stock, Descripcion, IdRubro, Iva FROM dbo.Articulos WHERE CodigoBarras = @codigo | 3.201.051 | 5,5 |
| Change or risk detected |
|---|
| xp_cmdshell is enabled |
| New server administrator: soporte_externo |
| Improvement | Result |
|---|---|
| Index IX_Remitos_Patente and search without UPPER/LIKE on Logistica | This query went from 1.792 ms to 43,4 ms per execution (−98%). (partial measurement: 30 h) |
| MAXDOP 4 and cost threshold for parallelism 50 | Measuring: the first comparison will show up in a couple of hours. |
| Topic | What to do |
|---|---|
| 1 database(s) without a full backup in the last 7 days | Schedule FULL backups at least weekly (ideally daily) and test restores. |
| Max server memory not capped | Set 'max server memory' leaving 10–20% free for Windows (suggested: 52,428 MB). |
| 1 database(s) in FULL recovery without log backups | Schedule 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 disk | Create the missing indexes from this report, review the queries that read the most and consider more RAM. |
| Frequent blocking between queries | Shorten 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.