locked
Low Disk Space RRS feed

  • Question

  • Hi Team,

    D:\ Drive was showing Low Disk space and i dont know which file i have to delete

    what action i have to take please suggest me.

    Tx


    subu

    Wednesday, April 18, 2012 11:28 AM

Answers

  • Hi

    I don't know what kind of stuff you have on your drive, but if you have database files (MDF, NDF , LDF) you should detach the database having files on that drive , move the files to another drive and attach the database back.

    You can also identify the percentage of usage of those database files and shrink them

    Use below script to easily identify on which drives you have the database files as well as the usage

    http://sql-javier-villegas.blogspot.com.ar/2012/03/databases-info.html


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    • Proposed as answer by Peja Tao Thursday, April 19, 2012 6:08 AM
    • Marked as answer by Peja Tao Thursday, April 26, 2012 8:27 AM
    Wednesday, April 18, 2012 11:40 AM
  • Hi Subu,

    In addition, which SQL Server version are you using? If you are using high edition like enterprise after SQL Server 2008, you could use compression feature to reduce the size of SQL Server file.<o:p></o:p>

    Moreover if there are other files (not SQL Server related) on D drive, you may think of physical disk compression after checking with your server admin.



    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by Peja Tao Thursday, April 26, 2012 8:27 AM
    Thursday, April 19, 2012 6:21 AM

All replies

  • There are plenty of third part tools to show you such info....  http://www.techsupportalert.com/best-free-disk-space-analyzer.htm

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Wednesday, April 18, 2012 11:36 AM
    Answerer
  • Hi

    I don't know what kind of stuff you have on your drive, but if you have database files (MDF, NDF , LDF) you should detach the database having files on that drive , move the files to another drive and attach the database back.

    You can also identify the percentage of usage of those database files and shrink them

    Use below script to easily identify on which drives you have the database files as well as the usage

    http://sql-javier-villegas.blogspot.com.ar/2012/03/databases-info.html


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    • Proposed as answer by Peja Tao Thursday, April 19, 2012 6:08 AM
    • Marked as answer by Peja Tao Thursday, April 26, 2012 8:27 AM
    Wednesday, April 18, 2012 11:40 AM
  • HI Javier,

    How can we identify  which database using much percentage space.

    tx


    subu

    Wednesday, April 18, 2012 11:44 AM
  • Hi

    Use the script from the provided link. the column named "%USED" will provide you the percentage of usage per database file


    Javier Villegas | @javier_villhttp://sql-javier-villegas.blogspot.com/

    Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

    Wednesday, April 18, 2012 12:05 PM
  • --Data file usage

    Select f.physical_name, f.size/128. As 'Filesize in MB', 
    u.unallocated_extent_page_count/128. As 'Unused in MB'
    From sys.dm_db_file_space_usage u
    Inner Join sys.database_files f On u.file_id = f.file_id;

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    Wednesday, April 18, 2012 12:34 PM
    Answerer
  • Hi Subu,

    In addition, which SQL Server version are you using? If you are using high edition like enterprise after SQL Server 2008, you could use compression feature to reduce the size of SQL Server file.<o:p></o:p>

    Moreover if there are other files (not SQL Server related) on D drive, you may think of physical disk compression after checking with your server admin.



    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by Peja Tao Thursday, April 26, 2012 8:27 AM
    Thursday, April 19, 2012 6:21 AM
  • Hi Peja,

    Thanks for your reply..its new though for me

    I did below things

    1. Shirnink the logs files on large databases

    2. Remove the old files and old data

    3. as per ur suggestion i did

    after some time the disk goes to OUT OF DISK SPACE

    is there any new thought or we have to go increase the disk size because right now business is going on.

    TX


    subu

    Thursday, April 19, 2012 2:41 PM
  • what do you store on drive D and how large is it ?

    if it is out of disk space you definitively need to increase the disk size if you could.

    Thursday, April 19, 2012 4:51 PM