Load testing SQL 2000

[goofy]

Hi All,
Need some urgent help..
I optimizing Stored Procedures. The current database is of 5 GB in size and a specific tables have more than a million records. And this is just the sample db. The original has more than 20 to 30 million records and expected to grow at the rate of 5 million record per week.

Now i need to test the db for such huge data without replicating the information. I cant replicate the entire db.
have to do with sample.

Please help........

thanks!

 

[sguslan]

You can restore a full back to a different (temporary) database on a development server[i recommned dedicating a server for testing purposes].

If you can not test with production data, may be for security reasons, then you have to look at some products that help create test data. Third party offerings may help, such as

http://www.turbodata.ca/overview.htm

.

You can search any MS SQL centric sites and discussion groups for free scripts that help in this respect.