Re: Expiration performance
2004-09-10 12:07:02
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
|
|
|