Setting Spool Space Limit for Profiles

Database
Enthusiast

Setting Spool Space Limit for Profiles

We are having ~1000 Business Users, who are accessing the Teradata Production system.

The business users are assigned to a common profile.We want to set a spool space limit for the business users at profile level.

How can we get the value of spool space that will enable the buiness user's queries to run smoothly.

At any point in time 60% of the business users are active.

What are things that needs to be considered?What does Teradata recommend?How can we set TASM rules(filters,throttles) for the business users?

What is the starting point for analysis?

Appreciate your help!!

Thanks,

Kishore

Tags (2)