We just upgraded a GP 9 customer from SQL 2000 to 2005, and the environment is responding much more slowly than before. I'm wondering if anyone has some sage advice.
Before you start judging me on GP9/SQL2005, I can't help that. I'm just a dev/sql guy, I don't make the decisions.
Anyway, GP 9 is running on a newer Server 2008 64 bit terminal server, and SQL is a 32bit Server 2003 box.
GP responds about twice as fast when you open the client on the server as opposed to the TS box. Neither box appears particularly taxed, about 15 users on the TS right now.