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.
    Alby81, Aug 2, 2006
    #2

  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.
    satya, Aug 2, 2006
    #2

  3. Alby81 New Member

    No there are None.The largest Column is Varchar(150)
    Alby81, Aug 2, 2006
    #2

  4. joechang New Member

    what is the full and complete output of sp_spaceused TableName
    joechang, Aug 2, 2006
    #2

  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.
    satya, Aug 3, 2006
    #2

  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
    Alby81, Aug 3, 2006
    #2

  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.
    satya, Aug 4, 2006
    #2

  8. Alby81 New Member

    The unused space is actually over 10 gb.How do i recover it??
    Alby81, Aug 4, 2006
    #2

  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.
    satya, Aug 4, 2006
    #2

  10. mmarovic Active Member

    What indexes do you have on the table? Is any fragmented?
    mmarovic, Aug 4, 2006
    #2

Share This Page