Odd table sizes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Odd table sizes

Odd table sizes

Rate Topic

Display Mode

Topic Options

Author

Message

Mick Opalak

Posted Monday, January 07, 2013 1:48 PM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 6:43 AM
Points: 42, Visits: 212

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

@SQLFRNDZ

Posted Monday, January 07, 2013 2:00 PM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 12:03 PM
Points: 412, Visits: 862

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

Mick Opalak

Posted Monday, January 07, 2013 2:07 PM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 6:43 AM
Points: 42, Visits: 212

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

CapnHector

Posted Monday, January 07, 2013 2:54 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 17, 2013 10:07 AM
Points: 935, Visits: 1,709

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

Mick Opalak

Posted Tuesday, January 08, 2013 7:39 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 6:43 AM
Points: 42, Visits: 212

That was it. This table is a heap.

Thanks for the help.

Post #1404245

CapnHector

Posted Tuesday, January 08, 2013 9:11 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 17, 2013 10:07 AM
Points: 935, Visits: 1,709

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?

Post #1404313

« Prev Topic | Next Topic »

Permissions