web server performance issues

External Since: Jul 07, 2004 Posts: 1

1. what is the best server configugation of the server
for both SQL and IIS mounted on the same server which
has 50 cuncurrent users.

2. IF the SQL server has 5 users lisence how does it
behave for active(opening the enterprise manager or
quesry anlyser) an inactive connection (connecting from
the ASP pages) we have observed the inactive connection
goes to sleeping mode till the active connection is
released. what is the best way of pooling the connection.

3. NO lock has to be given to the SQLs within the
Transaction or other SQLs outside the connection. is
there any option to set the NO lock option for the
connection object. we have observed that passing a
connection string instead of connection object works
faster any comments on this

4. how do we check the SQL server how many license user
version is the current server version.

5. Best ways of how we can monitor the server like the
failure of quick response time in a web application is
due to the

a. Network Traffic
b. Server Memory (RAM)
c. SQL Server database
d. IIS Configuration
e. ASP Application Code

I know every thing matters but how do we trace where
exactly the problem is with. please send me some best
parctices and the corresponding scenario if some one has
faced and overcome on this.

6. What is the best way of Transaction handling of the
database (component level transaction, ADOconnection
transaction, transaction in backend database inside SPs)

7. how do we check the number of hit on the current
virtual directly or an asp file do we have any log for
that.

External Since: Jun 10, 2004 Posts: 1807

On Wed, 7 Jul 2004 11:19:29 -0700, "Deepak" <balaraj.deepak.DeleteThis@comat.com>
wrote:

>1. what is the best server configugation of the server
>for both SQL and IIS mounted on the same server which
>has 50 cuncurrent users.

Best as in what? Hardware specs? Drive configuration? Networking
connectivity?

>2. IF the SQL server has 5 users lisence how does it
>behave for active(opening the enterprise manager or
>quesry anlyser) an inactive connection (connecting from
>the ASP pages) we have observed the inactive connection
>goes to sleeping mode till the active connection is
>released. what is the best way of pooling the connection.

Good question, for a SQL group. It's not related to IIS.

>3. NO lock has to be given to the SQLs within the
>Transaction or other SQLs outside the connection. is
>there any option to set the NO lock option for the
>connection object. we have observed that passing a
>connection string instead of connection object works
>faster any comments on this

Not related to IIS.

>4. how do we check the SQL server how many license user
>version is the current server version.

Still not related to IIS.

>5. Best ways of how we can monitor the server like the
>failure of quick response time in a web application is
>due to the
>
> a. Network Traffic
> b. Server Memory (RAM)
> c. SQL Server database
> d. IIS Configuration
> e. ASP Application Code
>
> I know every thing matters but how do we trace where
>exactly the problem is with. please send me some best
>parctices and the corresponding scenario if some one has
>faced and overcome on this.

IISState may help, obvioulsy your application logging, plus event
logs, IIS logs and so on.

>6. What is the best way of Transaction handling of the
>database (component level transaction, ADOconnection
>transaction, transaction in backend database inside SPs)

Well, still not IIS related.

>7. how do we check the number of hit on the current
>virtual directly or an asp file do we have any log for
>that.

Your web site logs show this. Outside of IIS there are other methods,
but you know, that's not IIS either.

You have SQL questions, ASP questions, programming questions, etc. but
no real IIS questions. Why did you choose to post in an IIS group?

Jeff

Jeff