+ Post New Thread
Page 1 of 5 12345 LastLast
Results 1 to 15 of 65
MIS Systems Thread, Sims Server Performance Benchmarks in Technical; I'm really interested in what other schools performance is like from their Sims server? I find it incredibly slow even ...
  1. #1
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86

    Sims Server Performance Benchmarks

    I'm really interested in what other schools performance is like from their Sims server?

    I find it incredibly slow even with a brand new server just installed by Capita.

    850 student school (SQL 2012, Solus 3, Discover)

    Sims server
    Virtual Hyper-V, 10GB RAM, 4 Cores Xeon "E5-2430L" @ 2.ghz, SSD drive, Gbit NIC

    Sims Benchmarks
    11 Seconds Client Load time
    13 seconds Reports >> Students >> addresses >> Year 7 >> 1 Reg Group
    3+ Seconds Search "Smith" student name in main screen search box
    6 Seconds Solus 3 launch on server Scrolling agents is also really slow

    Sims Database
    Sims.mdf - 3.10 GB
    Sims.ldf - 656 MB
    Simsdiscover_Primary.mdf - 419 MB
    Simsdiscover_Primary.ldf - 894 MB

    I've run the Re-indexing patch but not sure what else to do to improve performance??

  2. #2
    DocHouse's Avatar
    Join Date
    Jul 2011
    Location
    brum
    Posts
    707
    Thank Post
    147
    Thanked 80 Times in 72 Posts
    Rep Power
    47
    Sims Server Brand New HP310LM 16GB Ram 4 Cores Xeon "E5-2450L" @ 2.ghz, SSD drive 3TB, Gbit NIC running Server 2008R2 and SQL 2012 (Freshly installed this week!)

    435 on Role

    Sims Benchmarks
    9 Seconds Client Load time via LAN / 13 Seconds via Wifi
    11 seconds Reports >> Students >> addresses >> Year 6 >> 1 Reg Group
    3.9 Seconds Search "Smith" student name in main screen search box
    5 Seconds Solus 3 launch on server

    Sims Database
    Sims.mdf - 2.10 GB
    Sims.ldf - 456 MB
    Simsdiscover_Primary.mdf - 319 MB
    Simsdiscover_Primary.ldf - 496 MB

  3. Thanks to DocHouse from:

    zag (5th November 2013)

  4. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    1500 student school (SQL 2008 R2, Solus 2)

    Sims server
    VMWare ESX VSphere 4 Advanced, 16GB RAM, 4 Cores Xeon X5460 @ 3.16Ghz , IBM S-chassis with local attached shared storage Gbit NIC

    Sims Benchmarks
    1-2 Seconds to get login prompt i.e. run simsload and check for update.
    15 Seconds Client Load time - used to be quicker and can be sometimes, though i'm low on RAM at the mo. (64bit win 7 client with 8GB)
    15 seconds Reports >> Students >> addresses >> Year 9 >> 1 Reg Group (22 students)
    8 Seconds Search "Muhammad" student name in main screen search box but i probably have more of them than you have Smiths!
    6 Seconds Solus 3 launch on server Scrolling agents is also really slow

    Sims Database
    Sims.mdf - 4.50 GB
    Sims.ldf - 129 MB
    =================================

    It's slower than it has been in the past and it's not being used much at the mo' to be honest.
    However, we're quite happy with it. In fact i think for most users it's much quicker than my benchmarks and they don't normally complain. I blame my RAM usage for it running slow here as i rarely have more than a few MB free.

    You should talk to @bossman his stats will make you cry - he may also be best placed to give advice on tweaking - otherwise look at the many other threads that look at the structure of the server, location of data files, type of RAID being used, and other SQL optimisation techniques.

  5. 2 Thanks to vikpaw:

    bossman (5th November 2013), zag (5th November 2013)

  6. #4

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,631
    Thank Post
    514
    Thanked 2,442 Times in 1,890 Posts
    Blog Entries
    24
    Rep Power
    831
    550 student school (SQL 2008 r2, Solus 3, Discover)

    Sims server
    Virtual Hyper-V, 12GB RAM, 16 Cores Xeon "E5-2690 v1" @ 2.9ghz, SSD RAID array, 10Gbit NIC

    Sims Benchmarks
    6 Seconds Client Load time
    7 seconds Reports >> Students >> addresses >> Year 7 >> 1 Reg Group
    2 Seconds Search "Smith" student name in main screen search box
    5 Seconds Solus 3 launch on server

    Sims Database
    Sims.mdf - 1.7GB
    Sims.ldf - 3.8GB
    discover.mdf - 145 MB
    Simsdiscover_Primary.ldf - 1GB

    Our backups are being problematic at the moment (hence the ldf file sizes).
    Last edited by localzuk; 5th November 2013 at 09:19 AM.

  7. Thanks to localzuk from:

    zag (5th November 2013)

  8. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Just whack it into Simple mode unless you're being fancy with your backups and plan to use the transaction logs.

  9. #6

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,620
    Thank Post
    845
    Thanked 882 Times in 731 Posts
    Blog Entries
    9
    Rep Power
    326
    850 student school (SQL 2008, Solus 2)

    Sims server

    Virtual Hyper-V, Dynamic upto 8GB RAM - Currently 5.6Gb, 4 Cores Opteron "6128" @ 2.ghz, 10Gb VNIC to virtual switch with 2Gb (bonded pair) uplink to core
    SLG, ADPS and Documents are all on seperate servers

    Sims Benchmarks
    32 Seconds Client Load time (on a thin client (4core+HT, 12Gb server), Automatic login, no SIMSLoad)
    12 seconds Reports >> Students >> addresses >> Year 9 >> 1 Reg Group
    15 Seconds Search "Smith" student name in main screen search box
    12 Seconds Solus 2 launch on server

    Sims Database

    1.7Gb according to SQL Manager
    1.2Gb last backup

  10. Thanks to tmcd35 from:

    zag (5th November 2013)

  11. #7

    Join Date
    Oct 2005
    Posts
    824
    Thank Post
    51
    Thanked 111 Times in 101 Posts
    Rep Power
    63
    This is very interesting - with all of the SIMS Schools that I've dealt with they've all been less than impressed with the performance.

    1500-ish student school (Server 2008R2 with SQL 2008R2, Solus3 and Discover)

    Sims server
    Running on VMware vSphere ESXi 5.1, 4 vCPU (Quad Xeon X5650), 16GB RAM, NetApp FAS SAN with SATA drives (!), 1Gbit NIC.

    Our SAN is the achilles heel in this config - although it has lots of spindles the fact that it's based around SATA disks does make it a tad slow at times, but it'll be interesting to see how much of an impact this causes.

    Sims Benchmarks
    8 Seconds Client Load time
    21 seconds Reports >> Students >> addresses >> Year 7 >> 1 Reg Group
    2 Seconds Search "Smith" student name in main screen search box
    40 Seconds Solus 3 launch on server Scrolling agents is also really slow

    Sims.mdf – 6.5 GB
    Simsdiscover_Primary.mdf – 730 MB

  12. #8

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,905
    Thank Post
    1,186
    Thanked 1,057 Times in 749 Posts
    Rep Power
    328
    750 students 120 Sims clients (SQL2008R2 on Windows Server 2008R2, Solus3, Discover, FMS)

    Sims server
    Zenserver VM , 8GB RAM, 4 Cores Xeon "E5440" @ 2.83GHz speed 2826MHz, SAS15k drive, 2 x 1Gbit NIC

    Sims Benchmarks
    1 Second login screen
    8 Seconds Client Load time
    7 seconds Reports >> Students >> addresses >> Year 7 >> 1 Reg Group
    3 Seconds Search "Smith" student name in main screen search box
    7 Seconds Solus 3 launch on server

    Sims Database
    Sims.PDF - 2.69 GB
    discover.PDF - 282 MB
    FMS.PDF - 428 MB
    Solus.PDF - 9.25 MB

    Backups done by SQL Management Studio every night with transaction logs and on Sunday after it has done backups another scheduled task deletes all but the last 3 backups to keep everything nice and tidy.
    Last edited by bossman; 5th November 2013 at 09:40 AM.

  13. #9
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    So basically the slow performance is being experienced by just about everybody?

    Even with the quickest hardware?

  14. #10

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    1,954
    Thank Post
    109
    Thanked 482 Times in 331 Posts
    Blog Entries
    2
    Rep Power
    281
    Quote Originally Posted by zag View Post
    So basically the slow performance is being experienced by just about everybody?

    Even with the quickest hardware?
    Tongue in cheek, but...
    Wirth's law is a computing adage made popular by Niklaus Wirth in 1995. It states that "software is getting slower more rapidly than hardware becomes faster."
    and
    May's law, named after David May, is a variant where: "Software efficiency halves every 18 months, compensating Moore's Law."

  15. #11

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,620
    Thank Post
    845
    Thanked 882 Times in 731 Posts
    Blog Entries
    9
    Rep Power
    326
    Quote Originally Posted by jinnantonnixx View Post
    It states that "software is getting slower more rapidly than hardware becomes faster."
    Carp programming then?

  16. #12
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,424
    Thank Post
    10
    Thanked 488 Times in 428 Posts
    Rep Power
    111
    Of course none of the figures will be any use until you know if it's full SQL or SQL express, express having that terrible 1GB RAM limit for the queries.

  17. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by DMcCoy View Post
    Of course none of the figures will be any use until you know if it's full SQL or SQL express, express having that terrible 1GB RAM limit for the queries.
    I thought everyone gave their version of SQL I'd expect them to have specified if it was express.

    As for slow performance, perhaps that is what they expect. If everyone has similar ish experiences who's to say it is slow. Only slower than expected. Or slower than another system. Be interesting to compare these benchmarks on older versions of software when we probably all also had much slower hardware!

  18. #14

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,905
    Thank Post
    1,186
    Thanked 1,057 Times in 749 Posts
    Rep Power
    328
    Probably because Sims is not a true relational database more a patchwork of tables cobble together and data extracted with rather long SQL code which is possibly why it is slower than most databases of the same ilk.

    I could be wrong but then again I might not be too far off the mark, as Capita add more and more functionality by way of more features it actually makes it slower.

    What do you all think?

  19. Thanks to bossman from:

    zag (11th November 2013)

  20. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    There was a quote at BETT, "It's not first normal; it's not even 'normal'!" or something similar.

SHARE:
+ Post New Thread
Page 1 of 5 12345 LastLast

Similar Threads

  1. VMWARE : Can someone check this servers performance?
    By kennysarmy in forum Thin Client and Virtual Machines
    Replies: 8
    Last Post: 28th November 2012, 04:22 PM
  2. Server performance multiple VM vs 1 native OS
    By SimpleSi in forum Windows Server 2000/2003
    Replies: 3
    Last Post: 6th July 2012, 07:18 PM
  3. Server Performance
    By faza in forum Windows
    Replies: 17
    Last Post: 24th May 2006, 07:00 AM
  4. Server Performance
    By faza in forum Hardware
    Replies: 1
    Last Post: 23rd May 2006, 07:31 AM
  5. server benchmarks
    By browolf in forum Hardware
    Replies: 10
    Last Post: 14th October 2005, 10:03 PM

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
  •