Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Volumetrics and sizing when creating database

Posted on 2001-08-09
8
Medium Priority
?
1,279 Views
Last Modified: 2012-06-27
Can anyone point me in the right direction for sizing blocks, and volumetrics etc when setting up a database?
0
Comment
Question by:Nikster
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 4

Expert Comment

by:YodaMage
ID: 6369291
What database are you using where you are concerned with block size? Just for the record, Paradox is evil, lol.

Being serious though, for Paradox, all we ever did was determine record size * expected size of dataset, then changed the block size to reflect those size requirements with a margin of error torward to large a block size.

Either way, if you have a problem, you can change the block size of the data set to a larger size with a rebuild of the data structure, so it really wasn't critical.
0
 

Author Comment

by:Nikster
ID: 6369549
It is an Oracle database, and from what I understand you can't change the block size after creation.  Thank you, though....
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

Author Comment

by:Nikster
ID: 6369786
Thanks - that helps!
0
 
LVL 1

Expert Comment

by:Greyman
ID: 6391548
The other thing to note (if you are putting specific tables on specific disks or something fancy like that) is the vital importance of understanding that your volume estimates will be wrong - give yourself contingency space and understand that the relative sizes of tables may change due to changes in the outside world.
0
 
LVL 4

Expert Comment

by:YodaMage
ID: 6414755
What else do you need?
0
 
LVL 4

Accepted Solution

by:
YodaMage earned 300 total points
ID: 6423319
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7284076

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - Answered by: YodaMage  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question