My MSDB Database is over 25 GB on production server

  • The following tables are consuming alot of space in the msdb database.

    LakeSideLockLogger._LakeSide_DbTools_LockLog-------------------------14.5 GIG

    LakeSideLockLogger._LakeSide_DbTools_LockExecStack-------------------7.5 GIG

    LakeSideLockLogger._LakeSide_DbTools_DeadlockLog---------------------0.4 GIG

    LakeSideWaitsLogger._LakeSide_DbTools_WaitsLogger_WaitsDBLog--------0.3 GIG

    Please help....

  • It looks like someone installed a db managment tool that either deliberatly or accedently added tables to msdb. This is not a good idea.

    Tools like this may use the sytem databases as a source, but I would recommend you avoid adding tables to the system databases. Create a seperate database for the application to use, then remove the offending tables.

    Cheers

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

  • Leo,

    Thank you for the reply. We don't have any db management tools installed on box. So are these databases not part of MSDB??

    Thank you.

  • some one at one point installed SQL Trace Analyzer

    http://www.lakesidesql.com/products/sql_trace_analyzer.html

  • Thank you all.

    The following link solved my problem.

    http://www.sqlsolutions.com/products/sql-deadlock-detector/Uninstall.html

  • The uninstaller did not work for us. Any suggestions?

  • lstewart (3/8/2012)


    The uninstaller did not work for us. Any suggestions?

    Add/Remove Programs ?

  • Unistaller worked for me but as per the suppiers web site

    SQL Deadlock Detector and SQL Ultimate Performance Monitor install server-side Agent.

    Do not remove our agent manually! If you experience any problems removing our tool contact technical support: support@sqlsolutions.com

  • Do I need to run the uninstaller on the server? It doesn't seem to work when I run it locally. Also, the tables are still there in msdb.

  • Sorry, it is some time since I did this so I can't remember. I suggest you check the manufacturers web site

  • Run from the machine where it was installed from. I got very little assistance from sqlsolutions. Once we figured out who installed it in the first place, we were able to uninstall from there.

  • I tried running the uninstaller on the server and it still seems to think that it's installed. I have renamed the lakeside tables in msdb with back in front of the names.

    What prompted me to uninstall was one of the logs was filled with the message from Lake Side, but now I cannot seem to find them to verify it has stopped Has anyone else seen the logs and what log are you looking in?

  • I guess Lake Side will used stored procedures and/or jobs under SQL Server Agent that fill up these tables.

    If you can find those, you could try disabling them

    If you need assistance, drop us a mail http://www.sqlperform.com

    SQL Perform Tools could be an alternative for you.

    Ludo Van den Ende

    SQL Perform

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply