Showing posts with label performance. Show all posts
Showing posts with label performance. Show all posts

Saturday, March 31, 2012

Web Server Performance

We have a Win 2003 Server that runs around 15 instances of an ASP.NET 1.1
Web Application ( in the same application Pool).
Each instance connects to a SQL 2K database on a separate database server.
The database size is around 100 MB (min ) to 3 GB Max.
The web server is a 2.6 GHZ Xeon with 2 GB of RAM.
The database server is a dual proc Xeon with 4 GB of Ram.
Each instance of the Web Application has an average of 15 users.
We reboot the servers every wend.
I have set the Worker Process to recycle at 4 AM everyday.
The problem is that our clients often receive Out Of Memory exceptions.
Task
Manager doesn't show any abnormal activity.
The Memory Utilization on the web server seems to be around 500 MB .. which
should be fine for a 2 GB RAM system that is used solely as a web server.
My questions:
1 Are we overloading the server. ?
2 What tweaks or configuration changes can we do to improve performance.
Thanks,
Sachin SalgarkarSachin,
Sometimes it can be something as simple as changing the
connectionstring to the database slightly to improve pooling, or ensuring
that the garbage collection is happening correctly. Even though .Net is
managed, garbage collection should still be written to handle the closing of
datareaders/connections and disposing of them properly. That helps free up
their resources quickier.
MS released a great book in their patterns and practices called Improving
.Net Application Performance and Scalability. You don't have to buy it
though as they also made a downloadable PDF version at:
http://msdn.microsoft.com/library/d...n
et.asp
This has a good number of well-organized do's and dont's that would let you
dig through and check to see if there is something going on in your code
that could be altered or some setting that could be tweaked to avoid your
issues.
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199...2006
"Sachin Salgarkar" <sachin@.aegiscommerce.com> wrote in message
news:uN7rUpG7GHA.4552@.TK2MSFTNGP05.phx.gbl...
> We have a Win 2003 Server that runs around 15 instances of an ASP.NET 1.1
> Web Application ( in the same application Pool).
> Each instance connects to a SQL 2K database on a separate database server.
> The database size is around 100 MB (min ) to 3 GB Max.
> The web server is a 2.6 GHZ Xeon with 2 GB of RAM.
> The database server is a dual proc Xeon with 4 GB of Ram.
> Each instance of the Web Application has an average of 15 users.
> We reboot the servers every wend.
> I have set the Worker Process to recycle at 4 AM everyday.
> The problem is that our clients often receive Out Of Memory exceptions.
> Task
> Manager doesn't show any abnormal activity.
> The Memory Utilization on the web server seems to be around 500 MB ..
> which
> should be fine for a 2 GB RAM system that is used solely as a web server.
> My questions:
> 1 Are we overloading the server. ?
> 2 What tweaks or configuration changes can we do to improve performance.
> Thanks,
> Sachin Salgarkar
>
Thanks Mark.
-Sachin
"Mark Fitzpatrick" <markfitz@.fitzme.com> wrote in message
news:uVUhZxG7GHA.2380@.TK2MSFTNGP02.phx.gbl...
> Sachin,
> Sometimes it can be something as simple as changing the
> connectionstring to the database slightly to improve pooling, or ensuring
> that the garbage collection is happening correctly. Even though .Net is
> managed, garbage collection should still be written to handle the closing
> of datareaders/connections and disposing of them properly. That helps free
> up their resources quickier.
> MS released a great book in their patterns and practices called Improving
> .Net Application Performance and Scalability. You don't have to buy it
> though as they also made a downloadable PDF version at:
> http://msdn.microsoft.com/library/d...br />
enet.asp
> This has a good number of well-organized do's and dont's that would let
> you dig through and check to see if there is something going on in your
> code that could be altered or some setting that could be tweaked to avoid
> your issues.
>
> --
> Hope this helps,
> Mark Fitzpatrick
> Former Microsoft FrontPage MVP 199...2006
> "Sachin Salgarkar" <sachin@.aegiscommerce.com> wrote in message
> news:uN7rUpG7GHA.4552@.TK2MSFTNGP05.phx.gbl...
>

Wednesday, March 28, 2012

Web Server Performance

