|
|
Posted by Neil on 10/03/07 20:02
Right, forgot to mention the size of the DB (but did mention the general
number of records in another post here). The db is about half a gig in size.
So not very big at all.
Re. upgrade OS/SQL, my original post stated: "We are migrating to a new
server, running Server 2003 SP2, and SQL Server
2005." That is what we are upgrading to. You're saying that's not
sufficient?
Thanks!
Neil
"Greg D. Moore (Strider)" <mooregr_deleteth1s@greenms.com> wrote in message
news:13g6uqbd3mtkefe@corp.supernews.com...
> "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
>
>
Navigation:
[Reply to this message]
|