Thanks cmccoy2.
The queries are running quick however it's the exports that are taking a very long time. If one task list has, let's say 50 queries......and let's say on 5 of those queries have data returned. Every query is set to export to a network share to a .csv file. CCS should not export empty files but only those files that have data.
In one example, I have a task list that has 65 queries. On any given day, 10 will return data and therefore should be exported. The queries themselves complete fast, however the exports and the entire task list takes over 2 hours to complete. If I were to manually rerun a query with an export of a file maybe 100k, it completes in seconds. The issue seems to be when the entire schedule runs that all task lists take a while - Exports being the issue.
Symantec had my add a couple setting to the registry
GlobalLovJobLimit 0x00000064 - not sure
GlobalNormalJobLimit 0x00000064 - not sure
LowJobLimit 0x00000006 - allows for 6 task lists to run at once (this actually helped schedule finish sooner)
NormalJobLimit 0x00000006 - allows for 6 task lists to run at once (this actually helped schedule finish sooner)
Basically looking to find out how to optimize my servers to run these schedules faster. They were fine prior to the rebuild a few months ago. (Prior to my starting working here).
Thanks