+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
Windows Server 2008 R2 Thread, SIMS Server sort slowed down to a crawl in Technical; Got an issue with our SIMS Server; got reports of our AIM High reporting system running really slowly today, and ...
  1. #1

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    889
    Thank Post
    282
    Thanked 139 Times in 112 Posts
    Blog Entries
    27
    Rep Power
    42

    SIMS Server sort slowed down to a crawl

    Got an issue with our SIMS Server; got reports of our AIM High reporting system running really slowly today, and it was. I looked at the CPU Useage, and although a little 'spikey' this morning on the CPU, everything else seemed quite normal. So, I've restarted the firebirdsql service that this uses and that seems to have got things running again.

    SIMS itself seems to be running ok; I can look up classes, pupils with no noticeable loss in speed (although seemed longer to start SIMS that normal) and I've not had complaints with regard to SIMS.

    But, things don't seem right with the server. It's a Virtual Server running on XenServer and has been chugging away quite happily for a while now. I noticed that the nightly backup of the server seemed to take an age, a lot longer than normal. I tried emptying out a few backup directories, and this seem to take a long time as well. It feels sluggish on the remote desktop connection.

    I'm planning on doing a server restart, but thought I'd do a quick and dirty backup with dbattach before doing a restart, however, this seems to be taking an absolute age. It's created the .bak file for the SIMS, but is stuck on Not Responding (for the last 30 minutes now).

    The XenServer is not reporting any problems, and two other VM on this host are running quite happily, I've been moving around a few large files on these with no issues.. No lights are on the server itself to indicate a disk problem.

    Any ideas? Tad worried to say the least.

    Pete

  2. #2

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,174
    Thank Post
    431
    Thanked 317 Times in 268 Posts
    Rep Power
    153
    what size are your mdf and ldf files?

  3. #3

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    889
    Thank Post
    282
    Thanked 139 Times in 112 Posts
    Blog Entries
    27
    Rep Power
    42
    Quote Originally Posted by fiza View Post
    what size are your mdf and ldf files?
    SIMS.ldf is at 9,027,840KB !!!!!!

    SIMS.mid is at 5,761,344 !

    Pete

  4. #4

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    889
    Thank Post
    282
    Thanked 139 Times in 112 Posts
    Blog Entries
    27
    Rep Power
    42
    Ok - Backup of the SIMS database completed, but took about an hour to complete. Pulled across the .bak to another server and that came off at a speed that I would expect.
    Just started to pull across the DOCSERVER backup folder to another server and the speed of this is right down (ie. 459 KB/second) !! WTF?
    Just going to initiate a backup of FMS, Discover and Solus database files and get them off the server!

    Pete

  5. #5

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,174
    Thank Post
    431
    Thanked 317 Times in 268 Posts
    Rep Power
    153
    Our LDF is 13,632 KB
    Our MDF is 3,786,240 KB

    You may want to run the patch that reduces the size of your LDF. It may be affecting performance.

  6. #6

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    889
    Thank Post
    282
    Thanked 139 Times in 112 Posts
    Blog Entries
    27
    Rep Power
    42
    Quote Originally Posted by fiza View Post
    Our LDF is 13,632 KB
    Our MDF is 3,786,240 KB

    You may want to run the patch that reduces the size of your LDF. It may be affecting performance.
    Got any details? I know I've run a utility before that reduces these sizes, but was a long time ago.

    I'm going to do a restart of the Server after hours today, something ain't right.

    Pete

  7. #7

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,174
    Thank Post
    431
    Thanked 317 Times in 268 Posts
    Rep Power
    153
    Check if your DB is in simple recovery mode or not. I think it should be in simple to reduce size of the LDF.

  8. #8

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,174
    Thank Post
    431
    Thanked 317 Times in 268 Posts
    Rep Power
    153

  9. Thanks to fiza from:

    FragglePete (26th November 2013)

  10. #9

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    889
    Thank Post
    282
    Thanked 139 Times in 112 Posts
    Blog Entries
    27
    Rep Power
    42
    Thanks - I'll look at that; looking at SQL Server Management Studio (which took an age to load), the recovery model is set to Full. So, just set that to Simple ?

    I'm going to try and get a restart done first.

    Pete

  11. #10

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,174
    Thank Post
    431
    Thanked 317 Times in 268 Posts
    Rep Power
    153
    Quote Originally Posted by FragglePete View Post
    Thanks - I'll look at that; looking at SQL Server Management Studio (which took an age to load), the recovery model is set to Full. So, just set that to Simple ?

    I'm going to try and get a restart done first.

    Pete
    Yes set it to simple

  12. #11
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    Patch 14265 is the SIMS Reindex patch. It will shrink the LDF and reindex the database tables.

  13. Thanks to Rawns from:

    FragglePete (26th November 2013)

  14. #12

    Join Date
    Dec 2007
    Posts
    872
    Thank Post
    90
    Thanked 165 Times in 140 Posts
    Rep Power
    49
    Quote Originally Posted by FragglePete View Post
    Thanks - I'll look at that; looking at SQL Server Management Studio (which took an age to load), the recovery model is set to Full. So, just set that to Simple ?

    I'm going to try and get a restart done first.

    Pete
    I did similar thing earlier in the week to attempt to make SIMS run better...

    Changed to Simple Mode
    Applied 14265 Re-Index Patch
    And changed the "Maximum Server Memory" within SQL Server Management Studio from the default maximum (of 2147483647 MB!) to something more suitable (to ~80% of installed RAM)

  15. #13

    Join Date
    Dec 2008
    Location
    Nottingham
    Posts
    575
    Thank Post
    38
    Thanked 115 Times in 105 Posts
    Rep Power
    46
    Check resource monitor/performance monitor on the machine generally, sounds like it may be a high disk load type issue - if not that VM maybe another one is hogging data usage, worth checking in Xencenter

  16. #14

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    889
    Thank Post
    282
    Thanked 139 Times in 112 Posts
    Blog Entries
    27
    Rep Power
    42
    Quote Originally Posted by Willott View Post
    Check resource monitor/performance monitor on the machine generally, sounds like it may be a high disk load type issue - if not that VM maybe another one is hogging data usage, worth checking in Xencenter
    The other VM's are not taking anything excessive in terms of resources and all seem to be working ok. I've managed to do server restart and that went through ok and all seems ok straight after.

    I'm letting the daily backup run and remote in later to see how it's getting on, if all OK then I'll let a few Server Updates go down that are waiting and look to shrink things down myself.

    Find out tomorrow.

    Pete

  17. #15
    Zourous's Avatar
    Join Date
    Mar 2007
    Location
    East Sussex
    Posts
    345
    Thank Post
    96
    Thanked 118 Times in 40 Posts
    Rep Power
    54
    I know my boss had trouble with performance on the sims server for a while. In the end it turned out to be where he had taken a number of snapshots on the VM and it started slowing it all down. The answer was to merge them all back in to one I think, which was a slow process. Sorry if this has been suggested already. I don't work on servers so don't fully understand what has been said already.

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

Similar Threads

  1. Replies: 23
    Last Post: 14th November 2013, 02:10 PM
  2. Server unavailable\slow connection to share.
    By Timetable in forum Wireless Networks
    Replies: 11
    Last Post: 19th March 2012, 02:41 PM
  3. [SIMS] Virtulise sims server to run on laptop for training [Solved]
    By woodham in forum MIS Systems
    Replies: 3
    Last Post: 20th May 2011, 10:33 AM
  4. Existing SIMS server slowing down - spec?
    By howartp in forum MIS Systems
    Replies: 9
    Last Post: 23rd October 2009, 02:26 PM
  5. Ghost casting slows LAN to a crawl
    By m2d2 in forum Wireless Networks
    Replies: 13
    Last Post: 22nd February 2008, 06:15 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
  •