Hi Team, My website is working very slow, most of the time i get a error “Max’s number of Connections †and when I/O operation happens it gives me “out of memory†error, my development team reports that Server is not capable of running the website and my hardware tem tells that this server is a monster it can take this load easily, so I want to check where is the Problem, Can some body suggest me a tool which will tell me how many con current request my server can handle, I am planning to install my website script on different machine and test the performance on that machine, I want a tool for the same. Thanks in Advance Regards, Jitendra
Hi nicejits, I use the Apache Benchmarking tool (see http://httpd.apache.org/docs/2.0/programs/ab.html) to put some load on the server and then run the MySQL tuning primer script (see http://www.day32.com/MySQL/) to pick up the database tuning recommendations. If you are using a single host for your webserver and your database server then it might be more efficient to use unix socket connections. Petey
Can you post your server's specs, your current traffic load, and the contents of my.ini here? How many queries are being performed on each page view? Also, are you using pconnect?
hi, you should make some load tests and, If this is a windows server, you could check (using perfmon utility) system counters. What kind of database (mssql, mysql, oracle) is that?