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 07, 2013 1:48 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 07, 2014 7:44 AM
Points: 47, Visits: 235
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 07, 2013 2:00 PM
SSC-Addicted

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

Group: General Forum Members
Last Login: Thursday, March 27, 2014 6:04 PM
Points: 450, Visits: 991
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 07, 2013 2:07 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 07, 2014 7:44 AM
Points: 47, Visits: 235
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 07, 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: Thursday, March 27, 2014 5:29 AM
Points: 945, Visits: 1,760
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 08, 2013 7:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 07, 2014 7:44 AM
Points: 47, Visits: 235
That was it. This table is a heap.

Thanks for the help.
Post #1404245
Posted Tuesday, January 08, 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: Thursday, March 27, 2014 5:29 AM
Points: 945, Visits: 1,760
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