I have a .Net webform application hosted on Windows 2003 Server running IIS. Its a new Dell PowerEdge server.
My Problem: anytime someone accesses the web application, it takes forever (two to three minutes) to return a result of a database query the application is performing. Each subsequent use of the application within the same browser session has instantaneous results.
There's no performance tuning available to me on the PervasiveSQL Workgroup Database Engine that this application is calling. Further, I have the same function in Windows Application and its always instantaneous. Therfore, I'm fairly certain it is a performance issue with IIS.