February 2, 2007 at 3:20 pm
Is there a rule of thumb on settings for a particular machine?
I have a Windows 2003 server with 16GBs of RAM and 8 processors.
Whats the proper switch to be used for 2003?
How much memory should I allocate for SQL?
I have a restore operation that is taking several hours on this machine. On a machine that is not even close to the same spec runs in about 30 minutes.
I am guessing I didn't configure something correctly for this large of a setup.
February 2, 2007 at 3:32 pm
With 16 GB, I woud give at least 14 GB to SQL Server. I don't know if it is a rule of thumb or not, but I will usually give all but 1 GB to SQL Server on servers with up to 16 GB. Some say that it is better to give the OS 2 GB when you have 16 GB and up on your server. I would start with 14 and maybe monitor the memory and see if the OS is really in need of 2 GB.
As for your restore, is there a difference in the disk subsystems between the 2 servers? Can you give us more details on the server specs and disk configuration?
February 2, 2007 at 4:09 pm
It depends on what edition of sql and windows you are using...
If you are using SQL SE then scrach the folllowing...
If this server is not part of the cluster then you can allocate (Total memory - 2 GB) to sql...
you need to enable AWE and do not use /3GB...
How to configure SQL Server to use more than 2 GB of physical memory
http://support.microsoft.com/kb/274750
http://www.sql-server-performance.com/awe_memory.asp
MohammedU
Microsoft SQL Server MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply