[sims] [SIMS] After upgrading to SQL 2012 from 2008 slow client connection

[Gramzon]

We have been experiencing some issues after the database was upgraded by our SIMS support to 2012, they have looked at it a few times and have concluded that the issue is with our network. However I don't see any issues. The issue we are experiencing is that clients connecting to SIMS take minutes to load and is longer than it used to be, however when signing in to SIMS on the local server the load time is much quicker. We are running full version of SQL 2012 on a Windows 2008 R2 server. Is there anything I can do to diagnose this issue and what type of network issues can cause this?

 

Gramzon

[round2it]

is the sims.ini info correct

 

check a client

 

and the connect.ini this has the database name in it

should be in the sims.net folder on a client

Edited September 25, 2014 by round2it

[Gramzon]

They both seem to be correct, it does connect to SIMS eventually just takes a long time.

 

the sims.ini:

 

[LastChecked]

SIMSInfrastructureSetup=5.592.2.0

[setup]

SIMSDirectory=\\ServerName\Sims\SIMS

SIMSSetupsDirectory=\\ServerName\Sims\SIMS\Setups

SIMSDotNetDirectory=C:\Program Files\SIMS\SIMS .net

Folder=SIMS Applications

FinanceDirectory=C:\Program Files\SIMS\FMSSQL

 

Connect.ini:

[sIMSConnection]

REDIRECT=\\ServerName\Sims\SIMS

[Meldrew]

Is it worth running wireshark to see if you can spot delays in packets being received? Maybe run on both an example client and server.

 

Meldrew

[edutech4schools]

SIMSDirectory=\\ServerName\Sims\SIMS

 

These should all be mapped drives i think. so S:\\Sims etc.

[Gramzon]

I've changed it to s:\sims but it hasn't made a difference.

 

- - - Updated - - -

 

Not really sure what to look for in wireshark if I'm being honest.

[edutech4schools]

I've changed it to s:\sims but it hasn't made a difference.

 

Have you also checked the connect.ini file found in S:/sims?

[Gramzon]

JUST BEEN READING LOADS OF FORUM THREADS ON EDUGEEK AND CAME ACROSS A TOPIC THAT SUGGESTED WINDOWS UPDATE MIGHT HAVE TURNED THE FIREWALL ON. HEY PRESTO IT'S FIXED

 

Many thanks to all that helped.

 

I've changed it to s:\sims but it hasn't made a difference.

 

- - - Updated - - -

 

Not really sure what to look for in wireshark if I'm being honest.