We have sql server 2008 r2 prod server,on which user is facing slowness on every early Monday Morning.At that time Sql is taking 100% cpu.
I have checked at that time for any schedule jobs that were running ,i found that some daily maintenance jobs(like db report backup status,failed jobs) were running on that time frame.These are running daily and i think this jobs will not cause any issues as it running daily and other days performance is normal at that time.
Is their any other way were i can find exact cause of the issue?
Will any other things like( anti virus,..etc,user activity at that time,application activity etc) will cause performance?
Your suggestions and help is much appreciated.