All Forums Database
Kishore_1 208 posts Joined 03/10
29 Aug 2014
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

You must sign in to leave a comment.