FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

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*