Re: Memory Recommendations for 8-way Server

With that number of OLAP users, I would probably want enough memory so that
just about the entire database is held in cache. but of course, that depends
upon the nature of the data, the queries, the disk subsystem and several
other factors. With little financial constraints, I would most likely jump
up to 16 (if not 32) GB of memory.

Are you using SQL 2000 or 2005?
Using Windows 2000 or 2003?
Using 32 or 64 bit OS and SQL?

Have you monitored the Buffer Cache Hit Ration? Procedure Cache Hit Ratio?

You may wish to check out the various counters that will verify that your
users are memory constrained. Here are some resources to help you determine
how much memory is needed in your situation:

Performance Audit
http://www.sql-server-performance.com/articles_audit.asp
http://www.sql-server-performance.com/sql_server_performance_audit10.asp

Performance -Link Server Performance Tips
http://www.sql-server-performance.com/linked_server.asp

Performance Monitoring
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/operations.mspx
Performance WP's
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
Troubleshooting Performance 2005
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=224587 Troubleshooting App Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
http://sqldev.net/misc/WaitTypes.htm Wait Types
http://support.microsoft.com/?id=271509 Script to Monitor Blocking

Performance Tuning -Articles
http://www.sql-server-performance.com/articles_performance.asp

Performance Tuning -Hardware
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp




--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Michael Karolitzky" <MichaelKarolitzky@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:7881A5E3-CFE2-42C8-AADC-3FE1FB71426C@xxxxxxxxxxxxxxxx
2 DB's one large at 25Gig, 1K users and above, OLAP connections

Mike

"Arnie Rowland" wrote:

Not enough information.

How many databases, how large are the databases, how many users on each
database, what type of databases (OLTP/OLAP)?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to
the
top yourself.
- H. Norman Schwarzkopf


"Michael Karolitzky" <MichaelKarolitzky@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in
message news:7DBABCA1-4D43-420B-9E8C-1F8851368E83@xxxxxxxxxxxxxxxx
We are upgrading our 2000 SQL server running Server 2003 Enterprise
(x86)
from 4 procs to 8. The server is currently configured with 8Gigs of
RAM.
Is
this enough? What is the recommended amount? I am concerned that too
little
memory will starve the CPU's.

Thanks

Mike





.

Relevant Pages

  • Re: Database count support in Analysis Services 2005
    ... but you can install more then 1 instance like you can do with SQL Server. ... AS2000 load dimensions into memory when you starts the service, ... AS2005 keep in cache the calculation results, while in AS2000 the cache is ... but I have not tested a so large number of databases, so I don't know how AS ...
    (microsoft.public.sqlserver.olap)
  • Re: Cached memory never gets released
    ... Stock linux 2.4.26 kernel. ... Due to flash bug 3M of memory gets lost due to font memory getting lost ... The output of "free" cache number steadily grows. ... longer to exhaust all of system memory with the cache. ...
    (Linux-Kernel)
  • Re: Problem: Creating a raw binary string
    ... > While its true that a 64-bit cpu will move twice the data per instruction it ... > Memory bus width plays an important role here and unless it too is widened / ... You are forgetting the two levels of cache in the processor. ... The memory chips are addressed in Row col fashion. ...
    (alt.comp.lang.borland-delphi)
  • Re: Is Greenspun enough?
    ... Most OSes memory map executables directly from the file system so code doesn't pollute the file cache or swap space. ...
    (comp.lang.lisp)
  • Re: Superstitious learning in Computer Architecture
    ... Without a LOT of logic or some other better approach, re-executing the instructions requires re-decoding and it ties up the cache memory bus transferring more data as instructions than the instructions are working on. ... The concept of cache is fundamentally flawed in that it STILL restricts access to one word per clock cycle, when a single modern ALU can easily use 5 plus whatever is eaten up with instruction accesses. ... The size of an optimizing compiler is proportional to the SQUARE of the size of the language times the SQUARE of the complexity of the machine - because all interactions must be considered. ...
    (comp.arch.arithmetic)