Approval Workflow
Recommend → Review → Approve → Stage for execution window
⏳ 3 Pending
Restore MAXDOP to 8 — SQLPROD01
ConfigPendingSentinel recommends restoring MAXDOP from 1 to 8. MAXDOP was changed to 1 at 13:38 today — this serialized all parallel execution plans and caused a 5.9σ PLE collapse. Restoring to 8 will immediately begin recovering memory pressure.
EXEC sys.sp_configure N'max degree of parallelism', N'8';
RECONFIGURE WITH OVERRIDE;
Create Index IX_PatientData_AdmitDate_ProviderID
IndexPendingSentinel identified a missing index on PatientData.dbo.Encounters that would eliminate 840,000 logical reads per minute. Estimated query improvement: 72%. Impact is low risk — additive change only.
CREATE NONCLUSTERED INDEX [IX_Encounters_AdmitDate_ProviderID]
ON [dbo].[Encounters] ([AdmitDate] ASC, [ProviderID] ASC)
INCLUDE ([PatientID], [DiagCode], [BillingStatus])
WITH (ONLINE = ON, SORT_IN_TEMPDB = ON);
Disable MBC_LEGACY_SA Login
SecurityPendingChange Tracker detected that MBC_LEGACY_SA was re-enabled outside of change window. Sentinel recommends immediately disabling this account. This is a critical security action — requires DBA Lead approval.
ALTER LOGIN [MBC_LEGACY_SA] DISABLE;
ALTER LOGIN [MBC_LEGACY_SA] WITH PASSWORD = N''+CONVERT(varchar(36),NEWID())+'';
⚡
Sentinel AI generates all recommendations with full SQL, risk assessment, and rollback plan. You approve or reject — Sentinel executes on your schedule.
Ask Sentinel →