1 ASP page multiple connection to SQL server

I have an ASP page that have 5 different connection to SQL server in the
same time,

all connection for select, most of the code in SQL stored procedure.



Hardware: Dual Xeon 3.0 and 3GB Ram with 73x5 Raid 5

Software: Windows 2000 server with II5 (I hate II6) with SQL server 2000
Standard.



My Question is:



If I have 2.500.000 Hits per day and increasing . does the web site will be
slow?



If so, What can I do for speeding it UP.

Re: 1 ASP page multiple connection to SQL server

Hossam Salah wrote:
> I have an ASP page that have 5 different connection to SQL server in
> the same time,

Why?
Are you connecting to 5 sql servers?

>
> all connection for select, most of the code in SQL stored procedure.
>
>
>
> Hardware: Dual Xeon 3.0 and 3GB Ram with 73x5 Raid 5
>
> Software: Windows 2000 server with II5 (I hate II6) with SQL server
> 2000 Standard.
>
>
>
> My Question is:
>
>
>
> If I have 2.500.000 Hits per day and increasing . does the web site
> will be slow?
>

How can WE answer that? You need to stress-test your site to address
that question.



--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: 1 ASP page multiple connection to SQL server

It's one SQL Server with 5 diferent Query.
but I do like this

Conn1
SQL1
RS1
call the date
close every thing
..
..
..
Conn5
SQL5
RS5
call the data
Close every thing

where conn1 to 5 is the same
SQl1 to 5 different from many tables

"Bob Barrows [MVP]" wrote in message
news:%23UlXmwk5GHA.2208@TK2MSFTNGP04.phx.gbl...
> Hossam Salah wrote:
>> I have an ASP page that have 5 different connection to SQL server in
>> the same time,
>
> Why?
> Are you connecting to 5 sql servers?
>
>>
>> all connection for select, most of the code in SQL stored procedure.
>>
>>
>>
>> Hardware: Dual Xeon 3.0 and 3GB Ram with 73x5 Raid 5
>>
>> Software: Windows 2000 server with II5 (I hate II6) with SQL server
>> 2000 Standard.
>>
>>
>>
>> My Question is:
>>
>>
>>
>> If I have 2.500.000 Hits per day and increasing . does the web site
>> will be slow?
>>
>
> How can WE answer that? You need to stress-test your site to address
> that question.
>
>
>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Re: 1 ASP page multiple connection to SQL server

Hossam Salah wrote:
> It's one SQL Server with 5 diferent Query.
> but I do like this
>
> Conn1
> SQL1
> RS1
> call the date
> close every thing
> .
> .
> .
> Conn5
> SQL5
> RS5
> call the data
> Close every thing
>
> where conn1 to 5 is the same
> SQl1 to 5 different from many tables

If, by "Close every thing", you mean you close the connection as well,
then you are likely dealing with a single actual shared connection. But
I still fail to see why you are using 5 different objects. Why not use a
single object and keep it open for the duration of the page? It's likely
to make an improvement since there is some overhead involved with
grabbing a connection from the session pool.

Better yet, why not call a single procedure that calls all 5 procedures,
returning multiple resultsets which you can access by using the
NextRecordset method?


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: 1 ASP page multiple connection to SQL server

Better yet, why not call a single procedure that calls all 5 procedures,
returning multiple resultsets which you can access by using the
NextRecordset method?

I will try this
Thank you