Hi All,

I observered that some ssis activity(queries) from application side is going on one of the reporting database due to which cpu is going high ,but this activity is ruining daily based (it completes in 20 mins) but on sunday and monday ,this activy is taking more than 3 hours .

i have check there is no sql jobs running on the server at that time.

Could any one help me how to troubleshoot t know the reasion for taking more time to run sunday and monday.?

your thoughts or any quires are much appreciated.

May thanks.