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

ms sql server 2000 personal edition

Error is occured such as "c:\Program Files\Microsoft SQL Server\80\
tools\BINN\Resources\1033\SEMCROS.RLL could not be loaded" while installing in windows xp sp2Question moved to SQL Server Forum.

MS SQL Server - LOCK Info

Hi

The system tables syslocks,syslockinfo give information on locked resources, spid, object_id,lock mode, lock status etc.

How will i get object_name

for example if a table is being locked above sys tables give object id, how can i get the actual table name ( object_name)

Please let me know
Best Regards
THNQdigitaljoin with sysobjects table|||You can get it using object_name(object_id) in your select query.

Thanks.
Pat

--------
Originally posted by fridays
join with sysobjects table|||Originally posted by fridays
join with sysobjects table

Hi ,

i found lock info for spid 12 using sp_lock 12

got objid = 'numxxxxxx'
type =TAB
mode=Sch-M and Status = WAIT

i tried joining syslockinfo with sysobjects like below

select si.rsc_objid, si.req_spid , so.name from
SYSLOCKINFO si ,SYSOBJECTS so where
si.req_spid =12 and --si.rsc_type =5 and
si.rsc_objid= 736846995 and so.xtype='U'

This doesnot seem to gimme what i am looking for..

My reqirement is what is Object_Name(objid given by splock spid)

Please advise what am i doign wrong.
Thanks
THNQdigital|||use master
select a.name , b.rsc_objid , c.spid
from sysdatabases a , syslockinfo b , syslocks c
where c.spid = b.req_spid and a.dbid = c.dbid
and c.spid = 'xxxx' and ....

u will know database name 'yyyy' and objid 'zzzzz'
then
select name from yyyy.dbo.sysobjects where id = 'zzzzzz'

Originally posted by THNQdigital
Hi ,

i found lock info for spid 12 using sp_lock 12

got objid = 'numxxxxxx'
type =TAB
mode=Sch-M and Status = WAIT

i tried joining syslockinfo with sysobjects like below

select si.rsc_objid, si.req_spid , so.name from
SYSLOCKINFO si ,SYSOBJECTS so where
si.req_spid =12 and --si.rsc_type =5 and
si.rsc_objid= 736846995 and so.xtype='U'

This doesnot seem to gimme what i am looking for..

My reqirement is what is Object_Name(objid given by splock spid)

Please advise what am i doign wrong.
Thanks
THNQdigital