Need urgent help !!!!!
In our Teradata database environment, reports are running very slow and business is impacting for the same.
We face this issue mainly on weekdays. In the peak hours from 9 AM to 2 PM the No. of login sessions will start increase same delay count also increases. We have also observed that, in the peak hours ETL team runs the ETL scripts (Insert, Update, delete) as well.
All the stats are up to date. Avg query count per day = 50000. TASM setting is also looks optimal.
Kindly let me know what would be the reason for slowness issue. Let me know how to identify the solution for this and what all parameters I need to consider to resolve the issue.
There could be many reasons. There can be many questions
What are the configurations you have...nodes, amps.....
How many users?
Size of tables (it may increase over time). Skewed tables may there due to bad design
Questions like space allocation, prioritizations, network, I/O contention
It looks like during week days, lots of people are using the systems.
Maybe an online backup.......
The reason I throw something is that there maybe a point you may have overlooked.
Maybe you can give more details and others can throw some lights on this.
the way you describe it, the TASM settings don't look optimal :-)
But there's no way to deal with that doing a post here on DevEx.