We have a Win 2003 Server that runs around 15 instances of an ASP.NET 1.1
Web Application ( in the same application Pool).
Each instance connects to a SQL 2K database on a separate database server.
The database size is around 100 MB (min ) to 3 GB Max.
The web server is a 2.6 GHZ Xeon with 2 GB of RAM.
The database server is a dual proc Xeon with 4 GB of Ram.
Each instance of the Web Application has an average of 15 users.

We reboot the servers every weekend.
I have set the Worker Process to recycle at 4 AM everyday.

The problem is that our clients often receive Out Of Memory exceptions.
Task
Manager doesn't show any abnormal activity.
The Memory Utilization on the web server seems to be around 500 MB .. which
should be fine for a 2 GB RAM system that is used solely as a web server.
My questions:
1 Are we overloading the server. ?
2 What tweaks or configuration changes can we do to improve performance.

Thanks,
Sachin SalgarkarSachin,
Sometimes it can be something as simple as changing the
connectionstring to the database slightly to improve pooling, or ensuring
that the garbage collection is happening correctly. Even though .Net is
managed, garbage collection should still be written to handle the closing of
datareaders/connections and disposing of them properly. That helps free up
their resources quickier.

MS released a great book in their patterns and practices called Improving
..Net Application Performance and Scalability. You don't have to buy it
though as they also made a downloadable PDF version at:
http://msdn.microsoft.com/library/d...ml/scalenet.asp
This has a good number of well-organized do's and dont's that would let you
dig through and check to see if there is something going on in your code
that could be altered or some setting that could be tweaked to avoid your
issues.

--
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006

"Sachin Salgarkar" <sachin@.aegiscommerce.comwrote in message
news:uN7rUpG7GHA.4552@.TK2MSFTNGP05.phx.gbl...

Quote:

Originally Posted by

We have a Win 2003 Server that runs around 15 instances of an ASP.NET 1.1
Web Application ( in the same application Pool).
Each instance connects to a SQL 2K database on a separate database server.
The database size is around 100 MB (min ) to 3 GB Max.
The web server is a 2.6 GHZ Xeon with 2 GB of RAM.
The database server is a dual proc Xeon with 4 GB of Ram.
Each instance of the Web Application has an average of 15 users.
>
We reboot the servers every weekend.
I have set the Worker Process to recycle at 4 AM everyday.
>
The problem is that our clients often receive Out Of Memory exceptions.
Task
Manager doesn't show any abnormal activity.
The Memory Utilization on the web server seems to be around 500 MB ..
which
should be fine for a 2 GB RAM system that is used solely as a web server.
My questions:
1 Are we overloading the server. ?
2 What tweaks or configuration changes can we do to improve performance.
>
Thanks,
Sachin Salgarkar
>


Thanks Mark.

-Sachin

"Mark Fitzpatrick" <markfitz@.fitzme.comwrote in message
news:uVUhZxG7GHA.2380@.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

Sachin,
Sometimes it can be something as simple as changing the
connectionstring to the database slightly to improve pooling, or ensuring
that the garbage collection is happening correctly. Even though .Net is
managed, garbage collection should still be written to handle the closing
of datareaders/connections and disposing of them properly. That helps free
up their resources quickier.
>
MS released a great book in their patterns and practices called Improving
.Net Application Performance and Scalability. You don't have to buy it
though as they also made a downloadable PDF version at:
http://msdn.microsoft.com/library/d...ml/scalenet.asp
This has a good number of well-organized do's and dont's that would let
you dig through and check to see if there is something going on in your
code that could be altered or some setting that could be tweaked to avoid
your issues.
>
>
--
Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006
>
"Sachin Salgarkar" <sachin@.aegiscommerce.comwrote in message
news:uN7rUpG7GHA.4552@.TK2MSFTNGP05.phx.gbl...

Quote:

Originally Posted by

