+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Things to check when Facility CMIS is slow in Technical; Hi Have a few of our admin staff complaining that Facility is slow. Its mainly just using it to generate ...
  1. #1
    ranj's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    730
    Thank Post
    98
    Thanked 42 Times in 32 Posts
    Rep Power
    25

    Things to check when Facility CMIS is slow

    Hi

    Have a few of our admin staff complaining that Facility is slow. Its mainly just using it to generate reports and other general use, navigating through different menu's.

    The machines they are using are some of the fastest in school all connected through Gigabit LAN. The machines specs are:

    Intel core 2 duo E6400, 2gb ram.

    This spec should be more than enough to handle this.

    The backend server is in an ESX 4 Cluster on a 32bit 2003 server with 4gb RAM and dual core processor.

    Any adjustments I could make to improve performance. The server was originally a physical server and when we moved it into the ESX cluster it was a simple P2V migration. This was done about 6 months ago. The original server was a dual core with 2GB ram and when it was virtualised the memory was increased to 4gb and this has made a difference but just having a few isolated problems with heavy CMIS users which I am not able to sort.

    Any advice would be great. I doubt if this problem is server side. The server is located a good 150m away but from the server room there is a fibre link to the nearest cab where the offices are located and in there we have a 1gb link to desktop.

  2. #2

    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
    More ram, 6 or 8 GB is what it really needs now I think, I am just going to replace my server this new financial year, I will be getting Dual CPUs (they will be Quad core most like) and 8GB ram as a minimum, and I know Serco will much that up quite happily.

    How have you got it setup, are all 3 (Facility, SQL and Eportal) all on the same box? Are you using Behaviour Management as that does seem to gobble up the systems very nicely.

  3. #3
    ranj's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    730
    Thank Post
    98
    Thanked 42 Times in 32 Posts
    Rep Power
    25
    Hi

    As its a 32bit Server OS, I am assuming if I can increase the memory it won't make the much difference will it?

    As the maximum it will use is 4gb.

    If I wrong please let me know

  4. #4
    Diello's Avatar
    Join Date
    Jun 2005
    Location
    Kent, England
    Posts
    1,063
    Thank Post
    112
    Thanked 228 Times in 128 Posts
    Rep Power
    74
    True - should consider moving it to 64bit at some point.

    We used to find clearing the audit trail helped, also consider shrinking the DB if it's got a lot of free space.

  5. #5
    ranj's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    730
    Thank Post
    98
    Thanked 42 Times in 32 Posts
    Rep Power
    25
    Quote Originally Posted by Diello View Post

    We used to find clearing the audit trail helped, also consider shrinking the DB if it's got a lot of free space.
    I like the sound of that. I reckon that could do the trick. Are you able to direct where I need to go to make this change and does it involve all users to be logged out before I do this, I assume it will.

    Thanks

  6. #6
    SkywOrca's Avatar
    Join Date
    Sep 2008
    Posts
    88
    Thank Post
    1
    Thanked 18 Times in 17 Posts
    Rep Power
    48
    Ranj, if you contact the Link2ICT Service Desk we can provide you with a script that can automate the clearing down of your audit trail, limiting the table to just the last month's worth of entries. This should keep the size of your audit trail table to somewhere in the hundreds of thousands (yes, even just in one month you can get that many) rows. It backs up the contents of the table to an archive database in the event that you need the contents of the table for auditing purposes, or to identify issues with your database.

    And yes, you will need to run this script out of hours, not specifically due to problems with users in the database, but mainly because the script causes a big performance hit whilst it runs. We recommend that you set it up as a scheduled task to run overnight when the system is otherwise quiet.

  7. Thanks to SkywOrca from:

    ranj (4th February 2010)

  8. #7

    Join Date
    Sep 2006
    Posts
    4
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    8GB RAM for Facility CMIS Server

    Ranj, If you want to use more than 4GB RAM, you will need to have Windows 2003 Enterprise 32-bit Edition. Windows 2003 Standard 64-bit edition will use more than 4GB RAM but secure ePortal may not work correctly (I think it is to do with ISAPI filters).

  9. #8

    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
    Serco do have a 64 bit ISAPI avaliable for Eportal I think if I remember correctly its a seperate download from Maxportal But I could be wrong

  10. #9

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    629
    Thank Post
    96
    Thanked 132 Times in 103 Posts
    Rep Power
    67
    Hi there,

    There's a post here about memory limits on 32bit systems:
    Memory Limits for Windows Releases (Windows)

    John do you want a job? You're starting to scare me now... what he said. Though i'm not sure whether it's available generally enough to be on firstline but if you call support and ask them for the 64bit ISAPIs theyll gladly send you it and the relevant document.

    Just to clear up the thing about security -
    It will still work over apache on port 8080 (default) or if you know what you're doing or do some googling, you can use ssl on apache (defaults to 8443). The affect 64bit has is it uses different ISAPI's and they are depended upon by IIS. So esentially IIS isnt going to work - secure (ssl/https/port443) or other wise (http/port80). But as i said those new filters sort that out

    In terms of the original post -
    Search the website for eportal performance - although it's not eportal performance issues you're experiencing, the first thing i'd be looking at is how busy the server is when you're running these reports etc. Following the performance document will help reduce the overhead on the server and should have a positive knock on effect.

    Maybe also look at things such as... if you try it on the server is it also slow there?
    If you do it out of hours, is it quicker, or just as slow? Is it only slow on some work stations (regardless of spec)?

    Also, as a little aside, what antivirus do you have on the server? I've come across more and more of them now actually scanning the db and the log unless you tell it otherwise. And more and more are scanning all network traffic including http and https.

    Regards
    Mic@Serco

SHARE:
+ Post New Thread

Similar Threads

  1. CMIS Facility Pricing
    By danIT in forum MIS Systems
    Replies: 3
    Last Post: 2nd September 2009, 07:46 PM
  2. Facility CMIS Licensing
    By pauljonze in forum MIS Systems
    Replies: 1
    Last Post: 9th July 2009, 08:04 PM
  3. MRBS and Facility CMIS
    By NotSoFast in forum Network and Classroom Management
    Replies: 6
    Last Post: 24th January 2008, 10:41 AM
  4. Facility CMIS on Citrix
    By CyberNerd in forum Thin Client and Virtual Machines
    Replies: 6
    Last Post: 19th July 2007, 03:25 PM
  5. Facility CMIS 2.8 build 34
    By CheeseDog in forum MIS Systems
    Replies: 58
    Last Post: 14th February 2007, 12:25 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
  •