+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Problems since migrating SIMS to SQL 2008 Server in Technical; Hi, Bit of a strange one. I recently migrated my SIMS/FMS data to a faster, more reliable Server. As part ...
  1. #1
    bandgeekmafia78's Avatar
    Join Date
    May 2007
    Location
    Salford
    Posts
    382
    Thank Post
    88
    Thanked 22 Times in 14 Posts
    Rep Power
    21

    Problems since migrating SIMS to SQL 2008 Server

    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!
    Last edited by bandgeekmafia78; 1st March 2010 at 08:55 AM. Reason: needed to add something extra.

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,600
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181
    Is SIMS maybe still looking for your old server? This would explain why new installs are quicker.

  3. Thanks to Ric_ from:

    bandgeekmafia78 (1st March 2010)

  4. #3
    bandgeekmafia78's Avatar
    Join Date
    May 2007
    Location
    Salford
    Posts
    382
    Thank Post
    88
    Thanked 22 Times in 14 Posts
    Rep Power
    21
    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.

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    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.
    Last edited by vikpaw; 1st March 2010 at 09:25 AM. Reason: edit

  6. Thanks to vikpaw from:

    bandgeekmafia78 (1st March 2010)

  7. #5
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,829
    Thank Post
    918
    Thanked 422 Times in 355 Posts
    Blog Entries
    12
    Rep Power
    88
    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.

  8. Thanks to zag from:

    bandgeekmafia78 (1st March 2010)

  9. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Also, try running just pulsar.exe without the SIMSLoad bit, i reckon that will make them all run quick.

  10. #7
    bandgeekmafia78's Avatar
    Join Date
    May 2007
    Location
    Salford
    Posts
    382
    Thank Post
    88
    Thanked 22 Times in 14 Posts
    Rep Power
    21
    Sorted. Thanks a lot for your help - turns out the local sims.ini file was looking at the old server for its updates.

  11. #8
    BandyQuill's Avatar
    Join Date
    Nov 2009
    Location
    Pontefract
    Posts
    234
    Thank Post
    4
    Thanked 19 Times in 18 Posts
    Rep Power
    13
    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!

  12. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    Quote Originally Posted by BandyQuill View Post
    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.

  13. #10
    BandyQuill's Avatar
    Join Date
    Nov 2009
    Location
    Pontefract
    Posts
    234
    Thank Post
    4
    Thanked 19 Times in 18 Posts
    Rep Power
    13
    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

  14. #11
    Darylrese's Avatar
    Join Date
    Sep 2010
    Location
    Portsmouth
    Posts
    422
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    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.

  15. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    6,009
    Thank Post
    680
    Thanked 1,398 Times in 1,158 Posts
    Rep Power
    353
    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...

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle / Server 2008 / IIS7 / MS SQL Server 2008 Express
    By Kamran7860 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 23rd November 2010, 06:03 AM
  2. SIMS SQL 2008 migration utility
    By Oops_my_bad in forum MIS Systems
    Replies: 28
    Last Post: 11th February 2010, 02:29 PM
  3. Sims SQL 2008 install
    By Simcfc73 in forum MIS Systems
    Replies: 11
    Last Post: 4th February 2010, 10:23 AM
  4. Migrating printers from Server 2008 to 2003
    By bandgeekmafia78 in forum Windows Server 2008
    Replies: 0
    Last Post: 27th August 2009, 11:04 AM
  5. SIMS SQL 2008 migration
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 8th August 2009, 12:08 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •