Caching an sql table

  • Thread starter Thread starter Nemisis
  • Start date Start date
N

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.
 
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?
 
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/library/aa933068(SQL.80).aspx
 
Back
Top