Post reply

how to know the delta data volume processed every day in mb

  • March 8, 2013 at 1:57 am

    #275010

    Hi I wanted to know if there is a way to figure out how many bytes of data have been processed while performing the delta on a table.

    I can easily get the delta count of every delta job run, but I'm not aware if there is a way to figure out how many bytes are processed based on the delta row counts or other.

    We use Informatica for our ETLs if this helps to get the delta data volume info.

    Please help and suggest of all possible ways to get this info.

  • March 19, 2013 at 11:17 pm

    #1598719

    I have got this script from old post of Gail. I have few small questions on this. Please let me know so that i can start using this for my operational purposes.

    create table ##tmp (TableName varchar(100),DefinedRowSize int)

    exec sp_msforeachtable 'INSERT INTO ##TMP Select ''?'' As TableName, SUM(C.Length) as Length from dbo.SysColumns C (NOLOCK) where C.id = object_id(''?'')'

    select TableName,DefinedRowSize from ##tmp order by TableName

    1) What is DefinedRowSize ?

    2) How is the calibration of DefinedRowSize MB? OR KB? OR Bytes?

    I'm actually trying to calculate size of few selective records from a table.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply