Posted by Greg D. Moore \(Strider\) on 10/03/07 11:22

"Neil" <nospam@nospam.net> wrote in message
news:8OFMi.1576$oA2.30@nlpi068.nbdc.sbc.com...
> Well, we certainly don't have anywhere near 14 million transactions a day
> (most of the activity is reads, and, even that is not a huge amount). But
> with only 2 GB RAM, what would be left for SQL, 1 GB? That doesn't seem
> like a lot.

Again, depends a lot on your DB and its needs. If the DB is 10 GB in size
but 90% of all queries involve 250MB of data (which is not uncommon) then
you'll be fine.

So it's really hard to say. From a previous post of yours, I'd say it
sounds like it should be fine. But memory is fairly cheap, toss in another
2GB if you're concerned (above that you probably need to upgrade your OS/SQL
versions, which is not so cheap.)


--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]