Problems since migrating SIMS to SQL 2008 Server
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.
Sqlservr.exe is using 1,493,696 K of memory and hardly any of the CPU in the new Server (which has 10Gb RAM).
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!