to "ADSM: Dist Stor Manager"
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
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 sho
>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.
R
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 u
ECTED]
Sent: Tuesday, October 21, 2003 7:44 AM
To: [EMAIL PROTECTED]
Subject: Re: 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
&g
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 "re
...
>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 w
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
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
astev [mailto:[EMAIL PROTECTED]
Sent: 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").
*
>
here is no Nobel price
for mathematics :-))
Zlatko Krastev
IT Consultant
Remco Post <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
20.10.2003 13:30
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
m confsed
(But then, it's Monday)
-Original 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
osed
(But then, it's Monday)
-Original 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://peopl
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
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,
bu
EMAIL 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 sav
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)
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 lat
arlson 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 instance
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
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 of
21 matches
Mail list logo
