EXTREMELY SLOW WEB - SQL
Posted on 2006-11-18
Hi there, I am having the following problem:
My web page, built in ASP.NET with VB.NET running against a SQLServer 2000 is running extrmely slow.
The app is hosted in 2 servers. Both of them are experiencing the same problem. The internet connection is aldso shared with other servers, which are running OK. Therefore I discarded a saturation of the connectio.
I imagined it was the database, but when running queries outside of the app, the server responds reasonably well. It might be a little slower than what it was when running OK but seems not big deal. I once had problems with the DB and the result was getting "Time Out" messages, which isnt happening now. So i am not sure if it is the database.
Anyway, whenever I run any page, it takes more than 45sec-1min to get results (it used to be 5 secs max)
Anyone have any clue what it may be?