We have more than 20 GB of Data on our Live site and we are having performannce issues as a bottleneck.. I wanted to have a suggestion can "Storage Design Wizard" help us in this matter... and in this matter I wanted to know the Cube Definition... as it is mentioned in one of your articles named as "Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: The Storage Design Wizard ".. thanx
http://www.sql-server-performance.com/wp_msas_1.asp Fyi. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.