Is PC2 6400 DDR2 okay for a SQL server?

[JohnVM]

[removed]

 

[ryderOCZ]

Hello John,

You want lots of ram that is nice and stable, since all current DDR2 board support DDR2-800 natively, I would get 800 MHz ram for sure, running higher frequencies in this case is not going to net you huge performance gains.

Anything at 800 with 4-4-4-x timings should serve you very well.

 

[NXIL]

Dear John,

does your motherboard accept ECC RAM?

http://www.newegg.com/Product/...8114%2CN82E16820148115

About 15% premium for ECC versus the other modules you listed.

Datamining: is hard drive speed the rate limiting step? 667 or 533 slightly slower than 800, but, overall system speed is not 1/3 slower, and with all that RAM getting ECC modules might be a good idea.

http://www.corsair.com/_appnotes/Ram_Guy_ECC.pdf

HTH

NXIL

 

[JohnVM]

Hey, I have a Gigabyte P35 DQ6 board

http://www.gigabyte.com.tw/Pro...ew.aspx?ProductID=2532

Looking at the specs I cant tell if it supports ECC or not -- perhaps someone else could?

For datamining, yes, the HDD's are most of the rate limiting factor. Interesting benefits to ECC.....

 

[Quiksilver]

Desktop motherboards do not support ECC.

 

[NXIL]

The P35 chipset does not support ECC.

The X38 does support DDR2 ECC; the 975X also took ECC ram.