SQL Server Timeout

[rsshetty]

I am currently managing a website that uses ASP/COM and SQL Server 2000 Active/Passive cluster as the backend database.
Over the last 2 weeks, I've been getting a tremdous amount of SQL Timeout errors and ASP script timeout errors.
Does anyone know of any SQL Server performance analysis tools available with SQL Server or any commands that should give me an insight into what could be causing this problem?

rsshetty.
It's always in the details.

 

[checkai]

you can use SQL Profiler to tell you which calls are timing out and taking the longest amount of time...

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[Wholsea]

Check the size of your log files. I've seen this when the system log files get HUGE.

I truncate the log storage and everything works fine after that...

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[Wholsea]

I mean the SQL Server log files...

ASP, VB, VBS, Cold Fusion, SQL, DTS, T-SQL, PL-SQL, IBM-MQ, Crystal Reports, Crystal Enterprise

 

[rsshetty]

Wholsea,

I will try that. Thanks.


rsshetty.
It's always in the details.