I have an application that runs ad-hoc queries to a remote SQL server. I'm running into a bizarre problem with the application taking significantly longer to return results when the application is running as a user versus a local administration (to the workstation).
I launched my application normally, and then launched a separate instance by right clicking > run as administrator.
I started profiling the database. Using the exact same steps with the exact same query, the 'user' application takes 15 seconds to return data. When I run the application 'as administrator' it takes only 3 seconds.
I can't find a reason why the same application using the same steps running the same queries is taking significantly longer to return results. I've run the test several times with similar discrepancies.
I can reproduce the issue using multiple workstation and multiple domain user accounts. Anytime the user runs the application 'as administrator' (invoking local admin), it runs much quicker.
Any insight would be helpful here, I'm completely stumped.
EDIT: The application authenticates to the database using SQL authentication in both cases (using the same credentials).