Size Calculation | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Size Calculation

<font face="Verdana"></font id="Verdana"><font size="2"></font id="size2"><font color="blue"></font id="blue"><font size="1"></font id="size1"><br /><br />I’m basically looking for the arthmetic (how to calculate)<br /><br />Say, i’ve a table with four columns, all integer type. two columns together form the primary key. no constraints, triggers etc.<br /><br />i’ve a total size limit of say, 100 MB. in this space how many maximum records can i have.<br /><br />also can somebody give me the basic formula to calculate a table size, that page file stuff, i’ve forgotten it now.<br /><br />thanks<br />[}<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Harry<br />
Buy the Microsoft Press SQL Server Performance Tuning Technical Reference. Great book with all the formulas. I would look it up for you but I’m lazy. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Approximately 6553600 rows 100 MB / 16 Int datatypes = 4 bytes
4 bytes x 4 columns = 16 bytes
100MB = 104857600 Bytes
104857600 / 16 = 6553600