You are here: Re: SQL Configuration « MsSQL Server « IT news, forums, messages
Re: SQL Configuration

Posted by Erland Sommarskog on 10/03/07 21:44

Neil (nospam@nospam.net) writes:
> First, re. the 2 GB of RAM, considering that the db is not huge (two
> main tables have about 60,000 records each; a few other tables with a
> few thousand records; and then a bunch of smaller records); there are
> only about 50 users max; most of the activity is read-only, very little
> writing; and the hardware is brand new; do you think that would be
> enough, or should I push for more? I wouldn't count on the database
> being well-tuned.

More memory is not going to hurt, but the database size you indicate
certainly does not scare me.

> Second, re. the size of the disks, when you said "make sure there is at
> least 50 GB," wasn't sure if you meant 50 GB total, or 50 GB free space
> after SQL Server is installed. Here are the specs for the disks:

I meant 50 GB in total. You are not going to fill up 36 GB on the spot,
but the strategy of Microsoft definitely is to bury a lot of stuff under
C:\Windows.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация