Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

memory v's size of database

Oct 28, 2003, 3:48 AM
Dagk
Novice (10 posts)
Dagk's avatar
Oct 28, 2003, 3:48 AM
Post #1 of 2
Views: 3877
Shortcut
Quote Reply
memory v's size of database
Hi,

Is there any rule/recommendation for the amount of memory a SQL SERVER 2000 server should have in relation to the size of the database? Thanks.
Oct 28, 2003, 11:55 AM
Alex
Administrator (9387 posts)
Oct 28, 2003, 11:55 AM
Post #2 of 2
Views: 3638
Shortcut
Quote Reply
Re: [Dagk] memory v's size of database In reply to
Hi,

I'm not sure about MS SQL server, but as a general rule of thumb, if you can fit the entire database in memory, you should try. =)

Cheers,

Alex
--
Gossamer Threads Inc.