Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-11-16 : 07:20:05
|
| Dear Experts,now i was allotted as a complete DBA for one client and i've to take care from the creation itself.we've understood the data will be around 20 GB initially, and from there onwards, 1GB data will grow in the database. total number of tables are around 1400. and we have primary key on each table.Now you Experts, please guide me that how can i take the Fragmentation levels for best performance? or i need to give you more information regarding that.....i need your valuble suggesions and guidence |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-11-16 : 09:27:26
|
| That is too big and too general for a Q&A question.To start, 20 GB is nothing nowadays. 1 GB per day or per week of growth? This could be a factor.Is this a OLTP transactional database? Any reporting need?Are all the applications that will use the db existed? If you can make them using stored procudures, that will be one big step intot the right direction.Have the hardware decisions been made for you?And just a million other details... |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 00:54:55
|
| What do you mean 'take the Fragmentation levels for best performance'? |
|
|
|
|
|
|
planning for creating a database