Caching an sql table

[Nemisis]

Hi everyone,

I would like to test how big an sql table would be in kb if i put it in
the web cache. I need to do this as i will need to do it for 80
databases! So need to check this information before actually
implementing it.

Does anyone know of a tool where by it will tell me the size of the
cache before and after i put an object into it??

The table will have approximately 300-500 rows and about 7 fields in
each row.

[Nemisis]

Or a could cache an object list, either one, but still need to test the
size once it is in the cache, if anyone can help?

[Dave Sexton]

Hi,

This method will help you to calculate the approximate size of a single row
of data in the database. In managed memory, the average size of a row will
probably be somewhat different. If you feel that your estimates will be too
far off then the only accurate way is to create a prototype application and
test it for yourself using scaled test data (preferably, live data samples).

"Estimating the Size of a Table (Sql Server)"
http://msdn2.microsoft.com/en-us/lib...8(SQL.80).aspx

--
Dave Sexton

"Nemisis" <da*********@hotmail.comwrote in message
news:11**********************@k70g2000cwa.googlegr oups.com...

Hi everyone,

I would like to test how big an sql table would be in kb if i put it in
the web cache. I need to do this as i will need to do it for 80
databases! So need to check this information before actually
implementing it.

Does anyone know of a tool where by it will tell me the size of the
cache before and after i put an object into it??

The table will have approximately 300-500 rows and about 7 fields in
each row.