Web server performance

My server is Windows 2003 co-exist with SQL2000 database, this is a web application server. I was told that when more user access to server, they reported that the speed is very slow. This server has 3GB RAM and P4 Xeon 2.4GB CPU and equipped with one 10Krpm SCSI harddrive. When I use the windows performance counter log to check it, I found it everything is normal. What else can I check to find out why the response is slow.

Try to see how many users are connecting to the website and the useage of the w3wp.exe in the taskbar. Normaly there is an increasement of the amount of memory there. You say that you have 3 Gb as memory then to utilize this fully you have to operate enterprise editiuon of the OS and SQL else there´s no more that 2 Gb max allocated for the application. Try also to monitor the IIS logs for the usage of the memory. Try to start a other pool for this special webservices and allocate some more memory from the beginning. And last but not least when there are a lot of simultanious connections the OS can reach it´s maximum of open connections allowd. So try to change here some param.

Very possible that there are poorly written SQL quieries and/or poorly written web code. Start with checking all SQL statements by copy them from the web code and paste them into SQL Query analyser, execute them and see how long they take to complete. Also, you can use SQL profiler. Take the poorly performing SQL and optimize them and/or create new indexes on the requested data. This could also be caused by web code (ASP or .NET, or whatever the language used), the debug method would depend on the platform/code used.

Featured Post

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

by Batuhan Cetin
Within the dynamic life of an IT administrator, we hold many information in our minds like user names, passwords, IDs, phone numbers, incomes, service tags, bills and the order from our wives to buy milk when coming back to home.…

This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP, Windows Server…

In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …

We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data.
But that feeling is fleeting. Attacks these days can happen in many w…