All Forums Database
Teradata_User1 13 posts Joined 04/14
21 Jul 2014
Teradata Reports are running very slow

Hello Experts,
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. 
Regards,
Mahendra.

Raja_KT 1246 posts Joined 07/09
25 Jul 2014

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.
Questions galore!!!
Maybe you can give more details and others can throw some lights on this.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

dnoeth 4628 posts Joined 11/04
26 Jul 2014

Hi Mahendra,
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.
 

Dieter

You must sign in to leave a comment.