September 8, 2008 at 11:09 am
Guys,
We have a Sql Server 2005 database that is expected to grow up to 6 TB . As of now, its less than 300 GB, but expected to grow in the next year or so. Its a database mainly with pdf files.
Lately, I've been trying to read more on VLDB design from Kim Tripp. What I am looking for now, is a way to gather enough stats about our database to project future requirements and expected performance for the given design + hardware.
I know the questions sounds vague, but I am looking for any help in general. A white paper or a URL that I could start with.
With enough information, we could make some changes to the existing design and storage architecture for performance and scalability.
In the best case, I'd like to know what counters to monitor under various scenarios to make better judgements on:
Time it takes to backup, restore, reindex, update stats, etc.
How much RAM might be needed before database gets to 6 TB
What kind of Partition might be best?
Any help would be greatly appreciated.
thanks,
_UB
September 8, 2008 at 11:22 am
I'd suggest you do some reading at the SQLCat team's site at: http://sqlcat.com/. They do a lot of work with large installations and you could get some data there.
As far as growth, I'd be sure you're gathering statistics on table sizes, database sizes, and read v. writes for the various tables.
If your PDFs are > 1MB on average, I'd really look at SQL Server 2008 and the Filestream capabilities. That might give you some performance benefits.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 8, 2008 at 12:35 pm
Great Suggestion Steve... Now I have another good resource to add to my library.
As always thanks a lot.
Steve Jones - Editor (9/8/2008)
I'd suggest you do some reading at the SQLCat team's site at: http://sqlcat.com/.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply