Which server to put SQL Server 2005 Express Edition on?

[Munter]

One thing that does occure to me. If the SQL DB is only 350MB (and not going to grow too much) can you get SQL to load it fully into ram. That way only writes will go to the disk. And they can be cached writes, so written out when the disk isn't busy doing other stuff.

I may however be giving Microsoft too much credit thinking you can do such things.

[buggalugs]

Munter said:

One thing that does occure to me. If the SQL DB is only 350MB (and not going to grow too much) can you get SQL to load it fully into ram. That way only writes will go to the disk. And they can be cached writes, so written out when the disk isn't busy doing other stuff.

I may however be giving Microsoft too much credit thinking you can do such things.

We're not exactly talking about the doomsday book here

[pcwilson]

Hi Guys

Thanks for all the great advice. I'm going to go ahead and put the database on the DC. I now understand the issues with this, but I think it's the lesser of two evils. I'll monitor the DC closely and if it's struggling then I'll have the figures to justify additional disks or a dedicated server.

Cheers
Phil