Post reply

Database size keep increasing size massively..

  • January 19, 2013 at 3:09 am

    #268837

    HI my database is keep increasing size very massively. On server i have only 1 database and database have around 30 tables. In which 1 table have around 1 lakh record and rest are very low.

    Initially my DB size was around 1 GB, from last few days my server have started consuming 100% CPU utilization. So i checked the size by sp_spaceused command and it show around 100 GB hard disk space occupied, my server have the only 125 GB space.

    Data in table is almost same, no much data in stored in database.

    Please let me know solution if any one is aware.

    I am using SQL Server 2012

  • January 19, 2013 at 4:28 am

    #1578943

    I have checked size of .mdf and .ldf file.

    .mdf - 3 GB

    .ldf - 96 GB

    I have checked what all the traces is ON and find only System Trace is ON.

    But i am surprised why log file is so big?

  • January 19, 2013 at 9:54 am

    #1578970

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1409171-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply