Problems since migrating SIMS to SQL 2008 Server

[bandgeekmafia78]

Hi,

 

Bit of a strange one. I recently migrated my SIMS/FMS data to a faster, more reliable Server. As part of the migration I upgraded to SQL 2008.

 

Since the migration, some computers are taking up to 5 minutes to log into SIMS.net but once they are logged in everything seems to be as normal. SIMSLOAD is taking forever to load it seems. However, on some computers it goes into SIMS.net really quick?! This isn't down to the performance of each individual computer as I've seen SIMS.net load pretty fast on the slower computers and slow on the faster ones.

 

Any ideas?

 

Sqlservr.exe is using 1,493,696 K of memory and hardly any of the CPU in the new Server (which has 10Gb RAM).

 

Ta.

 

ps, if I do a completley fresh install of SIMSInfrastructure and SIMSInst it seems to work fine. Really don't want to go round every school computer and do this though!

Edited March 1, 2010 by bandgeekmafia78
needed to add something extra.

[Ric_]

Is SIMS maybe still looking for your old server? This would explain why new installs are quicker.

[bandgeekmafia78]

Thats what I was thinking too, but where can I check this? I have edited the S:\Sims\Connect.ini file to point at the new server and database. Is there any other way to check this?

 

Thanks.

[vikpaw]

check local sims.ini is not still referring some modules on the old server.

searching for something that isn't there would cause it to wait for a timeout.

 

EDIT: assuming you've maintained the same mapped drive letter etc. it should be okay, but i know on mine the server is referenced by name at the top for the location of setups, and that's one of the first places it looks.

Edited March 1, 2010 by vikpaw
edit

[zag]

Its probably using the relative path in the sims.ini file rather than the mapped drive looking for upgrades.

 

you can browse to the \\computername\c$\windows\sims.ini file and change it in there to use the mapped drive.

[vikpaw]

Also, try running just pulsar.exe without the SIMSLoad bit, i reckon that will make them all run quick.

[bandgeekmafia78]

Sorted. Thanks a lot for your help - turns out the local sims.ini file was looking at the old server for its updates.

[BandyQuill]

just a quick one, when we migrated to a new server weve told sims not to search for updates automatically this improves the performance 10fold especially on the laptops!

[vikpaw]

just a quick one, when we migrated to a new server weve told sims not to search for updates automatically this improves the performance 10fold especially on the laptops!

 

so long as you can get them hooked into the network when you need for a forced upgrade either manual or automatic with solus3.

[BandyQuill]

weve also put an ''upgrade sims.net'' icon on the desktop with sims that when we say so everyone runs on there own machine, makes it realy easy here, there arnt that many updates and last time we only had 2 people come to us with issues

[Darylrese]

Hi Guys,

 

At our school we are having big problems with SIMS and PARS since upgrading to SQL 2008. Reports can take 15 - 20mins to load on some, where as others will run it in 1 - 2 minuets.

 

Users report it used to take under 1min. The sims.ini and connect.ini files are correct, all patches have been applied. Our server is not being strained and TASC who make PARS have been on the server for hours making changes but nothing has worked.

 

Any suggestions? We are stumped.

[vikpaw]

If you did the upgrade in situ on the same server, is the old 2005 instance running, that will take some resources. You could turn it off.

Did you also upgrade the workstations, perhaps to windows 7 / office 2010. I've had some issues on the client side with reports...