This site is a summating demo of a live monitoring application that uses SCOME

Developed by Drew Salem
Select the search type
 
  • Site
  • Web
Search
You are here:  SQL Server Reports > Job Contention (VM)
  |  Login
<u>About this report</u>

About this report

Minimize

You can use SCOME to measure job contention across all linked servers. Used in a Virtual Environment. Graphically as a chart as well as tabularly displays the names of all jobs across all linked SQL Servers, grouped by the time of the day, across a 24 hour period. Essentially used to spread jobs to prevent contention on physical VM servers. The total number of jobs is also given.

Job Contention
Use SCOME and msdb.dbo.sysjobs, msdb.dbo.sysjobschedules and msdb.dbo.sysoriginatingservers_view to determine job contention.

The data in this demo has been generated randomly and does not tally up with other job names/times in the application.

This help guide can be hidden using the minimise icon on the right.

  

Chart (tablular data below)

 

Total number of Jobs across all SQL Servers:
188


TimeName of ServerName of Job
12:00AMCorporate_2005_08Integrity Checks Job for DB Maintenance Plan System DB
12:00AMCorporate_2005_08Transaction Log Backup Job for DB Maintenance Plan User DB
12:00AMCorporate_2005_08User DB: Transaction Log
12:00AMDocManagement_06System Databases: Integrity Checks Job
12:00AMDocManagement_06User Databases: Integrity Checks Job
12:00AMDocManagement_06User Databases: Transaction Log Backup
12:00AMVM_Finance_01Integrity Checks Job for DB Maintenance Plan 'User DB'
12:00AMVM_Finance_01User DB: Integrity Checks
12:00AMVM_Leisure_03UPDATE WSID
12:00AMVM_Leisure_03User DB:Transaction Log Backup
12:00AMVM_RevsAndBens_04Reinitialize subscriptions having data validation failures
12:00AMVM_RevsAndBens_04User DB: Transaction Log
12:05AMVM_RevsAndBens_04VW31KSTONELIVE-AHTD-AHTD_02-3
12:05AMVM_RevsAndBens_04VW31KSTONELIVE-Keystone-Keystone_02-4
12:05AMVM_RevsAndBens_04VW32KSTONETEST-AHTD-AHTD_02-7
12:05AMVM_RevsAndBens_04VW32KSTONETEST-Keystone-Keystone_02-8
12:15AMDocManagement_06User DB: Integrity Checks
12:15AMDocManagement_06User General.CheckDB_Bak
12:15AMVM_Leisure_03User DB: Integrity Checks Job
12:30AMVM_Leisure_03User General.CheckIntegrity
12:45AM  
1:00AMCorporate_2005_08Import ls_fundshg
1:00AMCorporate_2005_08Optimizations Job for DB Maintenance Plan System DB
1:00AMCorporate_2005_08Optimizations Job for DB Maintenance Plan User DB
1:00AMCorporate_2005_08System DB: Optimizations Job
1:00AMDocManagement_06System Databases: Optimizations Job
1:00AMDocManagement_06User Databases: Optimizations Job
1:00AMVM_Finance_01Optimizations Job for DB Maintenance Plan 'User DB'
1:00AMVM_Leisure_03Rendezvous Audit Trail
1:00AMVM_Leisure_03System DB: Optimizations Job
1:00AMVM_Leisure_03User DB: Integrity Checks
1:00AMVM_Leisure_03User General.Complete_BAK
1:00AMVM_Leisure_03User General.Index Rebuild
1:00AMVM_Payroll_02fundsupdate
1:00AMVM_Payroll_02System DB: Optimisation
1:00AMVM_Payroll_02System DB: Optimisations
1:00AMVM_Payroll_02updatefundamt
1:00AMVM_RevsAndBens_04Expired subscription clean up
1:00AMVM_RevsAndBens_04System DB: Optimizations Job
1:00AMVM_RevsAndBens_04User DB: Integrity Checks
1:15AMDocManagement_06System DB: Integrity Checks
1:15AMVM_Leisure_03User DB: DB Backup
1:30AMDocManagement_06General User.CheckDB_Bak
1:30AMDocManagement_06System DB: Backup Job
1:30AMDocManagement_06User DB: Complete Backup Job
1:45AMDocManagement_06General System.CheckDB_BAK
1:45AMVM_Leisure_03System DB: Integrity Checks
2:00AMCorporate_2005_08DB Backup Job for DB Maintenance Plan System DB
2:00AMCorporate_2005_08System DB: Integrity Checks
2:00AMVM_Finance_01DB Backup Job for DB Maintenance Plan 'User DB'
2:00AMVM_Finance_01User DB: Backup Job
2:00AMVM_Leisure_03System DB: DB Backup
2:00AMVM_Leisure_03System DB: Integrity Checks
2:00AMVM_Leisure_03User DB: Complete Backup
2:00AMVM_Payroll_02System DB: Integrity
2:00AMVM_Payroll_02System DB: Integrity Checks
2:00AMVM_RevsAndBens_04System DB: Integrity Checks
2:00AMVM_RevsAndBens_04User DB: Full Backup
2:15AMDocManagement_06DataMigration_RoundManager
2:30AM  
2:45AMVM_Leisure_03System DB: DB Backup
3:00AMCorporate_2005_08GMS_REFERENCING SYSTEMS
3:00AMCorporate_2005_08System DB: Full Back up
3:00AMDocManagement_06Data Archive
3:00AMVM_Finance_01Optimizations Job for DB Maintenance Plan 'System DB'
3:00AMVM_Finance_01System DB: Integrity Check
3:00AMVM_Payroll_02System DB: Complete Back up
3:00AMVM_RevsAndBens_04System DB: Full Back up
3:00AMVM_RevsAndBens_04User DB: Optimizations Job
3:15AMVM_Leisure_03System General.CheckDB_Bak
3:30AM  
3:45AM  
4:00AMCorporate_2005_08User DB_.User DB_ Transaction Log
4:00AMVM_Finance_01Integrity Checks Job for DB Maintenance Plan 'System DB'
4:00AMVM_Finance_01System DB: Optimizations Job
4:00AMVM_Leisure_03System DB: Integrity Checks
4:15AMCorporate_2005_08User DB: Complete Backup
4:15AMCorporate_2005_08User DB: Optimizations Job
4:30AMCorporate_2005_08SPADE Exceptions Import
4:30AMCorporate_2005_08User DB: Optimizations Job
4:45AM  
5:00AMCorporate_2005_08User DB: Integrity Checks Job
5:00AMDocManagement_06UserDB.CheckDB_BAK
5:00AMVM_Finance_01DB Backup Job for DB Maintenance Plan 'System DB'
5:00AMVM_Finance_01System: DB Backup Job
5:00AMVM_Leisure_03System DB: Complete Backup
5:15AM  
5:30AMCorporate_2005_08User DB_.User DB_ DB Backup Job
5:45AM  
6:00AMDocManagement_06User DB: Transaction Log Backup
6:00AMDocManagement_06User General.CheckDB_BAK
6:00AMVM_Finance_01User DB: Transaction Log
6:00AMVM_RevsAndBens_04User DB: Tran Log
6:05AMCorporate_2005_08LLPG
6:15AMCorporate_2005_08GMS_PLANNING_APPS
6:15AMCorporate_2005_08LLPG
6:15AMCorporate_2005_08User DB: DB Backup Job
6:30AMCorporate_2005_08GMS_PLANNING_APPS
6:30AMCorporate_2005_08GMS_REFERENCING_SYSTEMS
6:30AMCorporate_2005_08User DB: Optimizations
6:40AMCorporate_2005_08Update_ctax_balances_into_logsmart_new
6:45AMVM_Leisure_03Update Usage on HIC
7:00AMCorporate_2005_08LLPG_Exceptions
7:00AMCorporate_2005_08update stats agresso
7:00AMCorporate_2005_08User DB: Transaction Log Backup
7:00AMVM_Leisure_03User DB: Transaction Log
7:00AMVM_Payroll_02User DB: Optimisations
7:00AMVM_Payroll_02User DB: Transaction Log Backup
7:00AMVM_Payroll_02User DB: Transactional Logs
7:15AMCorporate_2005_08LLPG_Ctax_Bands
7:15AMCorporate_2005_08LLPG_Exceptions
7:15AMCorporate_2005_08System DB: Optimizations
7:15AMCorporate_2005_08System DB: Optimizations Job
7:25AMCorporate_2005_08Update ePay Trans
7:30AMCorporate_2005_08Update_saffron_balances_into_logsmart
7:30AMVM_Payroll_02CheckForFailedJobs
7:45AMCorporate_2005_08System DB: Integrity Checks
8:00AMCorporate_2005_08System DB: Complete Backup
8:00AMCorporate_2005_08System DB: DB Backup Job
8:00AMDocManagement_06System General.CheckDB_Bak
8:00AMVM_Payroll_02hbc_ctax_balances_loader_TEST
8:15AM  
8:30AMCorporate_2005_08User DB: Integrity Checks
8:45AM  
9:00AMDocManagement_06User General.Reindex
9:15AM  
9:18AMDocManagement_06User General.TLog
9:20AMVM_RevsAndBens_04Agent history clean up: distribution
9:20AMVM_RevsAndBens_04Replication agents checkup
9:24AMDocManagement_06General User.TLog
9:30AMDocManagement_06User General.TLog
9:30AMVM_Leisure_03User General.TLog_BAK
9:36AMDocManagement_06User General.T_Log Bak
9:45AM  
10:00AMDocManagement_06UserDB.TLog_BAK
10:00AMVM_Leisure_03UserDB.TLog_BAK
10:00AMVM_Payroll_02UserDB.TLog_BAK
10:15AMDocManagement_06System General.CheckDB_Bak
10:30AMVM_RevsAndBens_04System DB: Backup
10:45AM  
11:00AM  
11:15AM  
11:30AM  
11:45AM  
12:00PMVM_Payroll_02CheckEnoughDiskSpace
12:15PM  
12:30PM  
12:45PM  
1:00PMDocManagement_06System General.CheckDB_BAK
1:15PM  
1:30PM  
1:45PM  
2:00PM  
2:15PM  
2:30PM  
2:45PM  
3:00PMCorporate_2005_08Integrity Checks Job for DB Maintenance Plan User DB
3:00PMVM_Payroll_02TranGrowthAlert
3:15PM  
3:25PMVM_RevsAndBens_04Replication monitoring refresher for distribution.
3:30PM  
3:45PM  
4:00PM  
4:15PM  
4:30PM  
4:45PM  
5:00PM  
5:15PM  
5:30PMVM_RevsAndBens_04Backup.Subplan_1
5:45PM  
6:00PM  
6:15PM  
6:30PMVM_Leisure_03UserDB.CheckDB_BAK
6:45PM  
7:00PMCorporate_2005_08DB Backup Job for DB Maintenance Plan User DB
7:00PMCorporate_2005_08User DB: Optimizations Job
7:00PMDocManagement_06System Databases:DB Backup Job
7:00PMVM_Leisure_03eXpress_Fuzzy_Index
7:00PMVM_Leisure_03PayrollContacts_Live
7:00PMVM_Leisure_03RoundManager_DataMigration
7:00PMVM_Leisure_03User DB: Optimizations Job
7:00PMVM_Leisure_03User DB: Transaction Log
7:00PMVM_Payroll_02General_UserDB.CheckDB_BAK
7:00PMVM_Payroll_02User DB: Optimisation
7:00PMVM_Payroll_02User DB: Transaction Log Backup
7:00PMVM_RevsAndBens_04User DB: Optimizations Job
7:15PM  
7:30PM  
7:45PMVM_Payroll_02UserDB.CheckDB_BAK
8:00PMCorporate_2005_08coins_councillors_import
8:00PMDocManagement_06User Databases: DB Backup Job
8:00PMDocManagement_06User General.CheckDB_BAK
8:00PMVM_Leisure_03SystemDB.CheckDB_BAK
8:00PMVM_Leisure_03User DB: Integrity Checks
8:00PMVM_Payroll_02User DB: Integrity
8:00PMVM_Payroll_02User DB: Integrity Checks
8:15PM  
8:30PM  
8:45PM  
9:00PMCorporate_2005_08User DB: Integrity Checks
9:00PMVM_Leisure_03User DB: Complete Backup
9:00PMVM_Leisure_03UserDB.Indexing
9:00PMVM_Payroll_02User DB: Complete Back up
9:00PMVM_Payroll_02User DB: Complete Backup
9:00PMVM_RevsAndBens_04User DB: Integrity Checks
9:15PM  
9:30PM  
9:45PM  
10:00PMVM_RevsAndBens_04System DB: Integrity Checks
10:15PM  
10:30PMDocManagement_06Trent_Contacts
10:45PM  
11:00PMCorporate_2005_08User DB: Complete Back Up
11:00PMVM_RevsAndBens_04User DB: Complete Back Up
11:15PM  
11:30PM  
11:45PM  
















Powered by phdcc.CodeModuleFree 01.01.03
Failed Jobs   |   Unrun Jobs   |   Disk Space   |   Agent Status   |   Tran Log Size   |   Test Restores   |   Logs by Server   |   Recovery Model   |   Index Analysis   |   Job Contention (VM)   |   Licensing   |   Disk Space History   |   Log Size History