Hi all,
We're currently doing a GP10 to GP2015R2 upgrade at work and are seeing issues with performance after logging in and picking a company. The screen can go white for a good part of a minute and then finally come back to life with GP.
I ran SQL Profiler and stuck on debugging and have pinpointed the following in the DEXSQL.LOG file. Notice how the time jumps about 50 seconds before continuing.
Could someone please explain what smBindTableDefaults does and if there is a reason why this would take so long? Is this a red herring?
/* Date: 03/12/2016 Time: 16:08:45
stmt(173440872):*/
BEGIN DECLARE @stored_proc_name char(28) DECLARE @retstat int DECLARE @param2 int set nocount on SELECT @stored_proc_name = 'MyCo.dbo.smBindTableDefaults' EXEC @retstat = @stored_proc_name 0, @param2 OUT SELECT @retstat, @param2 set nocount on END
/*
/* Date: 03/12/2016 Time: 16:09:35
SQLSTATE:(01000) Native Err:(5701) stmt(0):*/
[Microsoft][SQL Server Native Client 11.0][SQL Server]Changed database context to 'master'.*/
Many thanks
Graeme
*This post is locked for comments