Hello,

I have a SQLServer 2K being used for OLAP processing. There are several DTS
packages that do the DTS processing. Some of these DTS packages extract data
from an external data source and then process them. I need to estimate the
average daily data that is being fed into this system.

Is there any way I can monitor the daily data input into the system through
SQL server? I can determine the cube sizes etc. but these are not reflective
of the daily data feed.

Thank You

To estimate, your are the better player to do this!

To track your daily usage, then you can store some informations in a log
table in SQL Server (like the number of rows before/after a daily process in
your tables, also you can track your file size in SQL Server)

After, for the size of your cubes, I propose this:
look at the number of rows in your database, then process your cube and
create a ratio between the cube size and the number of rows. If the
compression ratio keep the same value (generally between 60% to 80%) day
after day, then you have some good statistics in your hand!

After, you can put some alerts in SQL Server to email to you if the disk
usage is greater then a specific value, this help you to prevent some
problems....

good luck !

Jerome.


"UR ednec" <pmckenna9999 (AT) yahoo (DOT) com> a écrit dans le message de
news:eJFOGPMRDHA.1072 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.497 / Virus Database: 296 - Release Date: 2003-07-04