+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, sims ldf file nearly 17 gig in Technical; I got in this morning to find my sims.ldf file was nearly 17gig yes you did read that correct now ...
  1. #1
    edie209's Avatar
    Join Date
    Mar 2006
    Location
    Kernow
    Posts
    671
    Thank Post
    41
    Thanked 17 Times in 16 Posts
    Rep Power
    22

    sims ldf file nearly 17 gig

    I got in this morning to find my sims.ldf file was nearly 17gig yes you did read that correct now what I would like to know is why does this happen I have got it sorted with a DBshrinker bat file from SCOMIS. But I would just like to know why it happened SCOMIS were anable to answer that question.

  2. #2

    Join Date
    Oct 2005
    Location
    East Midlands
    Posts
    738
    Thank Post
    17
    Thanked 105 Times in 65 Posts
    Rep Power
    37

    Re: sims ldf file nearly 17 gig

    Hi,

    How you got Bromcom system install on your network for e-behaviour or registration (Winfolder)?

    If this is the case, the ldf file will grow and grow and the only way to shrink it to do a backup using the DBAttach utility provided by Capita.

    HTH,

    Ash.

  3. #3

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,935
    Thank Post
    1,341
    Thanked 1,784 Times in 1,107 Posts
    Blog Entries
    19
    Rep Power
    595

    Re: sims ldf file nearly 17 gig

    This is the same for pretty much any 3rd party util that makes frequest read requests of a variety of sections of the DB. the GroupCall Xporter used for Sleuth (and other things) is terrible for this.

  4. #4
    edie209's Avatar
    Join Date
    Mar 2006
    Location
    Kernow
    Posts
    671
    Thank Post
    41
    Thanked 17 Times in 16 Posts
    Rep Power
    22

    Re: sims ldf file nearly 17 gig

    Ok we have bromcom so that is the reason thanks guys

  5. #5
    JohnCondon's Avatar
    Join Date
    Apr 2007
    Location
    Bromcom
    Posts
    283
    Thank Post
    47
    Thanked 64 Times in 41 Posts
    Rep Power
    26

    Re: sims ldf file nearly 17 gig

    We are hoping that the November release of SIMS will correct the DB Log Growth. Nothing we, as a third party, can do to correct it.
    We can however help reduce the frequency it occurs. As the log files are growing in concert with frequency of communication we can try to reduce the frequency of said communication until the problem is fixed and the logging is returned to pre SIMS 7.96 levels.
    PM me with your school details and I will get the helpdesk team to take the appropriate action.

  6. #6
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25

    Re: sims ldf file nearly 17 gig

    I also have this problem...

    Our database grew to 80GB..

    SIMS has a fix and they sent me a patch..

    The also have the DB Shrink file that works instantly

  7. #7

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79

    Re: sims ldf file nearly 17 gig

    John, I have asked our partner manager to contact you because Bromcom are using exactly the same calls as our developers but we are not seeing a large growth in the DB. I understand that SQL 2005 records more and the size is to do with the number of calls that are being made to the DB. There is nothing in the November release that addresses a growing log.

  8. #8

    DaveP's Avatar
    Join Date
    Oct 2006
    Location
    Can't talk now: The mother-ship is calling!
    Posts
    8,902
    Thank Post
    351
    Thanked 1,291 Times in 882 Posts
    Blog Entries
    4
    Rep Power
    1129

    Re: sims ldf file nearly 17 gig

    We recently had a problem with a large database on our SIMS server recently. An EasyTrace database had grown to 26 Gb. It brought the server to a complete halt.

    An EasyTrace software developer talked me through shrinking and then disconnecting the database in SQL Management server Express. We disconnected it because it was not in use and in theory it should not be increasing in size. Now it is disconnected nobody has complained, so what caused it to grow, and grow so large?

  9. #9
    JohnCondon's Avatar
    Join Date
    Apr 2007
    Location
    Bromcom
    Posts
    283
    Thank Post
    47
    Thanked 64 Times in 41 Posts
    Rep Power
    26

    Re: sims ldf file nearly 17 gig

    Quote Originally Posted by PhilNeal
    There is nothing in the November release that addresses a growing log.
    But there are the new API's that you have implemented on our behalf which should reduce significantly the number of calls required to retrieve the student data (for instance).
    Priya and Simon on Third party support have been very helpful and co-operative on this. They are a credit to your team.

  10. #10

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79

    Re: sims ldf file nearly 17 gig

    Thanks John - now I understand.

  11. #11

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,156
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    124

    Re: sims ldf file nearly 17 gig

    The LDF file for a SQL database is the log file - basically, if you turn on logging for the database (look at the properties and check the recovery model - anything but "simple" will do logging to different extents) then every transaction gets logged in there.

    Reading data should have no effect on the size of the log - unless you're doing some kind of read-auditing.

    The idea of this is that not only do you have a point-in-time backup of your system but you also have a record of every change made to it since that backup. In the case of a registration system that's probably an entry for each pupil absence/presence etc plus all other changes made.

    I'm not familiar with SIMS own backup routines but the daily backup process ought to backup the current state of the database; at that point you know all transactions are safely committed to the databse so you can shrink the log - you don't need details of those transactions any longer.

    If you don't shrink the log then it will continue to grow - nothing is wrong, it's doing what it's designed to do - so you really need to make sure that you have some kind of regular maintenance process which shrinks the logfiles. (Shrinking the database may help but is less likely to be critical unless you're adding and deleting thousands of records)

  12. #12
    eejit's Avatar
    Join Date
    Jun 2005
    Location
    Ireland
    Posts
    606
    Thank Post
    52
    Thanked 12 Times in 12 Posts
    Rep Power
    22

    Re: sims ldf file nearly 17 gig

    Should everyone be running the DBshrinker bat mentioned in the first post, on a nightly schedule?
    BTW, does it need any services to be stopped while run?

SHARE:
+ Post New Thread

Similar Threads

  1. Import SIMS file sets 0053 for SIMS
    By newcareer in forum MIS Systems
    Replies: 3
    Last Post: 17th September 2010, 02:34 PM
  2. how to shrink an ldf file
    By ful56_uk in forum How do you do....it?
    Replies: 2
    Last Post: 18th May 2010, 04:36 PM
  3. Very large Citrix XenAPPRMS_log.ldf
    By cookie_monster in forum Thin Client and Virtual Machines
    Replies: 3
    Last Post: 13th May 2010, 12:00 PM
  4. 100 mb to Gig swtiches
    By Amy in forum Wireless Networks
    Replies: 12
    Last Post: 21st December 2009, 02:21 PM
  5. [SIMS] LDF growing very quickly
    By rhyds in forum MIS Systems
    Replies: 6
    Last Post: 27th February 2008, 02:47 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
  •