Hi Kevin,
Could the following from TechNet have any bearing (not that it's very strong
on remedies)?
PSS ID Number: Q142719
Article last modified on 08-08-2001
WINDOWS:2000; winnt:3.5,3.51,4.0
======================================================================
----------------------------------------------------------------------------
---
The information in this article applies to:
- Microsoft Windows NT Workstation versions 3.5, 3.51, 4.0
- Microsoft Windows NT Server versions 3.5, 3.51, 4.0
- Microsoft Windows 2000 Professional
- Microsoft Windows 2000 Server
- Microsoft Windows 2000 Advanced Server
----------------------------------------------------------------------------
---
SYMPTOMS
========
Windows NT or a Windows NT service reports an error in the event log,
stating
that the system is out of resources. According to Performance Monitor and
Windows NT Diagnostics, however, there is plenty of RAM available. For
example,
if a large number of connections are made to SQL Server, SQL Server will
report
an error 1450 - Insufficient System Resources, even though this system has
plenty of RAM available.
CAUSE
=====
The Windows NT kernel is running out of paged-pool memory. When Windows NT
boots
up, it calculates the amount of paged-pool memory available to the kernel
based
on the amount of physical RAM in the system. The maximum this value can be
is
192 MB. If the kernel allocates all of its allotted paged- pool memory, it
will
not be able to perform many tasks and will instead return a
STATUS_INSUFFICIENT_RESOURCES (0xC000009A).
MORE INFORMATION
================
This is by design. Windows NT currently uses 32-bit addressing for memory.
This
only allows for 4 GB of addressable RAM, which must be divided into various
sections of virtual memory. The kernel only has 2GB to divide up and, in
this
distribution of addresses, paged-pool memory is allocated a maximum of 192
MB.
This is a restriction of the 32-bit addressing.
REFERENCES
==========
For additional information on paged-pool memory, please see the following
article in the Microsoft Knowledge Base:
ARTICLE-ID: Q126402
TITLE : PagedPoolSize and NonPagedPoolSize Values in Windows NT
Additional query words: prodnt
======================================================================
Keywords : kbnetwork
Technology : kbWinNTsearch kbWinNTWsearch kbWinNTW400
kbWinNTW400search kbWinNT351search kbWinNT350search kbWinNT400search
kbWinNTW350 kbWinNTW350search kbWinNTW351search kbWinNTW351 kbwin2000AdvServ
kbwin2000AdvServSearch kbwin2000Serv kbWinNTSsearch kbWinNTS400search
kbWinNTS400 kbWinNTS351 kbWinNTS350 kbwin2000ServSearch kbwin2000Search
kbwin2000ProSearch kbwin2000Pro kbWinNTS351search kbWinNTS350search
kbWinAdvServSearch
Version : WINDOWS:2000; winnt:3.5,3.51,4.0
============================================================================
=
Copyright Microsoft Corporation 2001.
> -----Original Message-----
> From: Sexton, Kevin [SMTP:kevin.[Email Address Removed] Sent: Thursday, February 28, 2002 12:13 PM
> To: Long, Charles (euler:eti)
> Cc: [Email Address Removed] Subject: RE: backup error
>
> We have 8 GB of memory on that machine. We have not been able to get it
> to use any more than the default 1.7 GB though (that's a separate
> issue...let me know if you know the answer to that one as well)
>
> -Kevin
>
> -----Original Message-----
> From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed] Sent: Thursday, February 28, 2002 3:33 AM
> To: Sexton, Kevin
> Subject: RE: backup error
>
>
> I see Mark suggested 'out of memory ' could generate that error?
>
> > -----Original Message-----
> > From: Sexton, Kevin [SMTP:kevin.[Email Address Removed] > Sent: Wednesday, February 27, 2002 6:25 PM
> > To: Long, Charles (euler:eti)
> > Subject: RE: backup error
> >
> > I have 500 GB of disk space. that is not the problem.
> >
> > -K
> >
> > -----Original Message-----
> > From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed] > Sent: Wednesday, February 27, 2002 11:57 AM
> > To: Sexton, Kevin
> > Subject: RE: backup error
> >
> >
> > You'll get this with Oracle as well - probably with slightly differing
> > presentation; it's the antique there needs to be more disk than file
> > problem.
> >
> > > -----Original Message-----
> > > From: Sexton, Kevin [SMTP:kevin.[Email Address Removed] > > Sent: Wednesday, February 27, 2002 4:43 PM
> > > To: [Email Address Removed] > > Subject: backup error
> > >
> > > I received this error when trying to run a scheduled backup from one
> > > server to another. It did create a large . BAK file but not
> complete.
> > >
> > > BackupMedium::ReportIoError: write failure on backup device
> > > '\\testbed2\f$\REGEN_REPORT_IVbkup'. Operating system error
> > > 1450(Insufficient system resources exist to complete the requested
> > > service.).
> > >
> > > -Kevin
> > >
> > >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: mssqldba-[Email Address Removed] > > For additional commands, e-mail: mssqldba-[Email Address Removed]
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page