SQL Server Performance

Using Views vs. Table (CPU and Memory Usage) in SSAS

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by wookies, Feb 18, 2009.

  1. wookies New Member

    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,
  2. satya Moderator

    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?

Share This Page