August 4, 2014 at 2:15 am
Hi ,
I have four tables which I need to replicate in the production environment .
I need to share how much will be an average/estimate of bytes/characters per record across these tables please?
Can someone help me in detail for the same..Thanks in advance
August 4, 2014 at 2:57 am
You will need to perform a baseline on those four tables to find out how often they are updated. Without knowing what version of SQL Server you have, you could setup a profile trace or extended events or other 3rd party monitoring tool to check this.
What column/data types are in those four tables?
Remember with replication each article has a corresponding stored proc for each INSERT/DELETE/UPDATE statement that is made on the publisher. You can tweak replication these can be omitted on the subscriber.
Sorry for vauge answer but your question was vague also.
qh
August 5, 2014 at 4:23 am
To get an idea on the rows sizes, something like this will help.
SELECTT.Name, SUM(Max_Length) [Aproximate row size in bytes]
FROMsys.Columns C
INNER JOIN sys.Tables T
ON C.[object_id] = T.[object_id]
WHERET.name IN ('Tbl1', 'Tbl2', 'Tbl3', 'Tbl4')
GROUPBY T.Name
Filter column names if you are planning to only include some columns or, exclude some columns from the publication.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply