Hello I have created a development environment on my local windows xp pro computer in order to test out a dotnetnuke site written in the asp.net framework with iis being the server.
My computer is an athlon 64 bit 3000+ (equivalent to 2.0 GHZ) I have 2 GB of memory a 500 GB SATA hard drive that runs at 7200 rpms and a 128 mb geforce nvidea graphic card.
As I stated earlier I am running windows xp pro and downloaded the microsoft server express for my database used soely in a development environment. I am the only one that access this database so it is only one user at a time and yet I find developing on my computer very slow.
In fact when I look at the processes after I have opened internet explorer or firefox under http://localhost/dotnetnuke
I find that the sqlservr.exe process averages about 95 to 97% of my CPU usage sometimes dropping down to 88 %
My question is do you have any tips on why this might be happening. Is Microsoft server express designed to accept queriers really slow because it is a free version of the paretn mssql server or do you think it could have to do with something to do with etiher the dotnetnuke framework or my local system somehow.
This is Microsoft server 2005 and to give you an idea of how slow it is anytime you access a page it could take up to 30 seconds to query sometimes 20 seconds but for every update, or navigation done in this environment it takes the database a lot more time than it seems it should to bring back results to the localhost.
The live environment is a little slower than I'd like but certainly 4 times faster than my development environment.
Do you think it is the microsoft server express that is the underlying cause of this speed issue, would it be any quicker if I was to invest in the ms sql server instead given only one user at a time is accessing this environment or should I look to some kind of way my windows is configured.
Thanks for reading this question and responding