Loading Dashboard...

--
Loading...
Loading...
Enterprise Overview
Real-time SQL Server Monitoring Platform
LIVE
--
Total Servers
--
View Details
--
Reachability
--
View Status
0
Critical Alerts
Requires immediate action
View Alerts
--
Compliance
Avg framework score
View Compliance
--
Failed Jobs
Last 24 hours
View Jobs
--
Patch Gaps
Servers needing updates
View Intelligence

### Compliance Framework Scorecard Live Monitoring

Loading compliance data...

### SQL Server Build Intelligence

Loading build intelligence...

### Recent Alerts

Loading alerts...

### Health Overview

Server Management

Loading server data...

Compliance Dashboard

Loading compliance data...

SQL Server Build Intelligence
Loading...
SQL Patch Management
Scheduled Patches
Servers Needing Patches
Compliance Summary
Microsoft Resources: SQL Server Builds | Update Catalog | Upgrade Guide | Security Updates (CVE) | KB Article Index

Loading patch management data...

You have read-only access to Patch Management. Contact your DBA team to schedule patches.

## Patch Scheduling Calendar

### January 2026

Patch Tuesday Holiday Maintenance Window Scheduled Patch

#### Patches Scheduled for

#### Maintenance Windows

## Schedule Patch Deployment

### Step 1: Select Servers

Selected: 0 servers

### Step 2: Select Maintenance Window

Maintenance Window
Or Custom Date
Start Time
Duration (minutes)

### Step 3: Review & Confirm

Select servers and schedule to see summary

## Server Patch Details

Loading...
Backup Compliance - Veeam

Loading backup compliance data...

Diagnostic Center

Loading diagnostics...

Jobs Monitor

Loading jobs data...

Alert Management

Loading alerts...

User Activity Log

### Recent Activity

Loading activity...
Help Desk One Stop Center
Real-time system health Application impact Documentation Escalation
LIVE
DBA On-Call Support
Available 24/7 for Tier 1 & 2 critical issues
PRIMARY
John Bosco Gakumba
+1 (832) 314-3066
[email protected]
BACKUP
David Branscome
+1 (623) 330-2109
[email protected]
Scheduled Maintenance
No scheduled maintenance
Tip: Search by server name, application, database, business owner, technical contact, or email. Source: CMS (ITBCertTracker)
--
Total Servers
--
Healthy
--
Warning
--
Critical
--%
Compliance
--
Days Stable
TIER PRIORITY:
Tier 1 - CJIS Critical (Immediate)
Tier 2 - CJ Operations (15 min)
Tier 3 - Administrative (1 hour)
Tier 4 - Dev/Test (NBD)
GENERAL DOCUMENTATION
View All in Azure DevOps
DBAOps Blueprint NEW DBA Escalation Contacts SQL Emergency Runbook General SQL Server SOP Search Azure DevOps Microsoft SQL Docs
Note: Documentation access is based on your Azure DevOps RBAC permissions. Contact DBA team if you need access.

### Active Issues 0

Loading...

### Tier 1 Systems 0

Loading...

### System Details & Documentation

#### Select or Search a System

Click a system from Active Issues, Tier 1 list, or use the search box above

### Quick Links

DBA SharePoint Escalation Matrix Emergency Runbook SQL Server SOP Full DBAOps Dashboard

### RDP Quick Connect

Press Enter or click button to download .rdp file

### Escalation Matrix

Tier 1
Immediate - Page DBA On-Call
Response: 15 min | Resolution: 1 hr
Tier 2
High - Call DBA Team
Response: 30 min | Resolution: 4 hr
Tier 3
Normal - Email/Ticket
Response: 2 hr | Resolution: 8 hr
Tier 4
Low - Ticket Only
Response: 24 hr | Resolution: NBD

### Recent Activity

All systems operational
Now

### Environment Intelligence

