+ Post New Thread
Page 3 of 5 FirstFirst 12345 LastLast
Results 31 to 45 of 64
MIS Systems Thread, SQL2008 VERY SLOW FOR ALL USERS in Technical; Originally Posted by glennda I was trying not to start the KVM vs ESX argument!! Er... I'm supporting your opinion....
  1. #31

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,867
    Thank Post
    412
    Thanked 778 Times in 651 Posts
    Rep Power
    182
    Quote Originally Posted by glennda View Post
    I was trying not to start the KVM vs ESX argument!!
    Er... I'm supporting your opinion.

  2. #32

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    351
    Quote Originally Posted by powdarrmonkey View Post
    Er... I'm supporting your opinion.
    I know - but i meant with people with esx!

  3. #33

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,260
    Thank Post
    289
    Thanked 796 Times in 605 Posts
    Rep Power
    348
    As long as they are set up properly and have supported hardware, you'll get absolutely naff all difference in performance these days between KVM, VMWare, Xen etc, purely because all the work is done by the processor virtualisation extensions. You do get variations down to other hardware components, such as NICS, SANs etc, but that happens just as much with all of them and I have seen VMWare knock spots off KVM on some hardware and vice versa.

  4. #34
    Darylrese's Avatar
    Join Date
    Sep 2010
    Posts
    445
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    Here is a screen shot:


  5. #35
    Darylrese's Avatar
    Join Date
    Sep 2010
    Posts
    445
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    Strange isn't it. I sat with admin staff last night after applying the patch reccomended by Capita, rebooted the server and tried a report again and still just as slow.

    We only have 4GB of RAM, this isn't a problem i assume? Others i have spoken to say we should have atleast 6 - 10.

  6. #36
    Darylrese's Avatar
    Join Date
    Sep 2010
    Posts
    445
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    "Your current compatibility level is 100."

    No problem mate we are too. It's a nightmare. Even TASC / Capita and the local authorities are out of ideas.

  7. #37
    Darylrese's Avatar
    Join Date
    Sep 2010
    Posts
    445
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    I know the video quality is very poor but it gives you an idea of whats happening (if you change it to 480p or 720p its much clearer):
    Last edited by Darylrese; 5th October 2010 at 02:29 PM.

  8. #38

    Join Date
    Oct 2010
    Location
    Biggleswade
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by DarrenShan View Post
    jinnantonnix, I've ran the Activity Monitor and it is showing the following:

    Processor: 98%
    Waiting Tasks: 5 (max 22)
    Database I/O: 0.1 MB/sec (max 2.0)
    Batch Req: 5 (Max30)

    Looking at the processes it shows me the processes but how can I tell which one(s) are hammering it?

    BTW Thanks to everyone's swift replies
    I am IT Manager in a school and we are getting exactly the same issue following upgrade to SQL 2008 in the summer. Do you know if your teachers use the Home Page for Achievement and Behaviour? Also are you a member of a consortium sharing data within SIMS?

  9. #39

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    351
    How much of your database is sitting in the ram? We had the same problems and have now migrated to a x64 server with 10gb ram and then the entire database is sitting in the ram and it works fine now

  10. #40

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    351
    I know throwing 10gb at it isnt the problem - Our support team have been through everything they can to see why it what was causing the issue - they said that for the spec of server we had (quad-core 4gb ram server2k3 vm) our database was to big at 6gb (which personally i didn't believe) but this issue only came around after we started using the extra sims behaviour modules. All i was saying was that we have migrated to Server 2008 R2 x64 with 10gb of ram and the database is now running fine (completely sitting in the ram) - one thing we do not have is all the old instances installed plus the extra things that our support team have used in the past and not uninstalled. I will be arranging for our Biostore Database to be transferred to this server along with groupcall exporter. If this then causes a mass slow down again I know where to point the finger. Also our Sims Learning Gateway has not be resetup yet (waiting for LEA team to sort). again if this cause's slowdown I will ask the LEA why there SLG is causing a major slowdown of our systems.

  11. #41

    Join Date
    Oct 2010
    Location
    Biggleswade
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Our slow sims coincides with a number of things other than the sql upgrade. Capita's partnership exchange server is now working properly and we have shown staff how to set up their home page to show behaviour and achievement. Our server is quad-core 4gb ram server 2k3 and our database is just under 4gb. It shouldn't have any problems. We think we have eliminated the partnership exchange as the culprit and I now have to get staff to remove the behaviour and achievement from their front page. It may well be what is causing the problem. We have done all the re-indexing, looked at hardware, changed the pagefile, optimised performance etc, but our admin staff are tearing their hair out.

  12. #42
    Darylrese's Avatar
    Join Date
    Sep 2010
    Posts
    445
    Thank Post
    10
    Thanked 7 Times in 6 Posts
    Rep Power
    10
    we had all the IT bods from the council in today and none of them can work it out! We are now looking at reinstalling SQL2008, Moving to a different server entirely (hopefully not!) or getting a conference call with capita and tasc to ask them.

    Its all still so slow you can't use it.

  13. #43
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    What RAID level are you using on the storage for your SIMS server VM? I found Raid 5 / 6 slow on the SIMS server VM as these raid levels give a high write speed penalty. I've been experimenting and have now moved to Raid 10 and the whole server is mutch faster. Am now moving to Tripple Mirrored Raid 10 for ultimate speed:



    "RAID-Triple Mirror by high-speed RAID engine is adopted. This technology has high speed of RAID-1 and high reliability of RAID-6 at the same time. The business can continue even when double failure occurs to the HDDs of the same RAID. This technology is useful especially for Database and OLTP which require high performance and availability."

    I'll let you guys know how it goes!

    Butuz

  14. #44

    Join Date
    Oct 2010
    Location
    Biggleswade
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I stopped a service that we have which shares data with other members of our consortium and SIMS was ok. As soon as I re-started it, hey presto, right back to square one. I now know what is causing it, but not how to cure it. I will pass it on to Capita.

    Do you have anything like that, that might be the cause of your problems?

  15. #45

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    351
    Quote Originally Posted by Chris01 View Post
    I stopped a service that we have which shares data with other members of our consortium and SIMS was ok. As soon as I re-started it, hey presto, right back to square one. I now know what is causing it, but not how to cure it. I will pass it on to Capita.

    Do you have anything like that, that might be the cause of your problems?

    Could you let us know the name - if not in public via PM would be great. We have not transferred all the old software to the new box yet - especially a product which does what you mention above.


    On another note we have had our Sims Learning Gateway installed today so I will post back tomorrow or wednesday to say if this has affected it.
    Last edited by glennda; 12th October 2010 at 12:03 AM.



SHARE:
+ Post New Thread
Page 3 of 5 FirstFirst 12345 LastLast

Similar Threads

  1. SQL2008 Express Reboot Rule Fails
    By Rawns in forum Windows
    Replies: 0
    Last Post: 11th August 2010, 12:33 PM
  2. SIMS - SQL2005 > SQL2008 Migration Problem
    By RobFuller in forum MIS Systems
    Replies: 26
    Last Post: 24th March 2010, 11:39 PM
  3. sims slow to save data for some users
    By maark in forum MIS Systems
    Replies: 12
    Last Post: 2nd February 2010, 09:59 AM
  4. Help Please june Update + sql2008
    By woodham in forum MIS Systems
    Replies: 7
    Last Post: 6th July 2009, 04:26 PM
  5. Moodle - Slow when more than a few users are logged in
    By wesleyw in forum Virtual Learning Platforms
    Replies: 18
    Last Post: 21st September 2007, 03:34 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
  •