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 |
|
kkalapan
Starting Member
5 Posts |
 Posted - 2005-01-05 : 11:59:20
|
| Can anybody give some sizing techniques/formulae on sql2k. I know the amount of raw data that I will load for each of my tables. But I need to know the actual space that sql2k needs to store this data. I also need info on sizing for indexes as well. I have mainly non-clustered indexes.Thanks,Kary. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-05 : 12:28:03
|
| >> But I need to know the actual space that sql2k needs to store this data.Depends on fragmentation, fill factor, row size compared to page size.Pointless trying to be too exact - just go by the amount of data and add a factor.Similarly for indexes.For large fairly static databases reckon on at least double.For smaller more volatile ones go for about 5 times.If you want to be more exact seehttp://www.sql-server-performance.com/q&a13.aspRemember log files and tempdb.For oltp databases these are usually small.For reporting servers tempdb can be large.For batch update databases the log can be largeThat's larger than the datbase.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
kkalapan
Starting Member
5 Posts |
Posted - 2005-01-05 : 14:02:35
|
| I dont know if sql2k uses any compression algorithms to store the data (dont think so). By the way some rdbms do so you might need less space than the raw data. But most rdbms need raw data + overhead (header info etc).I was wondering if there is any approximate(if not exact) formulae for that. This is not to size the database to the exact value but more for planing for future growth. |
|
|
|
|
|
|
SQL 2K database sizing