Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
SteveGray 4/3/2013 12:02:23 PM

GP9 SQL 2005 slow

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.

Version: GP 9
Section: Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables