MS SQL Support?

Comments

7 comments

  • Brad Duncan

    I found a command this morning I can run in the SQLite console and that forces the WAL file to checkpoint.  Once the WAL file checkpoints computers begin to save, again, very quickly.  I can run this command without stopping any service which seems like a much better option.  

     

    I've noticed that the WAL file will sometimes continue to checkpoint successfully even with a couple hundred computers scanning.  But other times it'll get locked (and grow to 1GB+) and if I run this command it will seemingly be corrected (always temporarily) and continue scanning quickly.  It seems like this has to be a bug and the WAL file should be doing checkpoints without manual intervention even during large scan jobs.  Also, I'm not a DBA and I have zero experience with SQLite so I don't know what side effects running this command might have on the database.  I'm willing to run this against our database though since, in its current state, Inventory is practically unusable for large scanning jobs.  Here's a link to the site where I got the command: https://www.sqlite.org/pragma.html#pragma_wal_checkpoint

     

    Thanks again!

     

    Brad

     

    0
    Comment actions Permalink
  • Jason Hanks

    Hi Brad,

    Can you do us a favor and go to Preferences -> Database

    Click on SQLite console button

    Run this command:

    pragma integrity_check;

    **(Note - make sure you include the semicolon)**

    Attach a screenshot of what see when you run that command please.

    Before you close Preferences on that same panel can you click on the Optimize Database button as well and see if that helps with the performance.

    0
    Comment actions Permalink
  • Brad Duncan

    Hi, Jason

    I've attached a screenshot of the results of running that command.  It came back "ok".  

    I've run optimize database several times in the past.  It does help for a short time.  But the database always starts to slow down again after a large number of computers scan.

    0
    Comment actions Permalink
  • Brad Duncan

    I forgot to add.  The slowdown is always temporary.  After a large scan job it will eventually catch up and everything will start running normal again, but this can take several hours or even over night.  Like, right now, it's running fine.  

    0
    Comment actions Permalink
  • Jason Hanks

    Hi Brad,

    Thanks for sending that back in.  Can you let us know what version of Inventory you're currently running?  

    0
    Comment actions Permalink
  • Brad Duncan

    Hi, Jason

    I'm running 7.3.0.0.  The latest I believe. 

    0
    Comment actions Permalink
  • Jason Hanks

    *** Note *** This was resolved in an internal support ticket with the customer.  Due to the nature of each users environment there is no blanket answer to solve this.  If you are experiencing issues please submit them to support@adminarsenal.com.

    0
    Comment actions Permalink

Please sign in to leave a comment.