Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Slow response between SQL server and WWW

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-01-17 : 10:05:38
Komkrit writes "I set up the web application (ASP.NET) used SQL for DB, this connected directly with cross-link cable(not through switching HUB). However, it seem slowly when client user log into the server on web application, some transactions not responsible faster and waiting longer for 2-3 Minutes. I realize this problem would be caused by a bottleneck. So on, How do i fix this problem, or else give me the step for srew this up?"

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-01-17 : 10:07:58
Is the application fairly high traffic ?

Make sure you are closing off all your database connections, if you don't it can slow EVERYTHING down.


Damian
Go to Top of Page
   

- Advertisement -