ADSM-L

Re: Expiration performance

2004-09-10 12:07:02
Subject: Re: Expiration performance
From: Joe Crnjanski <JCrnjanski AT INFINITYNETWORK DOT COM>
Date: Fri, 10 Sep 2004 12:06:50 -0400
I have scripts to test performance. I don't remember how did I get them (maybe 
from this group)



Database backup performance (result from the script should be >5,000,000)

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='FULL_DBBACKUP' and days (end_time) -days 
(start_time)=0
Expiration performance (result from the script should be >3,800,000)
Expiration performance (result from the script should be >3,800,000)

select activity, cast ((end_time) as date) as "Date", (examined/cast 
((end_time-start_time) seconds as decimal (18,13)) *3600) "Objects Examined 
Up/Hr" from summary where activity='EXPIRATION' and days (end_time) -days 
(start_time)=0


Joe Crnjanski
Infinity Network Solutions Inc.
Phone: 416-235-0931 x26
Fax:     416-235-0265
Web:  www.infinitynetwork.com



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