We decided to duplicate an existing web-application (for Podcasting kit), which has site collection only at root level, so created a new web-application (in the same DB instance) and imported (stsadm –o import) the site collection from the existing web-application, did the required configuration changes however did not touch the code.
Now, the duplicate web-application is up and functioning as expected however we are facing a potential performance issue, it throws “Unable to connect to the Database” exception every now and then and I found more than 100 heaps are created while processing the request and w3wp.exe is getting crashed.
We do not have any performance issues with the existing web-application however it is also getting crashed (share the same Database Instance) due to the bad performance of the new web-application.
I could not find any clue to fix this, any clues.