Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

My MSDB Database is over 25 GB on production server Expand / Collapse
Author
Message
Posted Tuesday, March 8, 2011 11:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 12, 2013 2:17 PM
Points: 3, Visits: 14
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
Posted Tuesday, March 8, 2011 11:55 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, June 16, 2014 8:08 PM
Points: 449, Visits: 1,333
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
Posted Tuesday, March 8, 2011 12:51 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 12, 2013 2:17 PM
Points: 3, Visits: 14
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
Posted Tuesday, March 8, 2011 1:20 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 12:24 PM
Points: 514, Visits: 1,717
some one at one point installed SQL Trace Analyzer

http://www.lakesidesql.com/products/sql_trace_analyzer.html
Post #1075090
Posted Tuesday, March 8, 2011 3:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 12, 2013 2:17 PM
Points: 3, Visits: 14
Thank you all.

The following link solved my problem.

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

Post #1075207
Posted Thursday, March 8, 2012 8:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 27, 2014 9:30 AM
Points: 13, Visits: 279
The uninstaller did not work for us. Any suggestions?
Post #1263665
Posted Friday, March 9, 2012 8:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:19 AM
Points: 2,826, Visits: 8,462
lstewart (3/8/2012)
The uninstaller did not work for us. Any suggestions?

Add/Remove Programs ?



Post #1264444
Posted Tuesday, January 8, 2013 3:34 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 5:14 AM
Points: 68, Visits: 281
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
Posted Tuesday, March 12, 2013 6:38 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:02 PM
Points: 245, Visits: 786
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
Posted Tuesday, March 12, 2013 7:26 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 5:14 AM
Points: 68, Visits: 281
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 »

Add to briefcase 12»»

Permissions Expand / Collapse