Last 24 Hours | Real-time Monitoring
99.2%
UPTIME
+0.3% vs last week
0
CRITICAL
No issues
0
WARNINGS
Monitoring...
99.8%
VEEAM BACKUP
All jobs successful
26
TANIUM PATCH
Pending updates

#### ACTION REQUIRED

0 servers need immediate attention
0 failed jobs need review
26 servers pending Tanium patches
0 replication lag alerts

#### RESOURCE ALERTS

AZTRACSSQL01P - Disk 87%
AZCJISSQL16 - CPU 78%
AZARCGISSQL19 - Memory 82%
All other resources healthy

#### CRITICAL APPLICATIONS

TraCS 8/8 Online
CJIS 2/2 Online
TrackIt 2/2 Online
Replication Sync OK
ETL Processes 12/12 OK
ArcGIS 4/4 Online

#### ACTIVE JOBS

Veeam Full Backup Running
Index Maintenance Scheduled
Tonight 11:00 PM
TraCS ETL Daily Complete
Finished 6:15 AM
CJIS Data Sync Complete
Finished 5:30 AM

#### UPCOMING & COMPLIANCE

Tanium Patch Window
Saturday 2:00 AM - 6:00 AM
SQL 2016 EOL
29 servers - July 2026
CJIS Compliance Audit
Next review: Feb 15
DR Test Scheduled
Quarterly - March 1
Last Refresh: -- | Auto-refresh: 60 seconds
Disk Space Monitoring
Real-time storage monitoring Deduplicated Alert thresholds
LIVE
Azure Government Cloud
FedRAMP High Authorized
FedRAMP High CJIS DoD IL4/IL5/IL6
--
Servers
--
Drives
--
Critical (<5%)
--
Warning (<25%)
--
Caution (<50%)
--
Healthy
ALERT THRESHOLDS:
Critical (<5% free) Alert: 5 min
Warning (<25% free) Alert: 15 min
Caution (<50% free) Alert: 30 min
Healthy (>50% free)

### Disk Space Status (Deduplicated)

Loading disk space data...
Remediation Center
Infrastructure-wide issue detection Fix scripts Documentation
LIVE
Azure Government - Compliant Infrastructure
All remediation actions logged for audit compliance
FedRAMP High CJIS DoD IL4/IL5/IL6
--
Total Issues
--
Critical
--
Warning
--
Caution

### Issues Requiring Remediation

Click an issue to see remediation steps
Loading remediation data...
Dashboard Settings

### Dashboard Configuration

#### Auto Refresh

Enable auto-refresh (every 5 minutes)

#### Data Source

Data from: DBAOpsRepository

Last sync: --

#### User Info

Logged in as: --

Role: --

#### Version

DBAOps Ver 1.0

DBAOps Ultimate Edition

### Server Inventory Management

Note: Server changes are saved to the database and will be reflected after the next data refresh. Make sure to run the PowerShell script after making changes.

## Add Server to Inventory

Server Name *
Instance Name
Environment *
Compliance Tier *
Application Category
Port
Notes

#### SQL Command Preview

## Remove Server from Inventory

Warning: Removing a server will mark it as inactive. Historical data will be preserved.
Select Server to Remove
Reason for Removal

#### SQL Command Preview

    -- Select a server to see the SQL command

DBAOps Blueprint
Enterprise Infrastructure Manual & Complete Documentation Guide
Open in New Tab
AZDPS

## Arizona Department of Public Safety

SQL Server Infrastructure Management Platform - Complete Documentation

Version 1.0 January 2026 John Bosco Gakumba
Executive Summary
Platform overview and key achievements
Platform Capabilities
Full feature documentation
Compliance Frameworks
CJIS, NIST, DISA, FedRAMP
Technical Architecture
System design and components
DBAOps Blueprint - Full Documentation
119
Servers Documented
1,308
Databases
62
DevOps Projects
85
Documentation Links
4
Compliance Frameworks
Architect: John Bosco Gakumba | SQL DBA / DBAOps Architect