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

Odd table sizes Expand / Collapse
Author
Message
Posted Monday, January 7, 2013 1:48 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 47, Visits: 246
I have a table, I'll call it "X", in a database which is replicated to another server via Merge replication. On the Publisher the space information for the table looks like this:
name rows reserved data index_size unused
X 1296 772848 KB 772232 KB 136 KB 480 KB

The replicated table on the subsciber looks like this:
name rows reserved data index_size unused
X 1176 488 KB 216 KB 112 KB 160 KB

Notice that the subscriber table is much smaller and in line with what we would expect for this table. Can anyone offer an explanation why one would be so much bigger than the other? I've run DBCC UPDATEUSAGE on both sides to make sure that the information is accurate.
Post #1403863
Posted Monday, January 7, 2013 2:00 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:45 PM
Points: 477, Visits: 1,052
the other way to confirm the number of rows in 2 tables select Count(*) from table and is same number of rows in both tables ?


--SQLFRNDZ
Post #1403869
Posted Monday, January 7, 2013 2:07 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 47, Visits: 246
I verified the row counts using COUNT(*) and they match, as I would expect. However, the publisher has a much larger data size.
Post #1403872
Posted Monday, January 7, 2013 2:54 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 19, 2014 5:16 AM
Points: 887, Visits: 1,774
Mick Opalak (1/7/2013)
I verified the row counts using COUNT(*) and they match, as I would expect. However, the publisher has a much larger data size.


Is there a clustered index or is this a heap? Heaps do have an issue of not releasing space from delete records http://support.microsoft.com/kb/913399. Its a known "Issue" with heaps and why i tend to use a clustered index on every table.



For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw

Need to Split some strings? Jeff Moden's DelimitedSplit8K
Jeff Moden's Cross tab and Pivots Part 1
Jeff Moden's Cross tab and Pivots Part 2

Jeremy Oursler
Post #1403883
Posted Tuesday, January 8, 2013 7:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 47, Visits: 246
That was it. This table is a heap.

Thanks for the help.
Post #1404245
Posted Tuesday, January 8, 2013 9:11 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 19, 2014 5:16 AM
Points: 887, Visits: 1,774
Mick Opalak (1/8/2013)
That was it. This table is a heap.

Thanks for the help.


Did you add a clustered index or resolve it in some way or do you now need to take a look at how to resolve it?



For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw

Need to Split some strings? Jeff Moden's DelimitedSplit8K
Jeff Moden's Cross tab and Pivots Part 1
Jeff Moden's Cross tab and Pivots Part 2

Jeremy Oursler
Post #1404313
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse