Debugging SQL Server 2000

I'm using SQL Server 2000 for about six months and never has a problems, but
since three day ago sqlserver is freezing the server ( Win 2000 advanced se
rver ) with no apparent reason. We're sure that is SQLServer who's causing t
he problem because the serv
er freezes when we are inserting records to a table.
It throws no errors... just a timeout and we have to restart the computer.
Table log is not full.
Sql Server Logs says nothing...
Is there any form to log all activities of the sql server? How can I found t
he cause of this problem?
Any ideas?
Thanks.Tools you can use when this happens:
sp_who2 to check blocking and runnable processes
profiler to see what's going on
sp_lock to see what tables are being locked
perfmon to monitor resource: cpu, memory, disk I/O, etc.
"MiCiudadDevs" <MiCiudadDevs@.discussions.microsoft.com> wrote in message
news:198F91B3-E85F-456A-855D-DAE5E4D088DA@.microsoft.com...
> I'm using SQL Server 2000 for about six months and never has a problems,
but since three day ago sqlserver is freezing the server ( Win 2000 advanced
server ) with no apparent reason. We're sure that is SQLServer who's causing
the problem because the server freezes when we are inserting records to a
table.
> It throws no errors... just a timeout and we have to restart the computer.
> Table log is not full.
> Sql Server Logs says nothing...
> Is there any form to log all activities of the sql server? How can I found
the cause of this problem?
> Any ideas?
> Thanks.|||Try using the SQL Server Profiler to monitor all the SQL statements and
writing the output to a table.
"MiCiudadDevs" <MiCiudadDevs@.discussions.microsoft.com> wrote in message
news:198F91B3-E85F-456A-855D-DAE5E4D088DA@.microsoft.com...
> I'm using SQL Server 2000 for about six months and never has a problems,
but since three day ago sqlserver is freezing the server ( Win 2000 advanced
server ) with no apparent reason. We're sure that is SQLServer who's causing
the problem because the server freezes when we are inserting records to a
table.
> It throws no errors... just a timeout and we have to restart the computer.
> Table log is not full.
> Sql Server Logs says nothing...
> Is there any form to log all activities of the sql server? How can I found
the cause of this problem?
> Any ideas?
> Thanks.