Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Jul 2003 @ 20:59:48 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Alternating Account Strings via Microstrategy Logon
 
From:   Yonina Schuchman

We have multiple Microstrategy projects. The user logs on to each project with the same ID. Within each project the ID is mapped to a group logon with the necessary account info. That way, our merchandising queries (tactical) use a different resource partition with a higher weight than our marketing queries (killer queries). Each of the Teradata/Microstrategy group logons use milestone limits so they all come in at Rush within the specific partition and then gradually are degraded as CPU is consumed. Starting out at Rush allows the lookup queries to return to the user in subsecond response time.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023