Hi, Ekrem! Thanks for your input. I think, though, that you may have
misunderstood my last post. The person I was replying to had written, "you
probably need to upgrade your OS/SQL." I replied with our new configuration,
and asked, "You're saying that's not sufficient?" I was referring to the
versions of OS and SQL Server, since he had said that we should upgrade.
Regarding the memory issue, I do appreciate and understand your input. And
what you say is true. However, what I was wondering is if people here would
say, "2 GB running SQL with Server 2003?? No friggin' way that will work!!"
But they didn't. Most have said it's probably OK, but more memory couldn't
hurt. So that's the input I was looking for.
Anyway, thanks again for your input. It's been very ful!
Neil
"Ekrem Önsoy" <ekrem@btegiim.com> wrote in message
news:5C697D0D-5434-4154-8197-E4B3B0985FB2@microsoft.om...
> Hi Neil,
>
>
> I think you are over-excited about this migration. I know, you are trying
> to learn more about things and make yourself confident about this stuff.
> But the info we can share here with you is very general. SQL Server does
> not have a general configuration. It always depends.
>
> I and most of my friends here maybe can say that 500MB DB is a small
> database. But nobody knows what's going on in your environment. Your
> queries may have been written very badly and consume too much memory or
> processor resources. Then it would be lie to say "2GB of RAM is enough for
> a 500MB DB". Or your queries may be written very well, but there could be
> too many complex transactions which consume too much resources.
>
> So, you need to analyse your system yourself. Determine your needs and
> configure your new environment according to your needs. I don't believe
> that there is someone here who can definitely say "Window Server 2003 and
> SQL Server 2005 and 2GB of RAM is going to be OK and you will not have any
> problem with your new environment".
>
> It's you who is going to find your questions' answers.
>
> If you have anything that lingers in your mind, do not hasitate asking.
> However, it's not possible to analyse your system by this way.
>
>
> --
> Ekrem Önsoy
>
>
>
>
> "Neil" <nospam@nospam.net> wrote in message
> news:0zSMi.54850$Um6.35492@newssvr12.news.prodigy. net...
>> 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
>>>
>>>
>>
>>
>