- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Strange SQL Performance on different times
I have an ETL process which runs more than 2 hrs 20 min if executed between 5 am and 7 am.
But what we find surprisingly the same ETL batch process executes in 1 hr. 30 min on a different time other than 5 am to 7 am.
DBA team and Linux team confirmed that there are no other jobs running between 5 am and 7 am.
When I take a specific job to analyze what is going on, which was running fine on the odd timing it took 320 seconds where on regular it took 844 seconds...following is what I got from ASH.
Can someone please guide me what should I look into further...