My MSDB Database is over 25 GB on production server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » My MSDB Database is over 25 GB on production...

12 posts, Page 1 of 2

1 2 »»

My MSDB Database is over 25 GB on production server

Rate Topic

Display Mode

Topic Options

Author

Message

srvhjraju

Posted Tuesday, March 08, 2011 11:43 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 09, 2011 10:59 AM
Points: 3, Visits: 10

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

Post #1075012

Leo.Miller

Posted Tuesday, March 08, 2011 11:55 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:44 PM
Points: 442, Visits: 1,300

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

Post #1075026

srvhjraju

Posted Tuesday, March 08, 2011 12:51 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 09, 2011 10:59 AM
Points: 3, Visits: 10

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.

Post #1075069

Geoff A

Posted Tuesday, March 08, 2011 1:20 PM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 7:10 AM
Points: 485, Visits: 1,568

some one at one point installed SQL Trace Analyzer

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

Post #1075090

srvhjraju

Posted Tuesday, March 08, 2011 3:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 09, 2011 10:59 AM
Points: 3, Visits: 10

Thank you all.

The following link solved my problem.

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

Post #1075207

lstewart

Posted Thursday, March 08, 2012 8:22 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:48 AM
Points: 13, Visits: 236

The uninstaller did not work for us. Any suggestions?

Post #1263665

homebrew01

Posted Friday, March 09, 2012 8:39 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 2,554, Visits: 7,209

lstewart (3/8/2012)

The uninstaller did not work for us. Any suggestions?

Add/Remove Programs ?

Post #1264444

PAH-440118

Posted Tuesday, January 08, 2013 3:34 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:09 AM
Points: 59, Visits: 213

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

Post #1404097

Sailor

Posted Tuesday, March 12, 2013 6:38 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 6:22 AM
Points: 236, Visits: 747

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.

Post #1429746

PAH-440118

Posted Tuesday, March 12, 2013 7:26 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:09 AM
Points: 59, Visits: 213

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

Post #1429801

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions