Archives of the TeradataForum

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

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

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>>