|
-
Insufficient Memory
About once a week I'm receiving this message in the Sqlserver Log from ODS
Error 17803,Severity: 17, State: 14
Insufficient Memory Available
The machine has 1 gig of RAM and is dedicated to sqlserver7 with sp1. Any ideas of what might be causing this problem? Any help is greatly appreciated.
Chris
-
Insufficient Memory (reply)
I hope you are not giving all to SQL Server.
Make sure that you do not have large tables pinned in cache.
Krom
------------
Chris Hill at 4/14/00 11:03:38 AM
About once a week I'm receiving this message in the Sqlserver Log from ODS
Error 17803,Severity: 17, State: 14
Insufficient Memory Available
The machine has 1 gig of RAM and is dedicated to sqlserver7 with sp1. Any ideas of what might be causing this problem? Any help is greatly appreciated.
Chris
-
Insufficient Memory (reply)
Currently we are using the dynamic memory configuration option. Should we not be? Most of the published documentation says to let sqlserver manage itself.
------------
KROM at 4/14/00 11:10:04 AM
I hope you are not giving all to SQL Server.
Make sure that you do not have large tables pinned in cache.
Krom
------------
Chris Hill at 4/14/00 11:03:38 AM
About once a week I'm receiving this message in the Sqlserver Log from ODS
Error 17803,Severity: 17, State: 14
Insufficient Memory Available
The machine has 1 gig of RAM and is dedicated to sqlserver7 with sp1. Any ideas of what might be causing this problem? Any help is greatly appreciated.
Chris
-
Insufficient Memory (reply)
Yes, but you can set the boundaries.
leave at the least, 125mgs for NT
------------
at 4/14/00 11:14:02 AM
Currently we are using the dynamic memory configuration option. Should we not be? Most of the published documentation says to let sqlserver manage itself.
------------
KROM at 4/14/00 11:10:04 AM
I hope you are not giving all to SQL Server.
Make sure that you do not have large tables pinned in cache.
Krom
------------
Chris Hill at 4/14/00 11:03:38 AM
About once a week I'm receiving this message in the Sqlserver Log from ODS
Error 17803,Severity: 17, State: 14
Insufficient Memory Available
The machine has 1 gig of RAM and is dedicated to sqlserver7 with sp1. Any ideas of what might be causing this problem? Any help is greatly appreciated.
Chris
-
Insufficient Memory (reply)
U can take off dynamic memory allocation, and choose fixed memory allocation in server properties..I think it works..If not i am sorry.
------------
KROM at 4/14/00 11:19:08 AM
Yes, but you can set the boundaries.
leave at the least, 125mgs for NT
------------
at 4/14/00 11:14:02 AM
Currently we are using the dynamic memory configuration option. Should we not be? Most of the published documentation says to let sqlserver manage itself.
------------
KROM at 4/14/00 11:10:04 AM
I hope you are not giving all to SQL Server.
Make sure that you do not have large tables pinned in cache.
Krom
------------
Chris Hill at 4/14/00 11:03:38 AM
About once a week I'm receiving this message in the Sqlserver Log from ODS
Error 17803,Severity: 17, State: 14
Insufficient Memory Available
The machine has 1 gig of RAM and is dedicated to sqlserver7 with sp1. Any ideas of what might be causing this problem? Any help is greatly appreciated.
Chris
-
Insufficient Memory (reply)
I've restricted sqlserver to 836 meg. I'm still having the same problem. Any other ideas?
------------
KROM at 4/14/00 11:19:08 AM
Yes, but you can set the boundaries.
leave at the least, 125mgs for NT
------------
at 4/14/00 11:14:02 AM
Currently we are using the dynamic memory configuration option. Should we not be? Most of the published documentation says to let sqlserver manage itself.
------------
KROM at 4/14/00 11:10:04 AM
I hope you are not giving all to SQL Server.
Make sure that you do not have large tables pinned in cache.
Krom
------------
Chris Hill at 4/14/00 11:03:38 AM
About once a week I'm receiving this message in the Sqlserver Log from ODS
Error 17803,Severity: 17, State: 14
Insufficient Memory Available
The machine has 1 gig of RAM and is dedicated to sqlserver7 with sp1. Any ideas of what might be causing this problem? Any help is greatly appreciated.
Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote