We customize the autoload process to have multiple autoloads (yes it is needed). Each Autoload is separated by 15-second interval but, some of the autoloads can run in excess of the traditional 15 minute usually set. ( I think that is part of the issue). I see (IN THE AUTOLOAD LOG) that each autoload spawns a separate SAS session where each session checks the metadata server for EVERY table in THAT autoload session to see if the table needs to be updated. This is where I believe we push the metadata server to it's limits by all the calls for status. Am I wrong? should I beef up the metadata server? lets say we have: Autoload1 5 tables Autoload2 (delayed 15 sec) 25 tables Autoload3 (delayed 30 sec) 10 tables there a call to the metadata server for each table which takes up resoures.
... View more