Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Server Analysis Services Hardware Configuration

Posted on 2008-10-10
3
Medium Priority
?
917 Views
Last Modified: 2016-02-13
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.
0
Comment
Question by:rehan_k99
  • 2
3 Comments
 
LVL 51

Assisted Solution

by:Mark Wills
Mark Wills earned 220 total points
ID: 22693442
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
0
 
LVL 1

Accepted Solution

by:
rehan_k99 earned 0 total points
ID: 22700531
I found Cord with 4 gb of memory with faster processor should best configuration
0
 
LVL 1

Author Comment

by:rehan_k99
ID: 22700571
yes this config is okay
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question