Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2008
Thanks for the advice.
64bit is the plan. It will be SBS Premium so I do not think it is priced per CPU.
I assume SQL will make full use of the cores/cpu but I am not sure if I would be better off putting the cash for a 2nd cpu into drive/raid upgrades vs. cpu upgrades.
The data will initially be slightly less than 32GB but will soon exceed it.
Reliability is critical, performance is nice.
>
>First of all, use 64bit O/S and SQL Server (period). Performance gain is absolutely worth it.
>
>Multiple core processors cost less than multiple socket processors if you are using CPU licenses.
>
>Faster drives are always nice!
>
>How big is/are your database(s)? More memory is better until you can fit everything in RAM!
>
>RAID really depends on your reliability and performance requirements. Different types of RAID give different performance results. Normally a good external RAID controller will give better performance than an onboard controller using the same RAID level.
>
>I have customers that use simple mirroring and are very satisfied. I have others that are using high end RAID or SANs. Really depends on the need and the $$ available.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement