previously my application running on the tomcat4.1 and sqlserver2000 now its running on weblogic8.1 and sqlserver2005. But now the performance decreases up to 80%. Suggest me now what i will have to do get better performance. Thanks jamdagni
You changed two things that can cause the issue at the same time. In essence, this means that you've changed the complete infrastructure. Makes it hard to see if it's caused by the application server or by mssqlserver.
Try to find the cause for the performance drop: the database, the apps server, the way you've configured them, the network, is it a general performance drop or only some pages impacted, ...)
Are you running the services on the same machine? Do you have sufficient resources for the new services (memory, processor, ...)? Are you using the same network bandwith (or the same type of network card) as before?
Please review the JavaRanch naming policy and update your name accordingly.
As for the answer to your question? Wow... that's vague. You need to provide a lot more information before any kind of real solution could be made. You should run performance test on small operations to determine the bottleneck operations. In general no database is created equal, so there's no reason to think you'd get exactly the same performance right after a migration.