My MSDB Database is over 25 GB on production server

Question

My MSDB Database is over 25 GB on production server

srvhjraju

Old Hand

Points: 303
More actions
March 8, 2011 at 11:43 am

#236247

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....

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

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

Leo.Miller SSChampion Points: 13051 More actions · Answer 1

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.

srvhjraju Old Hand Points: 303 More actions · Answer 2

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.

Geoff A SSChampion Points: 11511 More actions · Answer 3

some one at one point installed SQL Trace Analyzer

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

srvhjraju Old Hand Points: 303 More actions · Answer 4

Thank you all.

The following link solved my problem.

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

lstewart Valued Member Points: 55 More actions · Answer 5

The uninstaller did not work for us. Any suggestions?

homebrew01 SSC Guru Points: 55548 More actions · Answer 6

lstewart (3/8/2012)
The uninstaller did not work for us. Any suggestions?

Add/Remove Programs ?

PAH-440118 Ten Centuries Points: 1292 More actions · Answer 7

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

Sailor SSCertifiable Points: 5246 More actions · Answer 8

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.

PAH-440118 Ten Centuries Points: 1292 More actions · Answer 9

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

lstewart Valued Member Points: 55 More actions · Answer 10

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.

Sailor SSCertifiable Points: 5246 More actions · Answer 11

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?

ludo.van.den.ende SSC Rookie Points: 25 More actions · Answer 12

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