+ Post New Thread
Results 1 to 14 of 14
Educational Software Thread, eclipse.net database in Technical; how big is your eclipse.net database? Our sql2005 server seems to having some issues not least the sqlservr process using ...
  1. #1
    browolf's Avatar
    Join Date
    Jun 2005
    Location
    Mars
    Posts
    1,527
    Thank Post
    107
    Thanked 89 Times in 75 Posts
    Blog Entries
    46
    Rep Power
    40

    eclipse.net database

    how big is your eclipse.net database?

    Our sql2005 server seems to having some issues not least the sqlservr process using 1.6GB of ram.
    The wbls database is 5976.25mb

    is that usual?

    ~Andy

  2. #2
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    732
    Thank Post
    53
    Thanked 189 Times in 125 Posts
    Rep Power
    101
    Our eclipse database is 1.4Gb - I think I might have to try and shrink it! SQL will use all the RAM you can throw at it. It's supposed to release it gracefully if needed elsewhere.

  3. #3
    browolf's Avatar
    Join Date
    Jun 2005
    Location
    Mars
    Posts
    1,527
    Thank Post
    107
    Thanked 89 Times in 75 Posts
    Blog Entries
    46
    Rep Power
    40
    Quote Originally Posted by clareq View Post
    Our eclipse database is 1.4Gb - I think I might have to try and shrink it! SQL will use all the RAM you can throw at it. It's supposed to release it gracefully if needed elsewhere.
    i'd noticed that shrink option earlier. probably try it later.
    Our eclipse has 26k resources, 1828 borrowers, 461 current loans. how does that compare?

  4. #4
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    732
    Thank Post
    53
    Thanked 189 Times in 125 Posts
    Rep Power
    101
    28k resources, 2052 borrowers and 1661 loans, so not dissimilar.

  5. #5
    browolf's Avatar
    Join Date
    Jun 2005
    Location
    Mars
    Posts
    1,527
    Thank Post
    107
    Thanked 89 Times in 75 Posts
    Blog Entries
    46
    Rep Power
    40
    Quote Originally Posted by clareq View Post
    28k resources, 2052 borrowers and 1661 loans, so not dissimilar.
    so similar but your database is 4 times smaller! Will shrinking take the database offline?

  6. #6

    Join Date
    Feb 2009
    Posts
    149
    Thank Post
    0
    Thanked 36 Times in 35 Posts
    Rep Power
    18
    Just had a look at our system and get the following:

    20K Resources, 1095 borrowers, 455 loans
    sqlservr = 1.2GB
    wbls database = 465MB

    I don't know if it makes a difference but we are using SQL Server 2008 R2

  7. #7
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    732
    Thank Post
    53
    Thanked 189 Times in 125 Posts
    Rep Power
    101
    How much historic data does it contain? Our librarian is very good at clearing out the old users and resources.

  8. #8

    rush_tech's Avatar
    Join Date
    Jul 2006
    Location
    Nottingham
    Posts
    1,410
    Thank Post
    111
    Thanked 265 Times in 201 Posts
    Rep Power
    194
    Just come across this thread so I thought I'd check ours..........18GB that can't be right I thought.
    Phone call to Microlib about database size, tracked the problem down to a 17GB log file
    Solution was to set the recovery model to Simple in the SQL management console and then shrink the database. @browolf shrinking it doesn't take it offline. Now I have a database file of 555MB

    we have 18000 resources, 1600 borrowers and 630 current loans
    Last edited by rush_tech; 20th October 2011 at 03:29 PM.

  9. #9
    browolf's Avatar
    Join Date
    Jun 2005
    Location
    Mars
    Posts
    1,527
    Thank Post
    107
    Thanked 89 Times in 75 Posts
    Blog Entries
    46
    Rep Power
    40
    Quote Originally Posted by clareq View Post
    How much historic data does it contain? Our librarian is very good at clearing out the old users and resources.
    Emptying recycle bin of users it's much good. Everytime it checks for new users in sims through mlsconnect, it imports the 4000 users (all users ever) and discards the ones it doesn't need into the recycle bin.

  10. #10
    browolf's Avatar
    Join Date
    Jun 2005
    Location
    Mars
    Posts
    1,527
    Thank Post
    107
    Thanked 89 Times in 75 Posts
    Blog Entries
    46
    Rep Power
    40
    I tried to shrink the database overnight but it had an error about locked transactions. Maybe I need to take the database offline first...

  11. #11

    Join Date
    Sep 2010
    Posts
    566
    Thank Post
    26
    Thanked 63 Times in 59 Posts
    Rep Power
    20
    ours is around 500MB.
    from memory the database can get massive if it is logging every change in the system (including imports) so if there is a problem you can revert back to before the change.
    instead of this i just do a simple backup each night.
    i believe MLS do document this when setting the Database up

  12. #12
    browolf's Avatar
    Join Date
    Jun 2005
    Location
    Mars
    Posts
    1,527
    Thank Post
    107
    Thanked 89 Times in 75 Posts
    Blog Entries
    46
    Rep Power
    40
    Quote Originally Posted by SHimmer45 View Post
    ours is around 500MB.
    from memory the database can get massive if it is logging every change in the system (including imports) so if there is a problem you can revert back to before the change.
    instead of this i just do a simple backup each night.
    i believe MLS do document this when setting the Database up
    I think ours is set to full backup. I couldnt find a setup guide in the docs on the support part of mls site.

  13. #13

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,161
    Thank Post
    403
    Thanked 623 Times in 569 Posts
    Rep Power
    181
    Quote Originally Posted by browolf View Post
    I think ours is set to full backup. I couldnt find a setup guide in the docs on the support part of mls site.
    I'm not aware of that setting either?

  14. #14

    Join Date
    Aug 2010
    Posts
    2
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    We're using SQL server 2008 and I've just found the disc space on our eclipse server down to 0 bytes because of the wbls database log file of 102Gb!
    We run about 10K books with about 2000 users and 600+ current loans

    So to truncate the log files (from experience with SIMS):
    1 Logon to the server and run the SQL Server Management studio.
    2 Expand databases
    3 Select the database and right click, select properties.
    4 Check files to see that the file is part of the database.
    5 Click Options and change the recovery model to simple, OK that.
    6 Right click the database name again and from the menu select shrink/Files
    7 Once it completes repeat steps 3 and 4 but change the recovery model to full.
    That will manually shrink the transaction logs and free up the disc space to let the SQL server continue.

  15. Thanks to mavericksghost from:

    round2it (11th March 2014)

SHARE:
+ Post New Thread

Similar Threads

  1. Speeding up Eclipse.NET
    By Ric_ in forum Educational Software
    Replies: 17
    Last Post: 16th June 2009, 07:54 PM
  2. Eclipse.net and Windows x64
    By powdarrmonkey in forum Educational Software
    Replies: 3
    Last Post: 7th October 2008, 05:54 PM
  3. Eclipse.NET 'Service Unavailable'
    By Ric_ in forum Educational Software
    Replies: 5
    Last Post: 17th September 2008, 02:00 PM
  4. Eclipse.Net 31/01/2008 Release issues
    By Nexus-6 in forum Educational Software
    Replies: 6
    Last Post: 4th February 2008, 06:54 PM
  5. Accessing SIMS.Net database through ASP?
    By gavcradd in forum MIS Systems
    Replies: 9
    Last Post: 12th June 2007, 12:20 AM

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
  •