Hi All, I have a 8 cubes and 1 virtual cubes in my AS Database. this 8 cubes consist of views(Dimensions and Fact) intead of physical table. I wanted to replace all of the views with the physical table. is there a way to compare and monitor the CPU and Memory usages of the views against table? Thanks,
Welcome to the forums. Why do you want to do that, is there any underlying issues that you are facing with this approach? What is the hardware used for this SQL instance? What is the memory setting?