>We have a Win 2003 Server that runs around 15 instances of an ASP.NET 1.1
>Web Application ( in the same application Pool).
>Each instance connects to a SQL 2K database on a separate database
>server.
>The database size is around 100 MB (min ) to 3 GB Max.
>The web server is a 2.6 GHZ Xeon with 2 GB of RAM.
>The database server is a dual proc Xeon with 4 GB of Ram.
>Each instance of the Web Application has an average of 15 users.
>>
>We reboot the servers every weekend.
>I have set the Worker Process to recycle at 4 AM everyday.
>>
>The problem is that our clients often receive Out Of Memory exceptions.
>Task
>Manager doesn't show any abnormal activity.
>The Memory Utilization on the web server seems to be around 500 MB ..
>which
>should be fine for a 2 GB RAM system that is used solely as a web server.
>My questions:
>1 Are we overloading the server. ?
>2 What tweaks or configuration changes can we do to improve performance.
>>
>Thanks,
>Sachin Salgarkar
>>


>
>

web server setup

I have a server that will be running as a web server and a database server?
To get the best performance is it better to install the database and web
server on seperate physical hard drives? or it doesn't matter?
I have a total of 8 harddrives, what RAID setup should i choose?
Thanks,
FredHere's a definition of some RAID levels: http://www.webopedia.com/TERM/R/RAID.html

You can implement level 0 for improved performance but you will need a
controller that supports what you want to do. Try to avoid RAID at the
O/S level - get some hardware that will handle it for you.
On Jul 28, 10:25 pm, "Fred" <fredbb...@.yahoo.com> wrote:
> I have a server that will be running as a web server and a database server
?
> To get the best performance is it better to install the database and web
> server on seperate physical hard drives? or it doesn't matter?
> I have a total of 8 harddrives, what RAID setup should i choose?
> Thanks,
> Fred
Fred,
Yes it is.
There isn't one setup you should choose. You need to juggle the following:
- mirrored pair gives more performance than RAID5
- SQL Log File can be better on its own drive separate from the SQL data,
allowing both to be written at the same time
- OS page file ideally on separate drive, but its a toss up between this and
the SQL log file.
So a typical setup would be either mirrored pair for OS plus RAID5 for data;
or mirrored pair for OS, mirrored pair for SQL logs and RAID5 for data.
Other factors to consider: more memory to save writing to disk; enterprise
editions to use more memory.
Anthony
http://www.airdesk.co.uk
"Fred" <fredbb123@.yahoo.com> wrote in message
news:%23c7EOfY0HHA.1164@.TK2MSFTNGP02.phx.gbl...
>I have a server that will be running as a web server and a database server?
> To get the best performance is it better to install the database and web
> server on seperate physical hard drives? or it doesn't matter?
> I have a total of 8 harddrives, what RAID setup should i choose?
> Thanks,
> Fred

web server setup

I have a server that will be running as a web server and a database server?
To get the best performance is it better to install the database and web
server on seperate physical hard drives? or it doesn't matter?
I have a total of 8 harddrives, what RAID setup should i choose?

Thanks,
FredHere's a definition of some RAID levels: http://www.webopedia.com/TERM/R/RAID.html
You can implement level 0 for improved performance but you will need a
controller that supports what you want to do. Try to avoid RAID at the
O/S level - get some hardware that will handle it for you.

On Jul 28, 10:25 pm, "Fred" <fredbb...@.yahoo.comwrote:

Quote:

Originally Posted by

I have a server that will be running as a web server and a database server?
To get the best performance is it better to install the database and web
server on seperate physical hard drives? or it doesn't matter?
I have a total of 8 harddrives, what RAID setup should i choose?
>
Thanks,
Fred


Fred,
Yes it is.
There isn't one setup you should choose. You need to juggle the following:
- mirrored pair gives more performance than RAID5
- SQL Log File can be better on its own drive separate from the SQL data,
allowing both to be written at the same time
- OS page file ideally on separate drive, but its a toss up between this and
the SQL log file.
So a typical setup would be either mirrored pair for OS plus RAID5 for data;
or mirrored pair for OS, mirrored pair for SQL logs and RAID5 for data.
Other factors to consider: more memory to save writing to disk; enterprise
editions to use more memory.
Anthony
http://www.airdesk.co.uk
"Fred" <fredbb123@.yahoo.comwrote in message
news:%23c7EOfY0HHA.1164@.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

>I have a server that will be running as a web server and a database server?
To get the best performance is it better to install the database and web
server on seperate physical hard drives? or it doesn't matter?
I have a total of 8 harddrives, what RAID setup should i choose?
>
Thanks,
Fred