|
| You might want to seriously look at putting IIS on its own server - trying to
run both IIS and SQL Server on the same machine can cause phantom issues to
arise - are you running ASP or ASP.NET applications on the server?
"tolgay" wrote:
> 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.
>
>
>
>
|
|