Skip to Content.
Sympa Menu

freetds - Re: 26 CPU's all maxed out

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: 26 CPU's all maxed out
  • Date: Wed, 20 Jun 2001 16:11:11 -0700


James K. Lowden writes:
> Norman Palardy wrote:
>
> > Us too. E6500 with 26 CPU's and their all maxed out
> >
> > So once a month we take an outage, kick everyone off the system and
> > rebuild
>
> > as much of the stats on these tables as we can. We're lucky if we get
> > one or
> > two tables finished over a weekend.
>
> Norman,
>
> I don't have a solution or an answer, but I have a reaction. In a word:
> Ouchiwawa.
>
> I'm sure you run a hot backup on something like that. Too bad you can't
> update the
> statistics on the backup box and export them back to the production one.
> Too bad you
> can't do your own sampling and punch in your own stats.

Actually you can, with 12.x.

Michael
--
Michael Peppler - Data Migrations Inc. - mpeppler AT peppler.org
http://www.mbay.net/~mpeppler - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com
*Looking for new project to tackle starting 8/1/01*




Archive powered by MHonArc 2.6.24.

Top of Page