Last post Mar 05, 2007 03:13 PM by ps2goat
Mar 05, 2007 01:19 PM|developercanada|LINK
I'm running Windows Server 2003 R2 SP1 Ent. edition with SQL Server 2005 and .NET 2.0 on a Dell Poweredge Server 4300.
The hardware specs are:
- Dual P3 Xeon at 500 Mhz
- 768MB Ram
- 76GB SCSI 10K
I have never experienced any slow downs on this machine until I run the classifieds starter kit. I takes about 30 secs to load the first page the first time and then about 17secs each time after that. I ran a trace on the default page and I did notice that
it's when the page gets rendered that it takes the maximum time (13-14 secs).
I have tweaked my IIS to get the maximum from the system (resources) but still didn't really helped.
For example, I tried the same type of site using PHP and MySQL, on the same box, with the same numbers of categories and the first page loads in 4 secs for the first time and then 2 secs after that.
Any idea of what is wrong or not optimized in IIS or the Framework so that it takes that long?
Thanks a lot for your help!
Mar 05, 2007 03:13 PM|ps2goat|LINK
If your specs are exactly as you say, it's no wonder that your system is so slow. Dual procs or not, 500 MHz doesn't get you very far. SQL Server 2005 requires a 600 MHz proc; if you have 2, they should both be
at least this speed. If the machine is also running your app, then you will start to experience extreme slowdown.
As for the RAM, there is a minimum of 512 MB required, and 1 GB is recommended.
here for the rest of the specs, and remember that these are for SQL Server 2005
only. You must also take into account other programs you are running, including .NET framework/ASP.NET, IIS, the OS, etc.