SQL Server Performance

Abnormal table size

Discussion in 'Performance Tuning for Hardware Configurations' started by Alby81, Aug 2, 2006.

  1. Alby81 New Member

    Hi pple,<br />I have this tables with 1.2 million records and it's 16gb in size.The same table in another database is 500MB and it has 4.7 million records.Field sizes are the same.<br />What could be the problem&gt<img src='/community/emoticons/emotion-4.gif' alt=';p' />lease Help.
  2. satya Moderator

    Are there any TEXT/NTEXT or IMAGE columns?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  3. Alby81 New Member

    No there are None.The largest Column is Varchar(150)
  4. joechang New Member

    what is the full and complete output of sp_spaceused TableName
  5. satya Moderator

    What is the size of Transaction log for that database?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  6. Alby81 New Member

    The transaction is indeed very small.It's 64MB.
    JoeChang I am yet to get the details of sp_spaceused cheers
  7. satya Moderator

    .. for optimum results run as SP_SPACEUSED @UPDATEUSAGE='TRUE.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  8. Alby81 New Member

    The unused space is actually over 10 gb.How do i recover it??
  9. satya Moderator

    You can use DBCC SHRINKFILE to do so, but before that think twice.
    Do you have any disk space issues?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  10. mmarovic Active Member

    What indexes do you have on the table? Is any fragmented?

Share This Page