Thanks! You made me a bit more confident and feel more assured about
my plan. And thanks for reminding about DB audit, it's a good
measuring stick indeed!
--
Warm regards,
Michael Green



On Tue, Aug 4, 2009 at 7:35 PM, Huebner,Andy,FORT
WORTH,IT<Andy.Huebner AT alconlabs DOT com> wrote:
> What I did recently was to load a production DB on the test server and run my 
> series of tests.  Then reloaded the DB, changed stuff and run again.  It 
> sounds like you are setup to do that.
>
> For comparison, I noted the run time for expiration on the production and 
> test systems to estimate an offset.  I used the offset to adjust the tests to 
> production.  I then spent the next three weeks restoring the DB and testing. 
> (rinse. Repeat.)
>
> The offset in my case added about 10% to the test times to give me an 
> estimated production run time.  This is mostly because we have small DB 
> incremental backups running all day.
>
> You might also try a full audit if you have a week or 2 of spare time.
>
> Hope this helps at least a little.
>
> Andy Huebner