Last post Apr 03, 2006 05:25 PM by sehatrosny
Apr 02, 2006 05:22 PM|sehatrosny|LINK
Environment : Windows 2003 Web Server
Database : SQLServer Express 2005
Others Database : Postgres 8
.NET Framework 2.0
From the graphics below, is it more memory needed? (Hopefully, the flickr site able to keep showing this). Even at the time memory is not used, the website loading slow.
When is it the time to say, need to add more memory?
Apr 03, 2006 01:23 PMfirstname.lastname@example.org|LINK
From the graphic it doesn't look like you're having a problem. But you have only 1 GB of physical memory, so upgrading it would be wise, at least to 2 GB.
Are you having troubles that make you think you need something or are you just curious?
Apr 03, 2006 02:01 PM|sehatrosny|LINK
Yeah, sometimes I have problems. I have 10 website.
a. 1 using asp.net and postgres 8.0 => this doesnot have problem the response time very fast
b. 5 asp.net 2.0 and SQLServer express 2005 => this sometimes fast some time slow.
I already taking the account after certain time, the application pool/aspnet/IIS goes out if there is no body accessing the site. So I try to ping/grap every site every 10 seconds. That's why the w3wp.exe can keep active.
For website with Postgres 8.0 the response time did not have any problem at all.
However, for ASP.net 2.0 with SQLServer Express 2005, I have problem. Sometimes it is responding very slow about 7 seconds to 10 seconds. Sometimes, it is responding very fast 1 seconds.
It is the limitation of SQLServer Express 2005? Did not allow more than 6 Databases? So that's why it is free database.
If I want to trouble shoot, where is the best way to start
a. From coding? have timing for each section of the layer from aspx to database
b. Performance Monitor? =>
c. Application Center Test? => Currently it only able to handle 5 Request Per Second. Pretty lamb..
Thanks in Advances
Apr 03, 2006 05:00 PMemail@example.com|LINK
> However, for ASP.net 2.0 with SQLServer Express 2005, I have problem. Sometimes it is responding very slow about 7 seconds to 10 seconds
If this is on the first hit on the site in a while, it's likely the recompile time for the applications. Pinging the site will have no effect on this, since it never request a page.
Again, adding RAM is the cheapest bang for the buck you'll get. With multiple applications on the server, RAM can get used pretty quick. At the least you'll cache more information.
Apr 03, 2006 05:25 PM|sehatrosny|LINK
objResponse = myHttpWebRequest.GetResponse();
objSR = new StreamReader(objResponse.GetResponseStream(), System.Text.Encoding.ASCII);
strContent = objSR.ReadToEnd()
One of the reason, I have not added the memory yet(In the future I will added, thanks for the advice). Because it run pretty fast using posgres but not when using SQLServer Express 2005. I want to troubleshoot where it is happening
Thanks for the feedback.