General procedures used by dbOmnibus are described below.
- sp_CaptureAgentJobList [Util]
- sp_CaptureAgentJobsFailed [Util]
- sp_CaptureAgentJobsLongRunning [Util]
- sp_CaptureCPUUtilization [Util]
- sp_CaptureDatabaseFiles [Util]
- sp_CaptureDatabases [Util]
- sp_CaptureDatabasesInfo [Util]
- sp_CaptureDatabasesLastBackedup [Util]
- sp_CaptureDatabasesLastUsed [Util]
- sp_CaptureDatabasesQueryStore [Util]
- sp_CaptureDataDriveSize [Util]
- sp_CaptureDbBackups [Util]
- sp_CaptureDbDetails [Util]
- sp_CaptureDbSize [Util]
- sp_CaptureDbUsage [Util]
- sp_CaptureDMOSScheduler [Util]
- sp_CaptureExecRequests [Util]
- sp_CaptureIoStats [Util]
- sp_CapturePerfMonCounters [Util]
- sp_CaptureSpwho2Plus [Util]
- sp_CaptureSqlCounters [Util]
- sp_CaptureSqlLogins [Util]
- sp_CaptureSqlPagedMemory [Util]
- sp_CaptureSqlPhysicalMemoryUsed [Util]
- sp_CaptureSqlServerLogs [Util]
- sp_CaptureSqlVitals [Util]
- sp_CaptureStartup [dbo]
- sp_CaptureTempDBUsage [Util]
- sp_CaptureTempDBUsage2 [Util]
- sp_CaptureVitals [Util]
- sp_CaptureVitals_Configuration [Util]
- sp_CaptureVitals_Misc [Util]
- sp_CaptureVitals_ServerProperties [Util]
- sp_CaptureVLF [Util]
- sp_CheckDatabaseFilesHealth [Util]
- sp_CheckDatabasesHealth [Util]
- sp_CheckTraceFlag [Util]
- sp_CleanseSqlServerLogs [Util]
- sp_EchoMessage [Util]
- sp_FindEventsDaily [Util]
- sp_GetAlertItemName [Util]
- sp_GetConfigValue [Util]
- sp_GetDescription [Util]
- sp_GetInstallDate [Util]
- sp_GetIsAzureMI [Util]
- sp_GetIsEmailOk [Util]
- sp_GetIsExistObject [Util]
- sp_GetIsOverride [Util]
- sp_GetProductLevelCode [Util]
- sp_GetProductUpdateLevelCode [Util]
- sp_GetSqlVerCode [Util]
- sp_GetSqlVersion [Util]
- sp_GetVersion [Util] X
- sp_IdentifyAgentJobsFailed [Util]
- sp_IdentifyCompatabilityLevelIssues [Util]
- sp_IdentifyCPUUtilization [Util]
- sp_IdentifyDbFileIssues [Util]
- sp_IdentifyDBsNotBackedup [Util]
- sp_IdentifyDbStateIssues [Util]
- sp_IdentifyDriveSpace [Util]
- sp_IdentifyFileGrowth [Util]
- sp_IdentifyLSNotBackedup [Util]
- sp_IdentifyReplication [Util]
- sp_IdentifySqlVitalsIssues [Util]
- sp_IdentifyStaleDbUsage [Util]
- sp_IdentifyTraceFlags [Util]
- sp_InEachDb [Util]
- sp_InitCadenceRetention [Util]
- sp_InitFeatures [Util]
- sp_InitializeSqlServerLogIgnore [Util]
- sp_InsertChange [Util]
- sp_InsertEvent [Util]
- sp_InsertHealth [Util]
- sp_InsertLog [Util]
- sp_InsertPerfMonCounter [Util]
- sp_LookupSqlVital [Util]
- sp_NotifyAgentJobsLongRunning [Util]
- sp_PrintDiskFile [Util]
- sp_PruneTable [Util]
- sp_PruneTableMaint [Util]
- sp_RenumberEvents [Util]
- sp_RenumberHealthHistory [Util]
- sp_RunNow [Util]
- sp_SendEmail [Util]
- sp_SetCadence [Util]
- sp_SetDefault [Util]
- sp_SetRetention [Util]
- sp_UpdateConfig [Util]
- sp_UpdateDatabase [Util]
- sp_UpdateFeatures [Util]
- sp_UpdateLastCaptured [Util]
- sp_UpdateOverrides [Util]
- sp_UpdateVitals [Util]
- sp_ValidateJobEnabled [Util]
Page Last Updated: 21 September 2025