URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider) 
Author Message
 URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider)
Hi,
I use SQL server 7sp3 + all patches on NT4 server with all patches too (and
MMC 1.2).
I found a big bug : tables in MMC appear much bigger than they are (ex : 91
Mo in MMC and 7 Mo with SQL insider).
I found a way to shrint it back making a backup of table and reassingning it
with primary key and so on. It's not easy. Itried to shrink tables but
nothing works. In result another pb appears with backups : they actually do
the size MMC shows them.

Can someone help on this pb ?



Tue, 24 Feb 2004 22:43:02 GMT
 URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider)

Hi,
I do not think that this is a bug. I remember seeing an
explantion for this apparent discpancy some time ago. It
may have been from an article in the SQLServer Mag.
However, my recollection of the explanation is poor. I
will try and find the article and pass on the explanation.

Original Message-----

Quote:
>Hi,
>I use SQL server 7sp3 + all patches on NT4 server with

all patches too (and
Quote:
>MMC 1.2).
>I found a big bug : tables in MMC appear much bigger than
they are (ex : 91
>Mo in MMC and 7 Mo with SQL insider).
>I found a way to shrint it back making a backup of table
and reassingning it
>with primary key and so on. It's not easy. Itried to
shrink tables but
>nothing works. In result another pb appears with

backups : they actually do
Quote:
>the size MMC shows them.

>Can someone help on this pb ?

>.



Tue, 24 Feb 2004 23:48:35 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider)

2. HELP URGENT : Table size in MMC is bigger than real size (wiewed with SQL insider)

3. Database File Size - big size little info

4. Database size bigger than device size???

5. SQL SERVER Table size and Index size query

6. A script to recreate all tables with the *REAL* size used

7. How to clculate table REAL size.

8. Optimum Configuration for Page Size, NTFS Allocation Unit size and RAID Stripe size

9. RECORD SIZE IS TOO BIG FOR TABLE

10. Why are tables sizes so big?

11. Table Size too big??

12. Why are tables sizes so big?


 
Powered by phpBB® Forum Software