Don't think ull get much help here as this isn't quite the right forum to ask for Performance related stuff (theres a separate forum for doing so - where there are more people who could share their experience with u)
Originally posted by kiranreddy2k: Recently i was aksed in a interview what are performance bottlenecks? And how do you do performance tuning?So what is performance tuning?
<font size="2" face="Verdana, Arial, Helvetica">I am attempting to list the most frequently encountered performance bottlenecks.
1. Memory Leaks (usually shows up after a few hours of load test).
2. Database deadlocks.
3. Process Deadlocks (process in use by another user, causing the following user to wait).
4. Open Database connection pool fills up (happens when the application does not release the connection, causing the connection pool to be used up).
5. SQL Query that is not optimized (like Get * from xxx where yyy like, resulting in lots of records being returned).
But this list is not all inclusive. Each application is individual in how it behaves.