[msmom] RE: Localizedtext cleanup not working
-----Original Message-----
From: admin@lists.myITforum.com [mailto:admin@lists.myITforum.com] On Behalf
Of Dougherty, Michael A
Sent: Wednesday, October 28, 2009 2:04 AM
To: msmom@lists.myitforum.com
Subject: [msmom] RE: Localizedtext cleanup not working
I think I figured it out.
I believe that the "tempdb" was growing too large for the drive that it was
on.
The c: drive on this machine "only" has 37 GB free.
I'm going to move the tempdb to another drive with much more space and
re-try the cleanup.
--------------------
Michael Dougherty
ITS Systems - Infrastructure
Office: 475-7138
Blackberry: mdougherty@austin.utexas.edu
-----Original Message-----
From: admin@lists.myITforum.com [mailto:admin@lists.myITforum.com] On Behalf
Of Dougherty, Michael A
Sent: Tuesday, October 27, 2009 10:45 PM
To: msmom@lists.myitforum.com
Subject: [msmom] Localizedtext cleanup not working
I upgraded to SCOM R2 (from SCOM SP1 which in turn was upgraded from RTM
over the course of the past 2 years or so) earlier today and tried to run
the step 13 SQL query from here:
http://technet.microsoft.com/en-us/library/dd789073.aspx.
After running, Query Analyzer returned the following:
(43760928 row(s) affected)
Server: Msg 3604, Level 16, State 1, Line 45
Duplicate key was ignored.
(0 row(s) affected)
(1 row(s) affected)
Here are the stanzas in question (with line numbers):
40: CREATE TABLE #EventAllPublishers (PublisherId UNIQUEIDENTIFIER)
41: CREATE UNIQUE CLUSTERED INDEX #EventAllPublishers_CI ON
#EventAllPublishers (PublisherId)
42: WITH (IGNORE_DUP_KEY = ON)
43:
44: -- Populate temp table by scanning EventAllView one time
45: INSERT INTO #EventAllPublishers(PublisherId)
46: SELECT PublisherId
47: FROM EventAllView
After this completed, I ran:
select count(*) from localizedtext
and it returned a value of 43802754.
Another query reveals that Localizedtext and publisermessages are still far
and away my largest tables in the DB.
(Just for grins, I tried to run the "older" copy of the query on Kevin
Holman's blog post about this, and it ran for a similar period of time and
reveals that just as many rows are present afterwards.)
Any ideas?
I'd really like to get these tables under control.
--------------------
Michael Dougherty
ITS Systems - Infrastructure
Office: 475-7138
Blackberry: mdougherty@austin.utexas.edu
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/
Trackbacks
No Trackbacks
Comments
No Comments
