+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 23
MIS Systems Thread, SIMS Performance in Technical; We have just upgraded from SQL 2005 Express to the Enterprise Edition and i haven't really found much difference with ...
  1. #1
    MattGibson's Avatar
    Join Date
    May 2008
    Location
    Epsom
    Posts
    169
    Thank Post
    20
    Thanked 11 Times in 8 Posts
    Rep Power
    15

    Post SIMS Performance

    We have just upgraded from SQL 2005 Express to the Enterprise Edition and i haven't really found much difference with the performance and running of SIMS. We have a sexy HP server with a high spec The Lan is more-less all running on 1000MB with fibre switches.

    Are there any tweaks i could do to SQL 2005 ? (what are your settings?)
    Any SIMS files that could be tweaked?

    Cheers Guys!

  2. #2

    AngryTechnician's Avatar
    Join Date
    Oct 2008
    Posts
    3,730
    Thank Post
    698
    Thanked 1,212 Times in 761 Posts
    Rep Power
    394
    I wouldn't expect upgrading to Enterprise to yield much extra performance on its own. I think the big performance indicators for a database will be how well the actual database structure is normalised (hint: in SIMS, the answer is 'not very'), the actual size of the DB, whether it has indexes built for the right keys; all things you don't have much control over unless you fancy some completely unsupported tinkering with the DB schema, which would probably give Capita a heart attack if they caught you doing it, and break SIMS horribly if you mess it up.

    After that, you're looking at the server hardware (which you haven't changed) and possibly the client-side application performance (again, not something you can tweak much).

  3. #3

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,174
    Thank Post
    284
    Thanked 773 Times in 583 Posts
    Rep Power
    335
    Check you haven't got any realtime virus scan running on the database. Also, try specifically allocating memory to the SQL server helps. Another one is if you have more than 3Gb of memory you can get SQL to use it if you are on a 32-bit server. At home and can't remember exactly how to do it, but a google search should tell you.

  4. #4

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    879
    Thank Post
    274
    Thanked 139 Times in 112 Posts
    Blog Entries
    27
    Rep Power
    42
    Read on some Capita Docs a while back about not Virus Scanning the S: drive; speeds up load times of SIMS a bit.

    Pete

  5. #5
    D4RREN's Avatar
    Join Date
    Nov 2008
    Location
    Chelmsford
    Posts
    9
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Lightbulb resolution

    This could be to do with a number of things.

    sims.net it is quite resource demanding, what is the spec of the server.

    also check what processes are running, CPU usage or how much sims.net is taking up.

    You may find if you increase the virtual memory this will increase the performance.

    hope this is of any help.

    to stop any processes from starting in task manager just go
    Start | run | msconfig.

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,388
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    32bit your limited to 3GB really, assuming your MSSQL is config'd to use it all. I would look at 64bit. PM if you (or anyone) wants a SQL defrag script for SIMS.

  7. #7
    D4RREN's Avatar
    Join Date
    Nov 2008
    Location
    Chelmsford
    Posts
    9
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Just remember

    If your with Capita though they do not support the 64bit platform PC's

    So be wary of this, and also could cause problems launching 16it prgrams, I beleive that you would need to install something to get this running.

    As even in compatibility mode this will not run.


    I presume your server is Windows server 2003???


  8. #8

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,174
    Thank Post
    284
    Thanked 773 Times in 583 Posts
    Rep Power
    335
    Quote Originally Posted by matt40k View Post
    32bit your limited to 3GB really, assuming your MSSQL is config'd to use it all. I would look at 64bit. PM if you (or anyone) wants a SQL defrag script for SIMS.
    Actually you are not, see Enabling AWE Memory for SQL Server

  9. #9

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,174
    Thank Post
    284
    Thanked 773 Times in 583 Posts
    Rep Power
    335
    Quote Originally Posted by teejay View Post
    Actually you are not, see Enabling AWE Memory for SQL Server
    . The problem is that up to now SIMS does not support 64-bit OS's, even on the server, but I beleive this is about to change with the November release.

  10. #10
    D4RREN's Avatar
    Join Date
    Nov 2008
    Location
    Chelmsford
    Posts
    9
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    As of yet Sims is not tested on 64bit platforms.

    But I haven't heard of anyone supporting 64bit from november although if you install Installing ADPS on 64-bit server. this will enable you to use 16bit programs

  11. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,388
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Capita support x64 SIMS from Aug'08, in Nov they will support x64 FMS. Check the roadmap teejay (resource 13512)

    32bit is limited to 4GB hardcoded. You can extend it, but lets face it, it's pretty bug filled. Your also limited to how much you can give to 32bit applications. Again, it's the limits of 32bit.

  12. #12
    D4RREN's Avatar
    Join Date
    Nov 2008
    Location
    Chelmsford
    Posts
    9
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Installing ADPS will still allow you to user 16bit programs on Vista and 64bit platforms

  13. #13

    Join Date
    Dec 2005
    Posts
    524
    Thank Post
    34
    Thanked 87 Times in 77 Posts
    Rep Power
    39
    I'm going to be very vague with this post - as my memory seems to be useless today....

    But from what I can remember the biggest performance increase that would probably help is that SQL Express 2005 has something like a maximum of 8 user connections. Whereas the Enterprise edition should allow you to set the number of connections you require.

    If your old SQL Express 2005 was hitting its connection limit it would queue the requests and cause slow down.

    So vague answer might be to check how to configure for more connections....

    Or it might be nothing to do with that....

  14. #14
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,439
    Thank Post
    10
    Thanked 489 Times in 429 Posts
    Rep Power
    111
    sql express 2005 is only limited one cpu and 1GB RAM and 4GB DB, it doesn't have any other restrictions.

  15. #15

    Join Date
    Dec 2005
    Posts
    524
    Thank Post
    34
    Thanked 87 Times in 77 Posts
    Rep Power
    39
    Doh!

    You are correct.... my memory is very bad!

    Microsoft SQL Server 2005: Compare Features

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Better Performance - why ?
    By mattx in forum Wireless Networks
    Replies: 3
    Last Post: 8th August 2007, 05:25 PM
  2. performance issues with XP
    By tomscaper in forum Windows
    Replies: 15
    Last Post: 24th May 2007, 10:27 PM
  3. Performance
    By webman in forum ICT KS3 SATS Tests
    Replies: 4
    Last Post: 23rd May 2006, 07:53 PM
  4. Server Performance
    By faza in forum Hardware
    Replies: 1
    Last Post: 23rd May 2006, 07:31 AM
  5. Sims Assessment Manager Performance Issues
    By barryfl in forum MIS Systems
    Replies: 4
    Last Post: 14th March 2006, 11:52 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
  •