Teradata Reports are running very slow

Database
Enthusiast

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.

2 REPLIES
Enthusiast

Re: Teradata Reports are running very slow

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.

Junior Contributor

Re: Teradata Reports are running very slow

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.