• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 924
  • Last Modified:

SQL Server Analysis Services Hardware Configuration

I would like to know the Best Hardware Configuration for SQL Server Analysis Services 2005 i.e  RAM size,
Application, and other SSAS Properties need to Set for Better MDX Query Performance.
  • 2
2 Solutions
Mark WillsTopic AdvisorCommented:
Really depends on size...

Generally speaking, bit more like a web server - tons of memory, bit of disk (fast disk), it will likely be swapping (again depends on cube size a bit) so probaly sas disks instead of sata. And can be compute bound from time to time - depending on what / how you build some of the MDX / DMX queries...

use quad core CPU - plent of caching. RAID1 73 gig sas disks for system, same again for cubes - maybe even larger depending on number and size of cubes. Min 8 gig of memory, Windows Enterprise + SQL Enterprise probably on 64-bit op-sys, and then can add memory as needed.

If you can give an indication of size, and nature of cubes, then could give a better indication...

there is a performance guide which you might find helpfull... http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc
rehan_k99Author Commented:
I found Cord with 4 gb of memory with faster processor should best configuration
rehan_k99Author Commented:
yes this config is okay
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now