Re: Memory Recommendations for 8-way Server

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: Enterprise to Standard
    ... "Arnie Rowland" wrote: ... Most good judgment comes from experience. ... All I'm doing is uninstalling EE and installing SE on my current sql ... My plans were to backup the databases, uninstall EE, install SE (with ...
    (microsoft.public.sqlserver.setup)
  • Re: How do I find out SQL Server instance name and username?
    ... the application provider. ... I suspect that they have the MSDE server and ... databases 'locked' down to prevent customers from 'accidentally making ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.msde)
  • Re: Enterprise to Standard
    ... Master, model, msdb, tempdb are also installed. ... User databases 'should' not ... installation. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.setup)
  • Re: Hide databases in EM/QA
    ... of all databases on the server EVEN if the login does not have permissions ... Most good judgment comes from experience. ... able to see all the user databases although they can only ... In Query Analyzer, the databases will be restricted or ...
    (microsoft.public.sqlserver.security)
  • Re: Hide databases in EM/QA
    ... While I agree that the databases won't show up in the Object Explorer, ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.security)