You’ll want to fire up SQL Profiler on the SQL database which isn’t working and see what commands are taking a long time. Perhaps some indexes need to be added to that database.
My question would be, if you are simply downloading XML and storing it in the database, why not store those XML files directly on the web servers, and open the XML files from the web pages directly without the database. What purpose does the database serve in this setup? It sounds at first glance like the database isn’t needed at all.
Can you elaborate more on what the database is used for and how the data is stored?
Thank you for your reply.
We are storing the data for the further use. More over this data is used to display on our thin client software that will be running on our members desktop.
It was running good some time ago. But all of a sudden, my website is taking very long time load as the server is CPU usage is touching 100% due to these applications running on the server.
If I stop the applications running, then CPU usage falls down to 2%.
It was not the problem with my other virtual dedicated server, where the same application is running. But the SQL is on different server.
It seems the problem arises where both application and SQL are on same server machine.
Please help me with this, as it has been more than a week since I am begging everyone on forums to help me.
Thanking you in advance,