Manage Redgate licenses portal: https://portal.red-gate.com/products/sql-toolbelt
SQL Monitor Console URL: https://okioprdrgt01.otoemc.local/
![]()
New_Redgate SQL Monitor Host Server
Server Name
Instance name
SQL Server version
Server OS
IP Address
RAM
CPU
System Manufacturer
OKIOPRDRGT01
OKIOPRDRGT01
2019
Windows Server 2022 Standard
10.103.70.43
8GB
1
VMware, Inc., System Model: 'VMware Virtual Platform'.
Server Name
SQL Server and OS Version Info
OKIOPRDRGT01
Microsoft SQL Server 2019 (RTM-CU29) (KB5046365) - 15.0.4405.4 (X64)
Oct 23 2024 08:45:19
Copyright (C) 2019 Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)
SQL Server Services information
servicename
startup_type_desc
status_desc
last_startup_time
service_account
is_clustered
filename
SQL Server (MSSQLSERVER)
Automatic
Running
2025-02-07 17:28:35.1300957 -06:00
OTOEMC\SQLServices
N
"E:\Program Files\Microsoft SQL Server\MSSQL15.OKIOPRDRGT01\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER
SQL Server Agent (MSSQLSERVER)
Automatic
Running
OTOEMC\SQLAgent
N
"E:\Program Files\Microsoft SQL Server\MSSQL15.OKIOPRDRGT01\MSSQL\Binn\SQLAGENT.EXE" -i MSSQLSERVER
SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
Manual
Running
NT Service\MSSQLFDLauncher
N
"E:\Program Files\Microsoft SQL Server\MSSQL15.OKIOPRDRGT01\MSSQL\Binn\fdlauncher.exe" -s MSSQL15.OKIOPRDRGT01
System Memory
![]()
Database Filenames and Paths
Database Name
name
physical_name
type_desc
state_desc
Total Size in MB
master
master
E:\Program Files\Microsoft SQL Server\MSSQL15.OKIOPRDRGT01\MSSQL\DATA\master.mdf
ROWS
ONLINE
4
master
mastlog
E:\Program Files\Microsoft SQL Server\MSSQL15.OKIOPRDRGT01\MSSQL\DATA\mastlog.ldf
LOG
ONLINE
2
model
modeldev
E:\Program Files\Microsoft SQL Server\MSSQL15.OKIOPRDRGT01\MSSQL\DATA\model.mdf
ROWS
ONLINE
8
model
modellog
E:\Program Files\Microsoft SQL Server\MSSQL15.OKIOPRDRGT01\MSSQL\DATA\modellog.ldf
LOG
ONLINE
8
msdb
MSDBData
E:\Program Files\Microsoft SQL Server\MSSQL15.OKIOPRDRGT01\MSSQL\DATA\MSDBData.mdf
ROWS
ONLINE
17
msdb
MSDBLog
E:\Program Files\Microsoft SQL Server\MSSQL15.OKIOPRDRGT01\MSSQL\DATA\MSDBLog.ldf
LOG
ONLINE
19
RedGateMonitor
RedGateMonitor
E:\Data\RedGateMonitor.mdf
ROWS
ONLINE
256475
RedGateMonitor
RedGateMonitor_log
D:\Data\RedGateMonitor_log.ldf
LOG
ONLINE
13220
tempdb
tempdev
D:\Data\tempdb.mdf
ROWS
ONLINE
8
tempdb
templog
D:\Data\templog.ldf
LOG
ONLINE
8
tempdb
temp2
D:\Data\tempdb_mssql_2.ndf
ROWS
ONLINE
8
Drive information
![]()
SQL Server Agent jobs and Category information
Job Name
Job Description
Job Owner
Date Created
Job Enabled
CategoryName
Backup command after server restart
Backup need to execute after server restart to take backups
sa
2025-02-21 14:00:04.330
1
[Uncategorized (Local)]
CommandLog Cleanup
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.630
1
Database Maintenance
DatabaseBackup - SYSTEM_DATABASES - FULL
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.723
1
Database Maintenance
DatabaseBackup - USER_DATABASES - DIFF
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.710
0
Database Maintenance
DatabaseBackup - USER_DATABASES - FULL
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.700
1
Database Maintenance
DatabaseBackup - USER_DATABASES - LOG
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.690
0
Database Maintenance
DatabaseIntegrityCheck - SYSTEM_DATABASES
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.683
0
Database Maintenance
DatabaseIntegrityCheck - USER_DATABASES
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.673
0
Database Maintenance
IndexOptimize - USER_DATABASES
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.663
0
Database Maintenance
Output File Cleanup
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.407
1
Database Maintenance
sp_delete_backuphistory
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.653
1
Database Maintenance
sp_purge_jobhistory
Source:
https://ola.hallengren.com
sa
2025-02-21 13:48:35.643
1
Database Maintenance
syspolicy_purge_history
No description available.
sa
2024-08-04 19:41:48.207
1
[Uncategorized (Local)]
Old_Redgate SQL Monitor Host Server
Server Name
Instance name
SQL Server version
Server OS
IP Address
RAM
CPU
System Manufacturer
KSOLA1SQL04
KSOLA1SQL04
2012
Windows Server 2012 Standard
10.103.13.63
12GB
4
VMware, Inc., System Model: 'VMware Virtual Platform'.
SQL Server Services information
![]()
Database Filenames and Paths
Database Name
file_id
name
physical_name
type_desc
state_desc
is_percent_growth
growth
Growth in MB
Total Size in MB
max_size
distribution
1
distribution
E:\MSSQL11.MSSQLSERVER\MSSQL\Data\distribution.MDF
ROWS
ONLINE
0
128
1
11958
-1
distribution
2
distribution_log
D:\MSSQL11.MSSQLSERVER\MSSQL\Data\distribution.LDF
LOG
ONLINE
1
10
0
8014
268435456
master
1
master
E:\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf
ROWS
ONLINE
1
10
0
3311
-1
master
2
mastlog
E:\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
LOG
ONLINE
1
10
0
4524
-1
model
1
modeldev
E:\MSSQL11.MSSQLSERVER\MSSQL\DATA\model.mdf
ROWS
ONLINE
0
128
1
3
-1
model
2
modellog
E:\MSSQL11.MSSQLSERVER\MSSQL\DATA\modellog.ldf
LOG
ONLINE
1
10
0
61
-1
msdb
1
MSDBData
E:\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf
ROWS
ONLINE
1
10
0
697
-1
msdb
2
MSDBLog
E:\MSSQL11.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf
LOG
ONLINE
1
10
0
285
268435456
RedGateMonitor
1
RedGateMonitor
E:\MSSQL11.MSSQLSERVER\MSSQL\DATA\RedGateMonitor.mdf
ROWS
ONLINE
0
1280
10
256475
-1
RedGateMonitor
2
RedGateMonitor_log
D:\MSSQL11.MSSQLSERVER\MSSQL\Data\RedGateMonitor_log.ldf
LOG
ONLINE
0
1280
10
6310
268435456
tempdb
1
tempdev
D:\MSSQL11.MSSQLSERVER\MSSQL\Data\tempdb.mdf
ROWS
ONLINE
1
10
0
8
-1
tempdb
2
templog
D:\MSSQL11.MSSQLSERVER\MSSQL\Data\templog.ldf
LOG
ONLINE
1
10
0
0
-1
SQL Server Agent jobs and Category information
Job Name
Job Description
Job Owner
Date Created
Job Enabled
[KSOLA1SQL04].5
Reads queues for Queued updating subscriptions
distributor_admin
2013-11-09 20:10:50.897
1
Agent history clean up: distribution
Removes replication agent history from the distribution database.
sa
2013-11-05 11:11:09.307
1
CommandLog Cleanup
Source:
https://ola.hallengren.com
sa
2016-09-08 19:34:08.830
1
DatabaseBackup - SYSTEM_DATABASES - FULL
Source:
https://ola.hallengren.com
sa
2016-09-08 19:34:08.680
1
DatabaseBackup - USER_DATABASES - DIFF
Source:
https://ola.hallengren.com
sa
2016-09-08 19:34:08.727
1
DatabaseBackup - USER_DATABASES - FULL
Source:
https://ola.hallengren.com
sa
2016-09-08 19:34:08.740
1
DatabaseBackup - USER_DATABASES - LOG
Source:
https://ola.hallengren.com Anthony E 04/04/2024 log backup job is not necessary for this database as it is in simple recovery mode so I disabled it.
sa
2016-09-08 19:34:08.750
0
DatabaseIntegrityCheck - SYSTEM_DATABASES
Source:
https://ola.hallengren.com
sa
2016-09-08 19:34:08.763
1
DatabaseIntegrityCheck - USER_DATABASES
Source:
https://ola.hallengren.com
sa
2016-09-08 19:34:08.773
1
DBA - IndexOptimize - ALL_DATABASES
Source:
https://ola.hallengren.com
sa
2017-03-06 10:21:21.073
1
Distribution clean up: distribution
Removes replicated transactions from the distribution database.
sa
2013-11-05 11:11:09.347
1
KSMSS1SQL10\SQL2008R2-Lending_MSCRM-20
No description available.
distributor_admin
2014-04-23 07:47:33.590
1
KSMSS1SQL10\SQL2008R2-Lending_MSCRM-Lending_MSCRM-21
No description available.
distributor_admin
2014-04-23 07:47:37.603
1
KSMSS1SQL10\SQL2008R2-Lending_MSCRM-Lending_MSCRM-KSMSS1SQLX04\SQL2016_-101
No description available.
distributor_admin
2017-09-17 08:23:26.207
1
KSMSS1SQL10\SQL2008R2-Lending_MSCRM-Lending_MSCRM-KSOLA1SQLX02\SQL2016_-103
No description available.
distributor_admin
2017-12-21 12:22:00.520
1
Output File Cleanup
Source:
https://ola.hallengren.com
sa
2016-09-08 19:34:08.820
1
Reinitialize subscriptions having data validation failures
Reinitializes all subscriptions that have data validation failures.
sa
2013-11-05 11:11:03.963
1
Replication agents checkup
Detects replication agents that are not logging history actively.
sa
2013-11-05 11:11:03.500
1
Replication Latency
No description available.
sa
2013-11-12 11:41:40.463
1
Replication monitoring refresher for distribution.
Replication monitoring refresher for distribution.
sa
2013-11-05 11:11:09.360
0
sp_delete_backuphistory
Source:
https://ola.hallengren.com
sa
2016-09-08 19:34:08.797
1
sp_purge_jobhistory
Source:
https://ola.hallengren.com
sa
2016-09-08 19:34:08.807
1
syspolicy_purge_history
No description available.
sa
2013-10-31 09:41:11.793
1
Old_SQL Monitor Console URL: http://sqlmonitor:8080/GlobalDashboard#Critical=false&Warning=false&Healthy=false&Group=&BM=&HistoryGroup=&HistoryTimespan=1440
Monitored Servers
Server name
Instance name
Cluster name
Version
Edition
otoesql1
otoesql1
prodsqlclotoemc.otoemc.local
SQL Server 2019
Enterprise Edition: Core-based Licensing (64-bit)
otoesql2
otoesql2
prodsqlclotoemc.otoemc.local
SQL Server 2019
Enterprise Edition: Core-based Licensing (64-bit)
otoesqlrpt1
otoesqlrpt1
prodsqlclotoemc.otoemc.local
SQL Server 2019
Enterprise Edition: Core-based Licensing (64-bit)
otoesqlrpt2
otoesqlrpt2
prodsqlclotoemc.otoemc.local
SQL Server 2019
Enterprise Edition: Core-based Licensing (64-bit)
AcmeUATSQL
AcmeUATSQL
uatsqlclotoemc.otoemc.local
SQL Server 2019
Enterprise Edition: Core-based Licensing (64-bit)
AcmeUATSQLRPT
AcmeUATSQLRPT
uatsqlclotoemc.otoemc.local
SQL Server 2019
Enterprise Edition: Core-based Licensing (64-bit)
mokan1sqlx05
mokan1sqlx05\sql2016_prod
kssqlclst03.grh.com
SQL Server 2016
Enterprise Edition: Core-based Licensing (64-bit)
mokan1sqlx06
mokan1sqlx06\sql2016_rpt
kssqlclst03.grh.com
SQL Server 2016
Enterprise Edition: Core-based Licensing (64-bit)
okrrk1sqlx07
okrrk1sqlx07\sql2016_prod
kssqlclst03.grh.com
SQL Server 2016
Enterprise Edition: Core-based Licensing (64-bit)
okrrk1sqlx08
okrrk1sqlx08\sql2016_rpt
kssqlclst03.grh.com
SQL Server 2016
Enterprise Edition: Core-based Licensing (64-bit)
okrrk1temp2
okrrk1temp2
preprodclst2.grh.com
SQL Server 2016
Enterprise Edition: Core-based Licensing (64-bit)
preprodrptsql2
preprodrptsql2\sql2016_pprod
preprodclst2.grh.com
SQL Server 2016
Enterprise Edition: Core-based Licensing (64-bit)
preprodsql02
preprodsql02\sql2016_pprod
preprodclst2.grh.com
SQL Server 2016
Enterprise Edition: Core-based Licensing (64-bit)
awlincsql2016
awlincsql2016\sql2016_dev
SQL Server 2016
Enterprise Edition: Core-based Licensing (64-bit)
ksmss1i3sql
ksmss1i3sql
SQL Server 2008 R2
Enterprise Edition (64-bit)
![]()
