ADSM-L

Re: Expire Inventory

2006-02-14 20:24:00
Subject: Re: Expire Inventory
From: Josh-Daniel Davis <xaminmo AT OMNITECH DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 14 Feb 2006 19:23:37 -0600
Depends entirely on your server.  There's no chart based on the overall
load incurred; however, the extra I/O is all actlog.  If your DB
performance has room to spare, then it shouldn't be a problem.

You could always turn it on for a day and compare your expiration
performance the next day with:

select activity, cast((end_time) as date) as "Date", -
  (examined/cast((end_time-start_time) seconds -
  as decimal(18,13))*3600)"Pages backed up/Hr" -
  from summary where activity like '%DB%' and -
  days(end_time) - days(start_time)=0

-Josh

On 06.02.13 at 09:05 deehre01 AT LOUISVILLE DOT EDU wrote:

Date: Mon, 13 Feb 2006 09:05:16 -0500
From: David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Expire Inventory

Instead, you may want to run EXPire Inventory with Quiet=No

Does the QUIET=NO vs QUIET=YES on expirations have much of an effect on
the overall speed of expiration?

David


<Prev in Thread] Current Thread [Next in Thread>