[sims] SIMS Spring 2012 Slower?

[lollettuk]

Is it just me or has anyone else noticed SIMS Spring 2012 is slower than Autumn 2011???

 

Login seems to take 2-3 times longer...Reporting is bringing up taking a little longer messages more often!

 

We have a call in with Capita, but getting the usual upgrade from MSDE to FULL SQL and CPU performance / Memory response.

[matt40k]

Not really, .net4 had a performance hit when we moved over. Do you use InTouch or such?

 

PS: MSDE - how old skool

[matt40k]

Oh, just thought, how much disc space you got on the drive that SQL installed? What size is your ldf's

[lollettuk]

Dedicated M$ SQL Clusters on multiple SANS running fast disks (loads of space)... Admittedly we have a few schools with 2gb+ logs, but for the most (200+) they tickover around 500Mb(logs).

 

Yes, we have the works SIMS, FMS, SLG, InTOUCH, DISCOVER, the usual 3rd Parties (and shortly EMERGE) but we keep everything on seperate SQL clusters.

 

I noticed the slow down during the service break (no other users on the system) Autumn 2011 running ok, upgrade Spring 2012 huge slowdown!!!! Anyone else????

Edited April 17, 2012 by lollettuk

[matt40k]

We've not noticed anything to be honest. Isn't this one of the first few upgrades since you've moved to your new SQL 2008 R2 cluster?

 

Wonder if Discover \ whatever new product is called is affecting it. What's your page life expectancy like? Do you reindex as a maintenance task?

[lollettuk]

We've had SQL2008 R2 on for over a year now and we have tried a reindex... oh well if nobody else has seen slowness then I can't blame Capita straight away this time!

 

Thanks Matt!

[matt40k]

Don't suppose your shortcut use simsload?

[lollettuk]

we skip simsload.exe and go straight for pulsar.exe...

[matt40k]

Thought you would. Just thought the change to simsload regarding the detection of the s3 service, but it won't be that. Has the memory footprint increased for sims since the release?

[lollettuk]

Not afar as i'm aware...but during the service break i'm on a 16core 64gb xeon server by myself

[lollettuk]

Found the issue:

 

C:\WINDOWS\SIMS.INI - SIMSSetupsDirectory pointing to a location no longer available! Updated, but you also have to delete any profile C:\Users\[username]\Windows\Sims.ini as it doesn't seem to pickup the WINDOWS\SIMS.INI changes.

[matt40k]

Umm... I thought you said you by pass simsload?

 

Also do you mean c:\users\[username]\virtualstore\.... ?

[lollettuk]

We do! SIMS .net shortcuts go to pulsar.exe but oddly if you set C:\WINDOWS\SIMS.INI (and the Users Profile SIMS.INI) - SIMSSetupsDirectory=[something that doesn't Exist] pulsar take 30sec (instead of 6-10secs) to load and various parts inside SIMS are very slow??!?!?!?!