MS SQL Server 2k standard - insuffient system resources or memory

Hi,
I have sql 2000 with sp3, on w2k with sp4. It has 3 GB RAM. I haven't set u
p the maximum memory for instance, so they are defaults from 0 to 3072 mb.
My former server worked fine.: It was sql 2000 no sp, on w2k with sp2. It ha
d 1 GB RAM.
I had't set up the maximum memory for instance, so they are defaults from 0
to 1024 mb.
and that worked fine.
My 3rd party programs are finnish accounting programs and they give me very
much error and other conflict messages. I have already checked out everythin
g from setttings and I don't believe it could be any collation problem or so
mething.
I am now wondering what happens when there's no limits of the memory usage.
Will sql use over 2 gb though it can't and give problems after or does it re
alize limits?
Does anyone know?Standard Edition of SQL Server 2000 will not use more than 2G.
It's easy to confirm this with Performance Monitor. What errros are you
getting?
Brian
"Mikko Oksanen" <anonymous@.discussions.microsoft.com> wrote in message
news:70923497-8A0B-43A1-B9FE-608215BC91CA@.microsoft.com...
> Hi,
> I have sql 2000 with sp3, on w2k with sp4. It has 3 GB RAM. I haven't set
up the maximum memory for instance, so they are defaults from 0 to 3072 mb.
> My former server worked fine.: It was sql 2000 no sp, on w2k with sp2. It
had 1 GB RAM.
> I had't set up the maximum memory for instance, so they are defaults from
0 to 1024 mb.
> and that worked fine.
> My 3rd party programs are finnish accounting programs and they give me
very much error and other conflict messages. I have already checked out
everything from setttings and I don't believe it could be any collation
problem or something.
> I am now wondering what happens when there's no limits of the memory
usage. Will sql use over 2 gb though it can't and give problems after or
does it realize limits?
> Does anyone know?
>
>|||Hello,
I looked from the performance monitor. I Noticed it also. Thank you
I get this kind of errors:
Insufficient resources to create UMS scheduler
Run-time error'-2147217900 (80040e14)':
The CREATE DATABASE process is allocating 0,75 MB on disk 'pl3135kk'.
(here the pl3135 is some temp database)
Insufficient system memory to run this query
This kind of problem. Anykind of help could do if you know or have heard thi
s kind of problems
-Mikko-
Standard Edition of SQL Server 2000 will not use more than 2G.
It's easy to confirm this with Performance Monitor. What errros are you
getting?
Brian
"Mikko Oksanen" <anonymous@.discussions.microsoft.com> wrote in message
news:70923497-8A0B-43A1-B9FE-608215BC91CA@.microsoft.com...
> Hi,
up the maximum memory for instance, so they are defaults from 0 to 3072 mb.
had 1 GB RAM.
> I had't set up the maximum memory for instance, so they are defaults from
0 to 1024 mb.
> and that worked fine.
very much error and other conflict messages. I have already checked out
everything from setttings and I don't believe it could be any collation
problem or something.
usage. Will sql use over 2 gb though it can't and give problems after or
does it realize limits?sql