October 21, 2008 at 7:02 am
Hi All,
I configured EventsManager database(to store events from all the servers) in SQL server 2000 with SP4 and windows server 2003.
Every day the database is growing approximately 9GB.
I provide the following recommedation
a) Hard drive : 3TB
* Planning to store 1 year old data
b) Physical memory requirement : 25GB
Maximum SQL server memory configuration : 21GB
Minimum SQL server memory configuration : 5GB
with AWE, /PAE, Lock pages in memory
c) Processor : hyperthread type and not sure about the configuration
Please suggest me for the processor configuration and also for other recommedation.
BR,
Parthipan.S
October 23, 2008 at 6:11 pm
1. What is the data going to be used for ?
2. How many users will be accessing this server ?
3. Are you planning to run reporting of this server ?
Depending upon the usage, the number of processors can be extimated.
If this is just for generating trend reports once in a while then i guess 4 processors INtel Xeon or AMD opteron series @2GHZ would work.
If there will be a bunch of users accessing reports and data then i would pump number of processors to 8.
You should consider formatting your SAN in blocks of 64KB for data disks and 8KB for log disks cause Sql server reads and writes in respective block sizes.
October 23, 2008 at 6:25 pm
Not exactly sure what you are wanting to achieve but first off... Make sure you are running Enterprise Edition of your OS and SQL otherwise you are going to find yourself with a TON of unused memory that you thought you could access. If you have standard SQL and EE OS.. your SQL will not see all the memory even if you use the /AWE and /PAE switches.
Good Luck and hope this helps
-D-
DHeath
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply