Increase in Response Time

Database
Enthusiast

Increase in Response Time

We are experiencing increase in response time of queries of a workload during a particular time of the day.What could be the possible reasons for this?How to analyse the root cause?

Appreciate your help!!

Tags (1)
1 REPLY
Enthusiast

Re: Increase in Response Time

Kishore,

a good starting point:

First determine if the TASM settings for this worklaod have changed.

Then use your DBQL tables to analyze what  else ran during this particular timeframe or if this workload ran anything different than normal. 

Rglass