IIS + SQL (Not enough storage is available to complete this operation)

19 Jul 2006 3:26 PM

tolgay

Sometimes we got an error (Not enough storage is available to complete this
operation) from one of our servers which on win2000 sp 4 iis5.0 (all hotfix
installed) sql server sp4. mdac 2.81. It occures random and we could not
find the error reason. When the error occured the server cpu or mem or I/O
usage is normal and I try to find out from internet and some says check the
mdac verision registery size or oracle etc. they do not indicate our
problem. we use adodb connection to connect sql server and all of them
close after the proccess also all recordset are close and set nothing. The
server transaction is kind of high but there are several indexes so it not
seems a problem there. When IIS restarts the problem solves but all users
sesions are closed. Have you ever met the error before or what can be
problem. Any advice would be helpful

Thanks

19 Jul 2006 11:00 PM

Larry Hyman

Show quote Hide quote

"tolgay" <t***@tgul.com> wrote in message
news:uibNfg0qGHA.4676@TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
>
> Thanks
>
>

and the event error log says what?

20 Jul 2006 2:18 AM

Ken Schaefer

Do you see any errors in the Event Log (particularly about non-paged or
paged pool depletion)?

Cheers
Ken

Show quoteHide quote

"tolgay" <t***@tgul.com> wrote in message
news:uibNfg0qGHA.4676@TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
> this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
> the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
>
> Thanks
>
>

20 Jul 2006 1:16 PM

karl levinson, mvp

Show quote Hide quote

"tolgay" <t***@tgul.com> wrote in message
news:uibNfg0qGHA.4676@TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
> this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
> the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful

How much space is free in your database and the tempdb database? Are the
transaction logs full or not large enough? Are there any errors in the SQL
logs?

--
kind regards,
Karl Levinson, CISSP, CCSA, MCSE [MS MVP]
--------------------------------
Microsoft Security FAQ:
http://securityadmin.info

21 Jul 2006 6:20 AM

tolgay

There is nothing in to event log even a warning also temp db size quite
large and the db transaction log is about 2 gbyte and %75 is free and there
is nothing also in sql server logs.

Thanks

Show quoteHide quote

"tolgay" <t***@tgul.com> wrote in message
news:uibNfg0qGHA.4676@TK2MSFTNGP03.phx.gbl...
> Sometimes we got an error (Not enough storage is available to complete
this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could not
> find the error reason. When the error occured the server cpu or mem or I/O
> usage is normal and I try to find out from internet and some says check
the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of them
> close after the proccess also all recordset are close and set nothing. The
> server transaction is kind of high but there are several indexes so it not
> seems a problem there. When IIS restarts the problem solves but all users
> sesions are closed. Have you ever met the error before or what can be
> problem. Any advice would be helpful
>
> Thanks
>
>

21 Jul 2006 9:21 AM

tolgay

Sometimes we got an error (Not enough storage is available to complete
this
operation) from one of our servers which on win2000 sp 4 iis5.0 (all
hotfix
installed) sql server sp4. mdac 2.81. It occures random and we could not
find the error reason. When the error occured the server cpu or mem or I/O
usage is normal and I try to find out from internet and some says check
the
mdac verision registery size or oracle etc. they do not indicate our
problem. we use adodb connection to connect sql server and all of them
close after the proccess also all recordset are close and set nothing. The
server transaction is kind of high but there are several indexes so it not
seems a problem there. When IIS restarts the problem solves but all users
sesions are closed. Have you ever met the error before or what can be
problem. Any advice would be helpful

There is nothing in to event log even a warning also temp db size quite
large and the db transaction log is about 2 gbyte and %75 is free and there
is nothing also in sql server logs.

26 Jul 2006 9:32 PM

jas0n

tolgay wrote:

Show quoteHide quote

> Sometimes we got an error (Not enough storage is available to
> complete this
> operation) from one of our servers which on win2000 sp 4 iis5.0 (all
> hotfix
> installed) sql server sp4. mdac 2.81. It occures random and we could
> not find the error reason. When the error occured the server cpu or
> mem or I/O usage is normal and I try to find out from internet and
> some says check the
> mdac verision registery size or oracle etc. they do not indicate our
> problem. we use adodb connection to connect sql server and all of
> them close after the proccess also all recordset are close and set
> nothing. The server transaction is kind of high but there are
> several indexes so it not seems a problem there. When IIS restarts
> the problem solves but all users sesions are closed. Have you ever
> met the error before or what can be problem. Any advice would be
> helpful
>
> There is nothing in to event log even a warning also temp db size
> quite large and the db transaction log is about 2 gbyte and %75 is
> free and there is nothing also in sql server logs.

We were seeing this problem and tracked ours back to a huge number of
active directory groups - we use the following in a .reg file to
increase the size - works ok after reboot then - it affected all sorts
of things - we couldnt add a pc to the domain without seeing this error.

Copy the following into notepad and save with name of your choosing,
ours in mtsize.reg then run it to make the change in the registry.

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parame
ters]
"MaxTokenSize"=dword:00010000