Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to know the delta data volume processed every day in mb Expand / Collapse
Author
Message
Posted Friday, March 08, 2013 1:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 5:00 PM
Points: 193, Visits: 621
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.
Post #1428447
Posted Tuesday, March 19, 2013 11:17 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 01, 2014 5:00 PM
Points: 193, Visits: 621
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.
Post #1432998
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse