sql server connect: Urgent: Connection between SQL 2005 SP1 - IIS on AMD 64bit -- sql server connect

Urgent: Connection between SQL 2005 SP1 - IIS on AMD 64bit

Mert Sakarya
8/19/2006 12:12:31 AM

sql server connect: Hi,

We have a 33GB database on Windows 2003 RC2, SQL Server 2005 SP1 on HP585
AMD64 bit with 4 CPUs, 16GB RAM and 3 disks on storage array.
Our five web server connects to database and queries database.

The problem is when we make a request on a web server, it generates a query
and executes it on SQL Server, it takes 30 seconds for a web reply, but when
we execute the same generated query on Management studio it takes 3 seconds.
We do not think we have a problem on network cables, on network cards
(pinging just works perfect).

The data, somehow cannot be transferred under heavyload scenarios (many
requests on live database), where should we look? Any pointers?

I need urgent help... My live web system is not working properly.

Regards,
Mert

RE: Urgent: Connection between SQL 2005 SP1 - IIS on AMD 64bit

Raymond Yuen
8/21/2006 3:54:01 AM

Hi Mert Sakarya,

There are some differences between you execute query through Web
Applications and using the Management Studio:

By using the Web Applications, all the data will receive from the database
and store in the Web server memory. Then your ASP.NET (I assume) application
will render the HTML response to the client. As a result, the response time
will be longer (in terms of the client browser's point of view).
However, by using the Management Studio, the record set will be stream to
the Management Studio's result pane without further markup rendering. Hence
the response time will be shorter than in the Web application's scenario.

Hope this help to identify the problem.

Raymond

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.