Re: Components Database growth is excessive
From: Michael (Michael_at_discussions.microsoft.com)
Date: 12/30/04
- Next message: ksheil_at_discussions.microsoft.com: "RE: How to update "Assigned To" list or remove a name"
- Previous message: Jay: "Need to change URL throughout entire site...?"
- In reply to: Sheff: "Re: Components Database growth is excessive"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Dec 2004 08:51:01 -0800
Unfortunately this too appears to be irrevlevant (nothing personal, Sheff).
According the ResKit
(http://www.microsoft.com/technet/prodtechnol/sppt/reskit/c0561881x.mspx) the
portalname_SERV database "Stores information for services, such as search and
alerts, that are provided by a portal site. Also called the component
settings database." and
(http://www.microsoft.com/technet/prodtechnol/sppt/reskit/c1761881x.mspx)
"stores service information for each portal site in a deployment. For
example, each time SharePoint Portal Server 2003 updates an index, it creates
a gatherer log entry in a table in the component settings database for the
portal site.". This doesn't seem to suggest that versioning information, or
the actual documents under version control, are in the portalname_SERV
database, and I've found no other information suggesting such. I believe the
documents and their version information is stored in the site database
(though I could definitely be mistaken on this).
Again, over 22GB of the database are a single table, srch_GathererLog_x,
with over 82 million rows.
Thanks all for the suggestions, but still looking for more guidance and
information. :-(
"Sheff" wrote:
> this is not a solution but may buy you some disk space, check document
> versioning, if the are big document that are resaved all the time and
> versioning is on the disk space can be eaten up quickly, try deleting some of
> the versions from those documents, hope this helps.
>
> "SizzleMaster" wrote:
>
> > Wow, unfortunatly I have nothing more to contribute in terms of any
> > potential solution. If you have the time, assuming you and/or others
> > determine a full or somewhat less than full solution and explanation, please
> > post back to this newsgroup.
> >
> > "Michael" <Michael@discussions.microsoft.com> wrote in message
> > news:2C28FE30-F110-4E7E-A892-85E75E10102C@microsoft.com...
> > > Sizzle,
> > >
> > > The database is configured for a FULL recovery model with auto-shrink
> > > enabled. Worse yet the database has no empty space to shrink. A single
> > > table in the database, one of the srch_gathererlog_x tables, has over 82
> > > million rows (that's over 22GB of the space issue). Unfortunately it
> > > isn't
> > > as simple as backing up and shrinking the database. Any other ideas?
> > >
> > > Worst case scenario, what do I lose if I reconfigure SPS to use a new
> > > component settings database? My content, config and profiles are in the
> > > other databases so what breaks if I "rebuild" the component settings
> > > database?
> > >
> > > Thanks.
> > >
> > > "Michael" wrote:
> > >
> > >> Our sql server ran out of disk space this evening due to a 23GB
> > >> components
> > >> database (portalname_SERV.mdf). For the life of me I can't gleen why the
> > >> database would be so large, or what would cause it to grow so fast (we've
> > >> been online with the poc and now the pilot for less than 60 days). Any
> > >> pointers, suggestions, questions for more info, would be greatly
> > >> appreciated.
> > >>
> > >> ------ setup ---------
> > >> Sharepoint Portal 2003 in a web farm configuration with 3 front end
> > >> servers
> > >> (2 web/search servers and 1 index/job server) with SQL 2000 on a remote
> > >> server. We are currently in the pilot phase of our deployment with
> > >> roughly
> > >> 30 users hitting the system and only a single [though very deep] site
> > >> under
> > >> http://servername/sites.
> > >> -----------------------
> >
> >
> >
- Next message: ksheil_at_discussions.microsoft.com: "RE: How to update "Assigned To" list or remove a name"
- Previous message: Jay: "Need to change URL throughout entire site...?"
- In reply to: Sheff: "Re: Components Database growth is excessive"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
