Very Computer

by **Anan** » Wed, 19 Sep 2001 16:36:20

hi
I am using SQL server 7.0, Winnt 4 service pack 6.0 . when i update the
database continuously for a long time ( 12 hours) SQL server stops.
when i try to connect to the SQL server thru ISQL i get "Too many open file
handles".
The windows NT system log shows the following error
"The server could not expand a table because the table reached the maximum
size"

Can anyone help me ?

Thanks
Anand

by **Tom Morea** » Wed, 19 Sep 2001 20:55:58

Not sure but it sounds like it is some sort of application problem not
related directly to SQL Server. Does your app write files on the server and
not close them?

--
Tom

-------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com

Quote:> hi
> I am using SQL server 7.0, Winnt 4 service pack 6.0 . when i update the
> database continuously for a long time ( 12 hours) SQL server stops.
> when i try to connect to the SQL server thru ISQL i get "Too many open
file
> handles".
> The windows NT system log shows the following error
> "The server could not expand a table because the table reached the maximum
> size"

> Can anyone help me ?

> Thanks
> Anand

by **Anan** » Wed, 19 Sep 2001 22:04:55

I am running an ISAPI DLL which updates the database tables. It writes only
to the SQL tables.

> Not sure but it sounds like it is some sort of application problem not
> related directly to SQL Server. Does your app write files on the server
and
> not close them?

> --
> Tom

> -------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> www.apress.com

> > hi
> > I am using SQL server 7.0, Winnt 4 service pack 6.0 . when i update the
> > database continuously for a long time ( 12 hours) SQL server stops.
> > when i try to connect to the SQL server thru ISQL i get "Too many open
> file
> > handles".
> > The windows NT system log shows the following error
> > "The server could not expand a table because the table reached the
maximum
> > size"

> > Can anyone help me ?

> > Thanks
> > Anand

by **Tom Morea** » Thu, 20 Sep 2001 05:21:24

You may want to use the Enterprise Mgr to check on the connections or the
Profiler to see what is coming across the wire.

--
Tom

-------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com

> I am running an ISAPI DLL which updates the database tables. It writes
only
> to the SQL tables.

> > Not sure but it sounds like it is some sort of application problem not
> > related directly to SQL Server. Does your app write files on the server
> and
> > not close them?

> > --
> > Tom

> > -------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> > www.apress.com

> > > hi
> > > I am using SQL server 7.0, Winnt 4 service pack 6.0 . when i update
the
> > > database continuously for a long time ( 12 hours) SQL server stops.
> > > when i try to connect to the SQL server thru ISQL i get "Too many open
> > file
> > > handles".
> > > The windows NT system log shows the following error
> > > "The server could not expand a table because the table reached the
> maximum
> > > size"

> > > Can anyone help me ?

> > > Thanks
> > > Anand

Very Computer

SQL server problems

SQL server problems

SQL server problems

SQL server problems

SQL server problems