+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 20
MIS Systems Thread, Serco Facility and MS SQL server Express edition in Technical; I've just started at a school as Network Manager and one of the many projects to get stuck into is ...
  1. #1

    Join Date
    Mar 2008
    Location
    Norfolk
    Posts
    227
    Thank Post
    5
    Thanked 10 Times in 8 Posts
    Rep Power
    20

    Serco Facility and MS SQL server Express edition

    I've just started at a school as Network Manager and one of the many projects to get stuck into is an already-in-progress move from Phoenix Gold to Serco's Facility MIS. Serco recommend the standard edition of MS' SQL Server 2005, but i wondered if it would run on the free Express edition as SIMS (the MIS from my previous school) does quite happily.

    The response I got on asking the rep this question was a no and a link to a features comparison page- their technical people apparently reckon the Express editon is 'too limited for Facility when used in a secondary school'. Has anyone out there tried it? Call me cynical, but i'm wondering if i've got the easy answer, rather than the correct one!

    Cheers...

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    8,941
    Thank Post
    232
    Thanked 1,510 Times in 1,206 Posts
    Rep Power
    328
    Although Sims and CMIS probably will run on SQL 2005 Express, Standard edition contains many more features which may be required when performing certain tasks.

    Some LA's like Birmingham provide SQL Server 2005 at much cheaper prices than it would cost retail. Standard Edition from Birmingham is 128 and CALs 16 each.

  3. #3

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,037
    Thank Post
    209
    Thanked 425 Times in 306 Posts
    Rep Power
    143
    I think it might work, but you could run into some problems.

    Firstly, SQL Server 2005 Express can access only a single CPU and 1 GB of RAM, which might be a problem if you're running a lot of users on E-portal as that can be quite heavy on database queries.

    Also the maximum database size on SQL serever 2005 express is 4GB, which you could get to at some point in the future with Sercos product, our's has been running for 3 years now and our database is about 1.4GB now, and is increasing a lot faster in recent times as Serco add features to their products.

    Apart from those limitations, I don't think there's any reason it won't work, but personally I would recommend you get the full edition of SQL server if you can.

    Mike.
    Last edited by maniac; 28th May 2008 at 10:33 PM. Reason: Spelling!

  4. #4
    monkeyx's Avatar
    Join Date
    Nov 2006
    Posts
    364
    Thank Post
    8
    Thanked 52 Times in 41 Posts
    Rep Power
    25
    I run SQL express for the test version of CMIS and have had not had any issues. Although there are never more than several people connected at once. You would need to check on limitations of SQL express if you had many concurrent connections on a live system.

    I did try and install to MySQL once, but I did not work. Neve got a proper answer form Serco, as to if/when they would add support this

  5. #5

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,686
    Thank Post
    824
    Thanked 2,570 Times in 2,187 Posts
    Blog Entries
    9
    Rep Power
    731
    Quote Originally Posted by monkeyx View Post
    I run SQL express for the test version of CMIS and have had not had any issues. Although there are never more than several people connected at once. You would need to check on limitations of SQL express if you had many concurrent connections on a live system.
    There is no connection limit on the SQL 2005 express edition but it does not support some of the advanced features like live database replication and RDA. It is limited to only one CPU though so as long as your site does not have heaps of concurrent connections and the software does not require any of the advanced features.

    It also does not include most of the management tools included in the full product so troubleshooting some problems may require a bit more work as the providers instructions are sure to use these tools. SQL Management Studio Express does add lots of management options so this may be sufficient.

  6. #6

    Join Date
    Mar 2008
    Location
    Norfolk
    Posts
    227
    Thank Post
    5
    Thanked 10 Times in 8 Posts
    Rep Power
    20
    Hmmm... Not sure i'm feeling brave enough to risk it, so I think i'll play it safe! As i'm new to the school I'm not sure how staff will react and don't want to be stuck with poor performance if they all jump on board straight away. Plus, the new server we've got coming to run it on is fairly decent spec; shame not to use all the cores...

    Thanks guys.

  7. #7

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,686
    Thank Post
    824
    Thanked 2,570 Times in 2,187 Posts
    Blog Entries
    9
    Rep Power
    731
    Just had another look and it seems it is liscenced per CPU so one CPU could be four cores if you have quad core cpus in your server.

    Still standard is probably the best call, I had a look at the feature matrix and SQL express only uses up to 1 gig of ram and has a 4gb database size. Standard uses up to 4 cpus and as much ram as you have, Enterprise has no limit on core usage or memory

  8. #8

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    585
    Thank Post
    83
    Thanked 112 Times in 91 Posts
    Rep Power
    57
    Hi,

    I was the technical engineer at Serco who responded to your query through your implementation manager.
    Something else to bare in mind is the bulk of our testing, to know knowledge is performed on SQL 2005 SP2. If you had express and ran into an issue which appeared to be SQL related, and we couldn't replicate it, it's another difference at your site which could only be tested by purchasing the full version. So to avoid this scenario, it would be worth buying the standard edition. SQL will also use more than 1gb of RAM if your server is high enough spec'd (especially during times of high throughput such as assessment periods).

    Michael Sanderson
    Technical Engineer
    Serco Learning



    N.B: The content in the above post contains views which belong to myself and do not reflect those of my employer.

  9. #9

    mattx's Avatar
    Join Date
    Jan 2007
    Posts
    9,229
    Thank Post
    1,056
    Thanked 1,066 Times in 623 Posts
    Rep Power
    739
    Quote Originally Posted by cheredenine View Post
    I've just started at a school as Network Manager and one of the many projects to get stuck into is an already-in-progress move from Phoenix Gold to Serco's Facility MIS. Serco recommend the standard edition of MS' SQL Server 2005, but i wondered if it would run on the free Express edition as SIMS (the MIS from my previous school) does quite happily.

    The response I got on asking the rep this question was a no and a link to a features comparison page- their technical people apparently reckon the Express editon is 'too limited for Facility when used in a secondary school'. Has anyone out there tried it? Call me cynical, but i'm wondering if i've got the easy answer, rather than the correct one!

    Cheers...
    We have Facility MIS running VERY happily on SQL Server 2000 - I find it very hard to believe that it now requires SQL Server 2005.....Unless something quite dramatic has developed within the product.....

  10. #10
    nicholab's Avatar
    Join Date
    Nov 2006
    Location
    Birmingham
    Posts
    1,411
    Thank Post
    3
    Thanked 93 Times in 89 Posts
    Blog Entries
    1
    Rep Power
    50
    The reason for it the upgrade is that it is going to be an unsupported product. I bet you not still running windows 98. This is the core business platform of the school is it needs to be supported!!!

  11. #11

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    8,941
    Thank Post
    232
    Thanked 1,510 Times in 1,206 Posts
    Rep Power
    328
    SQL 2000 is now out of mainstream support!

    Sims.NET for example also requires SQL 2005 since March '08 and later, so no longer works on SQL 2000.

  12. #12

    Join Date
    May 2008
    Location
    Kent
    Posts
    490
    Thank Post
    24
    Thanked 71 Times in 62 Posts
    Rep Power
    25
    Quote Originally Posted by nicholab View Post
    The reason for it the upgrade is that it is going to be an unsupported product. I bet you not still running windows 98. This is the core business platform of the school is it needs to be supported!!!
    I believe that sql 2000 is still widely used in industry. Yes mainstream support has ended but then so will XP's long before people stop using it.

  13. #13

    Join Date
    Mar 2008
    Location
    Norfolk
    Posts
    227
    Thank Post
    5
    Thanked 10 Times in 8 Posts
    Rep Power
    20
    Thanks for your reply. I think we'll go down the 'Standard edition' route as you suggest - i was hoping i could save a few quid with the free version, but it seems its not to be! Given the spec of the new server we have coming, it'd be a shame to have Facility limited because our database software can only address 1gb of memory...

    Quote Originally Posted by michael2k6 View Post
    Hi,

    I was the technical engineer at Serco who responded to your query through your implementation manager.
    Something else to bare in mind is the bulk of our testing, to know knowledge is performed on SQL 2005 SP2. If you had express and ran into an issue which appeared to be SQL related, and we couldn't replicate it, it's another difference at your site which could only be tested by purchasing the full version. So to avoid this scenario, it would be worth buying the standard edition. SQL will also use more than 1gb of RAM if your server is high enough spec'd (especially during times of high throughput such as assessment periods).

    Michael Sanderson
    Technical Engineer
    Serco Learning



    N.B: The content in the above post contains views which belong to myself and do not reflect those of my employer.

  14. #14
    Alis_Klar's Avatar
    Join Date
    Oct 2007
    Location
    East Birmingham
    Posts
    265
    Thank Post
    130
    Thanked 18 Times in 8 Posts
    Rep Power
    17

    Per CPU licencing

    Birmingham's price for the CAL-less operation (Per CPU SQL Licenceing) is 750. We went for this because otherwise you have to buy a CAL for every e-Portal user! According to Link2ICT you have to have a SQL CAL for every user who will have write access to the database. So it worked out cheaper.

    Only issue was when we wanted to buy the new Server hardware in November HP were doing a free CPU offer on DL380's

  15. #15

    Join Date
    Mar 2008
    Location
    Norfolk
    Posts
    227
    Thank Post
    5
    Thanked 10 Times in 8 Posts
    Rep Power
    20
    I was given to understand that a CAL was required for any user that used Facility Admin, but only one CAL was required for ePortal as it was the webserver querying the database, and not the ePorter users. This made sense to me as the CAL should cover a 'user' (a person or software agent) accessing the data, what then happens to the data is outside the remit of the CAL...

    Quote Originally Posted by Alis_Klar View Post
    Birmingham's price for the CAL-less operation (Per CPU SQL Licenceing) is 750. We went for this because otherwise you have to buy a CAL for every e-Portal user! According to Link2ICT you have to have a SQL CAL for every user who will have write access to the database. So it worked out cheaper.

    Only issue was when we wanted to buy the new Server hardware in November HP were doing a free CPU offer on DL380's

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

Similar Threads

  1. [ACS] Serco's Facility
    By ANiceEnglishman in forum MIS Systems
    Replies: 49
    Last Post: 3rd April 2011, 01:42 PM
  2. Serco Facility administration crating an MSI
    By nicholab in forum MIS Systems
    Replies: 3
    Last Post: 24th November 2007, 11:52 AM
  3. SIMS.Net vs Serco Facility
    By JoHimself in forum MIS Systems
    Replies: 17
    Last Post: 18th October 2007, 09:44 AM
  4. Serco CMIS Facility
    By bursar in forum MIS Systems
    Replies: 11
    Last Post: 22nd May 2007, 04:36 PM
  5. Serco's Facility Attendance
    By danIT in forum MIS Systems
    Replies: 0
    Last Post: 7th September 2006, 01:23 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
  •