SQL query running frequently
It seems like the monitoring continuously asks SQL servers for backup-sets.
It does that by issuing statements like the following:
select substring(convert(nvarchar(22),backup_finish_date,102),1,4),substring(convert(nvarchar(22),backup_finish_date,102),6,2), substring(convert(nvarchar(22),backup_finish_date,102),9,2) from msdb..backupset
where database_name = 'WSS_Content_Flender_StdDocuments' order by backup_set_id desc
This query is ran by the KOQDBD cursor ("Database Detail" attribute group), to obtain the "Dump Tran Date" attribute.
You need to increase the intervals for historical data collection and situations for the "Database Detail" attribute group (KOQDBD).
In addition, the KOQDBS calls KOQDBD as a pre_cursor (KOQDBS runs every 180 seconds as it is an interval-driven cursor). You can force the KOQDBS cursor to become a demand-driven cursor by going into the file C:\IBM\ITM\TMAITM6\koqcoll.ctl, search for this:
, and modify it to:
More support for:
Tivoli Composite Application Manager for Microsoft Applications
Microsoft SQL Server Agent - 5724B96MO
Software version: 6.2.1, 184.108.40.206, 6.2.2, 6.2.3
Operating system(s): Windows
Reference #: 1609710
Modified date: 05 March 2013