SQL Server 2000 Lock Up Problem

[StateofTX]

I have a web site with ASP pages that use stored procedures to query on SQL 2000 databases (Windows 2000 Server). Sometimes, after the request is submitted to the server, the server is locked. I had to restart the server. Any suggestion is appreciated! Thanks.

 

[aalmeida]

Tha seems to me very odd, I would say that more likely the problem is your ASP or your SP code not the SQL server, is there anything on Event Viwer? another thing I would think is: next time monitor the NT server for memory and CPU usage as wel as processes running? on SQL Server two things I know could cause that behavier one is locks waiting for unclosed transaction and large number of locks on temp db AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[StateofTX]

Thanks. I viewed the event log, and found the following error:

SQL Server message 1101, state 1, severity 17: unable to allocate new page for database 'tempdb'. There are no more pages available on valid allocation pages.

What can I do to prevent this from happening?

 

[aalmeida]

It seems to me that you ran out of space on TempDb,
you need a larger TempDb, it also may be that the increment on autogrouth is not big enogh, let's say that you have 5% try changing to 10%. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[AshleyRickards]

You could also create secondary data and log files on another drive. Ashley L Rickards
SQL DBA

 

[StateofTX]

Thanks to Al and Ashley. Great ideas!