Toad World® Forums

WorkloadAnalysis Extended Event

The information collected by the WorkloadAnalysis extended event is really wonderful. Is there much overhead in capturing details of each query that is run on the SQL instance 24/7? Workload analysis is enabled by default so I’m hopeful that it is very lightweight.

Thanks,

Howard

Hi Howard,

Normally Workload Analysis collection doesn’t cause an impact on your monitored instance. But because this collection uses extended events some 2008 instances could experience collection timeout issues due to a documented Microsoft defect. This would be an apparent issue if it were to happen.

Gita

Visit our Support Portal
https://support.quest.com/spotlight-on-sql-server-enterprise/11.6

Thanks Gita.

Howard