execution time for a query

Not sure about this one.  We're querying directly against sys.dm_exec_query_stats for this data.  Could it possibly be running in multiple databases within the same instance?  Have you checked the job logic to make sure there isn't a loop or conditional statement causing it to run multiple times?  I'm just wondering why SQL Server is telling us it's running 4 times...

It is DPA telling us the query executes 4 times daily. We are not using any loop.

The query is in an ETL of SSIS package, it is a data source of data flow in the package, it should only execute once.

What I meant was when we query the execution count from sys.dm_exec_query_stats, we get 4 executions, not 1.  I'd recommend going after the raw data to validate this (take DPA out of the picture).  For more assistance with that, can you submit a support ticket from your portal?

When you say submit a support ticket from your portal, what do you mean?

From our DPA application? I cannot find a place to submit ticket in the application.

Thanks

anncao,

The Solarwinds customer portal for a support case can be found here. customerportal.solarwinds.com  If you have any problems logging into your customer portal, please reach out to customerservice@solarwinds.com.