Re: Expire Inventory
2006-02-14 20:24:00
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
|
|
|