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.hueb...@alconlabs.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
