To: [EMAIL PROTECTED]
cc:
Subject:Re: Database fragmentation formula (was Re: Online DB Reorg)
I have to ask one thing about all this higher math - Does it matter?
That is, what can you do about it, or what should you do about it? I
think the answer is that, even
I did this for a subset of our clients, mainly the Unix clients, because
they were more copperative than the Intel clients.
Andy Carlson|\ _,,,---,,_
Senior Technical Specialist ZZZzz /,`.-'`'-. ;-;;,_
BJC Health Care
...
Isn't this getting a little off the mark though? Last I checked, almost
every database on the planet (yes even pervasive sql) when allocating
pages/extents, left an amount of space unutilized at the end. In fact, if
you do a reorg in SQL server, it specifically asks how much space you want
fragmentation formula (was Re: Online DB Reorg)
...
Isn't this getting a little off the mark though? Last I checked, almost
every database on the planet (yes even pervasive sql) when allocating
pages/extents, left an amount of space unutilized at the end. In fact, if
you do a reorg in SQL server
: Database fragmentation formula (was Re: Online DB Reorg)
...
Isn't this getting a little off the mark though? Last I checked, almost
every database on the planet (yes even pervasive sql) when allocating
pages/extents, left an amount of space unutilized at the end. In fact, if
you do a reorg
formula (was Re: Online DB Reorg)
Please don't throw the concept out. Like all tools it has it's place.
For example, we are thinking about reorg'ing one of our TSM databases.
Why?
1) I ran a test reorg of one of our TSM databases on a test system. The
db was 80gb
in size with 72gb used. It shrunk
Good point for reducing size, other than normal growth why would it not
last long, is ther other reasons?
Charles - Normal daily TSM activity makes for a lot of db updating which
rather rapidly returns the db to a condition akin to that before
the db reorg. Entropy, and all that.
I have to ask one thing about all this higher math - Does it matter?
That is, what can you do about it, or what should you do about it? I
think the answer is that, even if these competing formulae are correct
and you discover your database is fragmented, there is practically
nothing you can or
On Sat, 18 Oct 2003 14:35:09 -0400
Talafous, John G. [EMAIL PROTECTED] wrote:
Remco,
Would you be willing to share your SQL query that reports on DB
fragmentation?
I was allready looking at Eric (he probably saved my thingy somewhere
usefull, I just saved it in my sent-mail folder), here
PROTECTED]
Subject: Re: Online DB Reorg
On Sat, 18 Oct 2003 14:35:09 -0400
Talafous, John G. [EMAIL PROTECTED] wrote:
Remco,
Would you be willing to share your SQL query that reports on DB
fragmentation?
I was allready looking at Eric (he probably saved my thingy somewhere
usefull, I just saved
OK I ran Remco's sql and it reports my database is 53% fragmented.
I know that a fragmented database is the natural state, but is there any
level of fragmentation that you should start to get worried at ?
Not being a database expert I would say only worry if TSM cache hits start
slipping badly,
John Naylor wrote, in part:
OK I ran Remco's sql and it reports my database is 53% fragmented.
Maybe this makes you feel better? My result is 99.80, but then my
database isn't what it used to be :-)cheers, wayne
Message-
From: Loon, E.J. van - SPLXM [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 6:38 AM
To: [EMAIL PROTECTED]
Subject: Re: Online DB Reorg
Hi Guys!
The SQL statement can also be found at Richard's quickfacts page:
http://people.bu.edu/rbs/ADSM.QuickFacts
Kindest regards,
Eric
:
|
|Subject:
|
|Re: Online DB Reorg
PROTECTED]
Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED]
20.10.2003 13:30
Please respond to ADSM: Dist Stor Manager
To: [EMAIL PROTECTED]
cc:
Subject:Re: Online DB Reorg
On Sat, 18 Oct 2003 14:35:09 -0400
Talafous, John G. [EMAIL PROTECTED] wrote
: Monday, October 20, 2003 2:12 PM
To: [EMAIL PROTECTED]
Subject: Database fragmentation formula (was Re: Online DB Reorg)
* ATTENTION *
Those who do not like the mathematics, skip to the end (search for word
select).
*
From my mathematical background this query
Hi Zlatko,
If I plug into your formula, I get ...
1492.648 0.81294 14396.6095.29128
(clearly under utilized).
But (ADSM V3.1(ancient)) shows ...
Available Assigned Maximum MaximumPage Total Used Pct
Max.
Space Capacity Extension Reduction
I too will some day in the future need to reorg a TSM database. I am
currently working to split our 122GB database into two TSM instances. I will
be doing the same as Andy!!!
Andy,
Do I understand correctly that you simply pointed clients to the new
server and did a full backup and some time
I remember at one time, that online DB reorg was on the list of TSM
futures. Is it still there? Anyone have an idea about when it might
come out? We badly need a reorg. We split our TSM to two instances, by
creating a new instance and doing full backups to it, and deleting the
old stuff out
On Friday, Oct 17, 2003, at 20:20 Europe/Amsterdam, Andy Carlson wrote:
I remember at one time, that online DB reorg was on the list of TSM
futures. Is it still there? Anyone have an idea about when it might
come out? We badly need a reorg. We split our TSM to two instances,
by
creating a new
DB reorg was on the list of TSM
futures. Is it still there? Anyone have an idea about when it might
come out? We badly need a reorg. We split our TSM to two instances,
by
creating a new instance and doing full backups to it, and deleting the
old stuff out of the original instance
21 matches
Mail list logo