+ Post New Thread
Page 3 of 4 FirstFirst 1234 LastLast
Results 31 to 45 of 55
MIS Systems Thread, SIMS SQL 2005 in Technical; I have just received a quote from Ramesys for SQL 2005 licenses. -SQL 2005 Standard - £105 -Media - £6.50 ...
  1. #31
    thom's Avatar
    Join Date
    Jul 2005
    Location
    Bedford, East Anglia, UK
    Posts
    242
    Thank Post
    4
    Thanked 6 Times in 5 Posts
    Rep Power
    20

    Re: SIMS SQL 2005

    I have just received a quote from Ramesys for SQL 2005 licenses.
    -SQL 2005 Standard - £105
    -Media - £6.50
    --Per CAL (per device not connection) £13.50
    --Per CPU (we have 2) £789
    We have Sims.net on about 150 PCs/Laptops so we can pay a total of £2136.50 per device or £1689.50 per CPU

    This seems a lot of money
    a) for a school
    b) as we already use SQL 2000 std

    Is there a cheaper option (I am contemplating taking out a CPU!)

  2. #32

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,942
    Thank Post
    1,199
    Thanked 1,069 Times in 760 Posts
    Rep Power
    330

    Re: SIMS SQL 2005

    Only SQL express (free) but you would still have to purchase cals.

  3. #33

    Join Date
    Jun 2007
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: SIMS SQL 2005

    Hi

    You could use Workgroup Edition instead of Standard.
    Per CPU it is about £460 , Will only use up to two physical processors and 3gb Ram, but would have thought most servers will only have 2 cpus in them anyway. Works out a fair bit cheaper than Standard.

    Andrew

  4. #34


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    Re: SIMS SQL 2005

    Is there a cheaper option
    CMIS ?

  5. #35

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,362
    Thank Post
    1,499
    Thanked 1,053 Times in 922 Posts
    Rep Power
    303

    Re: SIMS SQL 2005

    Quote Originally Posted by CyberNerd
    Is there a cheaper option
    CMIS ?
    I don't see why that is a cheaper option, we will be moving over to SQL 2005 shortly I would suspect.

  6. #36
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,488
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76

    Re: SIMS SQL 2005

    Quote Originally Posted by CyberNerd
    Is there a cheaper option
    CMIS ?
    The personnel costs in moving MIS - i.e. time taken for data migration and staff re-training - would be huge.

  7. #37


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    Re: SIMS SQL 2005

    Quote Originally Posted by NickJones
    Quote Originally Posted by CyberNerd
    Is there a cheaper option
    CMIS ?
    The personnel costs in moving MIS - i.e. time taken for data migration and staff re-training - would be huge.
    yeah - we've gone from SIMS > CMIS > SIMS in 3 yrs and the financial and personnel cost far exceeds a simple SQL upgrade ( a single 2005 processor license was £750 from dabs IIRC) . Good job school management isn't accountable to anybody.

  8. #38
    monkeyx's Avatar
    Join Date
    Nov 2006
    Posts
    364
    Thank Post
    8
    Thanked 52 Times in 41 Posts
    Rep Power
    25

    Re: SIMS SQL 2005

    The personnel costs in moving MIS - i.e. time taken for data migration and staff re-training - would be huge.
    Well our school had SIMS, Bromcom and a third party reporting package. The training costs and admin costs for all 3 were huge!

    Also Serco move the data for you, so on what basis are your HUGE costs coming from. Have you personally gone through a migration process?

    Under CMIS(Facility/Eportal) the overal admin costs are the same(slightly lower), but the training and support costs are MUCH lower as only 1 product to support and train staff on. Staff using eportal hardly need any training either, which has been a BIG help!

  9. #39
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,488
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76

    Re: SIMS SQL 2005

    Quote Originally Posted by monkeyx
    Also Serco move the data for you
    How does that fit with the Ts&Cs of your Capita contract which state, IIRC, that you won't share your database outside of your school and Capita?

    Quote Originally Posted by monkeyx
    Under CMIS(Facility/Eportal) the overal admin costs are the same(slightly lower), but the training and support costs are MUCH lower as only 1 product to support and train staff on.
    What about the initial training costs? Our users know how to use SIMS so don't require much training, but everyone would need re-training if we were to move.

  10. #40
    nicholab's Avatar
    Join Date
    Nov 2006
    Location
    Birmingham
    Posts
    1,507
    Thank Post
    4
    Thanked 98 Times in 94 Posts
    Blog Entries
    1
    Rep Power
    52

    Re: SIMS SQL 2005

    It looks like VMware is going to be usefully in migrating your server. You can copy the whole machine then play with the upgrade. Is every body getting new servers for SIMS. We are going to be upgrading in autumn half term as RM have to install the new server.

  11. #41
    User3204's Avatar
    Join Date
    Aug 2006
    Location
    Wirral
    Posts
    769
    Thank Post
    55
    Thanked 66 Times in 62 Posts
    Rep Power
    34

    Re: SIMS SQL 2005

    @thom

    That looks like the same as we've paid for our licenses.


    @nicholab
    We definitely have gotten a new server for the new SIMS, with lots of RAM (8gb), as the old one was always running nearly at capacity.
    It also means we have had to change to "enterprise" windows 2003, as "standard" wouldn't recognise more than 4gb of RAM.




    Now, I just have to work out if it will be easier to:
    a) upgrade the old server, then transfer to the new server;
    b) transfer to the new server, then upgrade to the new SQL;

    My preference is b) as this means we still have a working server, if it all goes wrong. But my boss wants to do a) 'cause he thinks this will work "better"... I keep askng him to define better !

  12. #42
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,043
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52

    Re: SIMS SQL 2005

    @User3204

    I'm going with c) Copy off all SIMS to a Virtual PC, do the upgrade on the virtual PC, then transfer to new server.

    I'll have a server to go back to if it all goes pear shaped and won't have to uninstall MSDE off the new server, keeping it as shiny and new as possible.

    Just been playing with our new sims server: HP DL380 G5, 2x quad xeon 2.33ghz, 12Gb RAM, 2 xRAID1 36Gb 15K HDDs, 2x RAID1 72Gb 15K HDD on 2 SAS P400 controllers.

    Its a bit nice :-)

  13. #43
    User3204's Avatar
    Join Date
    Aug 2006
    Location
    Wirral
    Posts
    769
    Thank Post
    55
    Thanked 66 Times in 62 Posts
    Rep Power
    34

    Re: SIMS SQL 2005

    Yeah, trouble is, I don't have a spare server to install any Virtual PC or VMWare onto.

    I'm also, not currently in charge of SIMS, so if/when it all goes wrong, it's not my fault, and I get little say in the install order.


    I really should get a spare server for VM / Virtualisations.


    I think our new SIMS server is a HP G5 ML350 (no racking in this server room), with 2* 140gb SAS mirrored drives, partitioned into 3, for windows, SIMS, and stuff. And thinking about it, it might even be a stupid amount of RAM, I only know it was more than 4gb when Windows 2003 standard advised it wasn't going to use the stuff above this.

    I'm sure I spoke to some supplier who told me they'd managed to cluster SIMS onto multiple machines.. on the understanding from Capita thatit wasn't supported, I reckon I'd like to do this too, specially the slowdown we get in february/march time for FMS.

  14. #44
    nicholab's Avatar
    Join Date
    Nov 2006
    Location
    Birmingham
    Posts
    1,507
    Thank Post
    4
    Thanked 98 Times in 94 Posts
    Blog Entries
    1
    Rep Power
    52

    Re: SIMS SQL 2005

    Our server will be limited to 4GB of RAM as that all RM support. I have suggested getting a HP or dell. It's a massive upgrade in hardware for us as we currently running on a 1GHz with one 1GB of RAM. What RAID are you using on your SIMS server? I have heard that for absolutely stoking database performance raid 5 sucks.

    I just realized that for the new update you can not do the old style update deconnect then reconnect the database. You got to upgrade the database.

  15. #45

    Join Date
    Apr 2007
    Location
    Sutton Coldfield
    Posts
    207
    Thank Post
    29
    Thanked 34 Times in 28 Posts
    Rep Power
    21

    Re: SIMS SQL 2005

    Hello,

    On our database server we run RAID 10, so we can get the performance advantages of RAID 0 (data split across multiple drives) but with RAID 1 protection as well (redundantly mirrored). RAID 5 isn't too bad, but with the cost of the server (Dell PowerEdge 2900) getting an extra disk wasn't going to add much more to the price. Also just to add a bit more performance we have 2 HDDs on RAID 1 Drives with the OS and SQL Installed, and the data files on the RAID 10 array and also used 15K RPM HDDs. Get plenty of RAM as well (we have 16GB with more for more), 1GB is far too little, but you need the full version of SQL Server to take advantage (IIRC 2005 Express only uses 1GB). Also just for a little more performance set the NTFS File Block Size as high as possible on the SQL Data Partition, as your database will be many MB's setting it higher will equal less reads and faster access.

    I personnelly would buy a server from RM, you can get a far better specced server for a lower price and Dell Support I have found is excellent.

    Rob

SHARE:
+ Post New Thread
Page 3 of 4 FirstFirst 1234 LastLast

Similar Threads

  1. Problems installing SQL 2005 for SIMS
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 7th November 2007, 10:27 AM
  2. SIMS on MSSQL 2005
    By AlexB in forum MIS Systems
    Replies: 9
    Last Post: 7th November 2007, 09:20 AM
  3. Upgrading SIMS to SQL 2005
    By AnnDroyd in forum MIS Systems
    Replies: 13
    Last Post: 9th October 2007, 03:02 PM
  4. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 04:50 PM
  5. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 10:20 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
  •