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 |
|
barhamgi
Starting Member
7 Posts |
 Posted - 2007-12-10 : 09:42:15
|
| Hello every body i am doing a research about high volume database treatment (maybe a database with tera bytes volume) , so is there any optimization or specialization for queries deal with such database? !! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-10 : 10:04:32
|
Yo most likely will have to deal with horizontal partitioning.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
barhamgi
Starting Member
7 Posts |
Posted - 2007-12-10 : 10:22:34
|
| thanx for your attention , yes the horizontal partitioning is a solution for the problem but it is a administrator solution , and what i mean that is there any client special processing or query optimization when he makes queries deal with such database ? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-10 : 10:44:59
|
Well designed indexes.Working with as small datasets as possible.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
JasonL
Starting Member
35 Posts |
Posted - 2007-12-13 : 20:01:11
|
| When you are dealing with tera data and the performance is important:There are quick a few factors involved here:* is this for OLTP (seconds)* is this for Data Warehouse/data mining type (days,hours or minutes)Then you need to know a bit about:* disk storage and IO performance* table/partition layout * is parallel processing needed (multiple cpu) machine size etc* then the indexing* database design and data model etcI think there are as many questions as answers.(FYI: I work for Microsoft as ISV Architect Evangelist) |
|
|
|
Ashra
Starting Member
2 Posts |
Posted - 2009-04-01 : 06:07:18
|
| I want some actual case study that illustrates the size of SQL Server 2000 i.e. its maximum capacity. it could be an example of some actual organization.Also i have observed at one of our client that when database reaches to the size of 2 GB, the searching becomes very slow on it and application runs in slow pace. i want some supporting points in this regard because have to convince client for some updation process._.'._.'.___Ashra___________ |
|
|
|
|
|
|
high volume database query optimization