I have an resource scheduling application that performs SQL queries via the SQL Native Client. This application is currently running on Windows 2000 Servers with MetaFrame XP. We have purchased new hardware and have tested the application with Windows 2003 Server Standard 32-bit with MetaFrame Presentation Server 4.0 (rollup pack 4) . On the application, you select a location resource and then a person resource and the calendar appears showing when the two resources are available next. Works fine on MF XP.
On PS 4.0, when you switch from one location to another, a SQL query is performed. On some instances, the Published App will hang (hour glassed) for anywhere from 30 to 120 seconds. The only user on the box using the app is me (Still in testing). When the app is ran directly from the server (thick) it works fine but on some instances it will hang (hour glass) for AT MOST one second, this holds true for both thick and thin on 2000 w/ MF XP.
At no time do any users on 2000 w/ MF XP experience this problem, connecting to the exact same database, server, on the same network.
I have tried various Citrix Client versions, I have tried the SQL native client from the SQL 2000 and 2005. I have rebuilt one server with only Windows, Citrix, hardware drivers, SQL client, and app.
I'm not sure what else to look at in this case as it is obvious something to do with how Citrix reacts to the SQL query. Any clues to a fix?