+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, sims.net on sql server 2008_windows 2003 in Technical; Hi all my sims server is currently given me a load of grief, maxing the processor. Its on a Citrix ...
  1. #1

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    sims.net on sql server 2008_windows 2003

    Hi all my sims server is currently given me a load of grief, maxing the processor. Its on a Citrix xen virtual server with 4 vcpus and 4gb of RAM and it appears that this problem only really started to surface when we upgraded the sql install from sql 2005 to sql 2008. I am presuming that sql server 2008 is more resource hungry and i need to fine tune the performance.

    Does anyone have any tips for ensuring best possible performance both from a sims point of view and a sql server 2008 point of view? i have ran through some maintenance tasks in sql server but to be honest its a bit of guess work at the moment..

    Thanks in advance

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    Did you do an in-situ upgrade of the SQL? I moved to a new server when i did my recent upgrade and inadvertently used a base VM that only had 1 vCPU when i thought it had 4. CPU spiked a bit in testing!

    Other than a silly mistake like that, it could be wanting more RAM, as 4GB sounds low. The sum of my .mdf and .ldf is greater than 4GB at the moment. If RAM / disk access is slowing it down, it might hold on to the CPU a bit longer, or appear to. I know at peak times ours maxes out and runs a little slow.

    Also, have you turned off the old instance if you did go with installing a 2008 instance onto old server.

    I took some advice on possible tweaks, and was advised that SQL should be able to handle itself, so unless you are running other DBs / instances on the same server, or if the xen host itself is pretty full, you shouldn't need to do any tweaking.

    From the SIMS side, there have been quite a few reports of the home page panels causing a general slow down, if you look on SupportNet there are a few threads related to that. Do you have widespread use of the panels, i know it causes a delay on load up when i log in with my account that has lots of panels.

    It's on my todo list still, but there were some free analysis tools mentioned in this thread
    SIMs Monitoring

    Other advice on similar issues here
    SIMS slow after migration to SQL 2008
    SQL2008 VERY SLOW FOR ALL USERS

    might be worth a read for the various troubleshooting tips.

  3. Thanks to vikpaw from:

    Uraken (21st May 2011)

  4. #3

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17
    Yes i did an in situ install so the old sql server 2005 was still present but i have turned off all the services etc (which did make a difference, i'm stalling on doing an uninstall as i have msde 2005 running for easytraces follow me print solution so don't wanna mess that up).

    The problem i have with the RAM is i am on 32 bit 2003 so 4gb is my limit, the xen host itself could be a bit full so that is somewhere i could start, along with turning the panels off as you suggest. I will take a look at the links that you have posted and hopefully things will improve.

    Thanks for your comprehensive reply and suggestions, most appreciated.

  5. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    I was looking at some of my hosts today (vmware) and read a thread here about vCPUs on VMs. Made me look at some of ours, and i decided to drop the intranet server down from 2 to 1, as it maxes out at 350MHz. SIMS uses all 4 peaking at 10GHz ish, and also easily eats up the 10GB memory i throw at it. Especially when i ran a full class photo report to word for the whole primary school.

    I would definitely consider starting a new clean server on 2008 R2, that's what i just did over easter, to get away from the old 2k3 which was probably a 2k before that too! You can then leave a low powered 2k3 for your print solution as long as you like.

  6. #5

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17
    Yeah that is a good idea, did you document the sims move to the new server? could do with a heads up if you did?

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    Sort of, not in office now, but will be around tomorrow. Mentioned it in a number of threads here though. Basically, clean install OS, then sql, download and install the spring 2010 installable iso from capita, upgrade it to spring 2011 or whatever version you are up to, then attach your db to it. everything golden. do all the tweaking regarding doc server and ports etc. only thing to hinder might be the need to remap server share for users and edit sims.ini if it's hardcoded with sharename.

  8. #7

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17
    thats a great start thanks did you say 64bit 2k8 ? or 32 bit ?

  9. #8
    pritchardavid's Avatar
    Join Date
    Sep 2009
    Location
    South Ockendon, Thurrock, United Kingdom
    Posts
    932
    Thank Post
    18
    Thanked 64 Times in 58 Posts
    Rep Power
    26
    He said 2008 r2 64bit

  10. Thanks to pritchardavid from:

    Uraken (23rd May 2011)

  11. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    Quote Originally Posted by Uraken View Post
    thats a great start thanks did you say 64bit 2k8 ? or 32 bit ?
    Quote Originally Posted by pritchardavid View Post
    He said 2008 r2 64bit
    yep ^. R2 is 64bit

  12. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    @Uraken - here's a link to a thread where i posted about some of the issues and the files needed between the old installable and the latest version, though there should by now be a current Spring 11 installable which would save some hassle. Also documented the issues with which ports to allow through firewall in 2008.
    Setting up a test from backup

    Also, you might find this interesting, especially when it goes wrong: Anyone have 2005 or 2006 Spring Update CD? Or August 2007?

  13. Thanks to vikpaw from:

    Uraken (23rd May 2011)

  14. #11

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17
    Thanks Vikpaw i will take a look through this, i know this is not best practice, but given that this is a xen server with very little bloat, i am toying with the idea of an in place upgrade from windows 2003 server to windows 2008 server so that i can take advantage of more RAM, i'm just researching any gotchas at the moment.

  15. #12

    Join Date
    Apr 2008
    Posts
    853
    Thank Post
    111
    Thanked 112 Times in 108 Posts
    Rep Power
    46
    Change from full to simple logging (if you have good backups) helped alot!

  16. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,893
    Thank Post
    751
    Thanked 1,469 Times in 1,220 Posts
    Rep Power
    364
    Quote Originally Posted by irsprint84 View Post
    Change from full to simple logging (if you have good backups) helped alot!
    Helps manage the transaction file better, and stops it exploding iirc.

    @Uraken - no issue with in place upgrade, it's only, if something goes wrong that's your live server, now virtualisation will overcome that somewhat, but personally, if you have the capacity, i would take the time to prepare the new machine, and then have minimal downtime by just switching over. Obviously with the caveat regarding mapped drive changeover and potential need to update sims.ini files it's nicer.

    It's just seems like a lot of effort to increase the RAM, and it might not be that which is causing your slowdown. It could just be the general issues with the latest upgrade that everyone is having.



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS.Net / SQL Server 2008 Service Pack 2 (SP2)
    By Minkus in forum MIS Systems
    Replies: 5
    Last Post: 13th December 2010, 03:34 PM
  2. Upgrading a SIMS.net Server from Server 2000 to 2003
    By PrimaryTech in forum Windows Server 2000/2003
    Replies: 8
    Last Post: 20th November 2010, 09:16 PM
  3. sims.net SQL Server CPU Spike
    By itgeek in forum MIS Systems
    Replies: 6
    Last Post: 26th February 2009, 01:28 PM
  4. sims.net sql server 2005
    By itgeek in forum MIS Systems
    Replies: 2
    Last Post: 14th March 2008, 07:02 PM
  5. Replies: 3
    Last Post: 7th July 2006, 03:21 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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