• shiwani.plrs (9/20/2013)


    for information

    database size is 16938.25 MB

    and available space is 1455.23 MB

    Hi,

    According to your info, you should not shrink the database's files.

    If you do that, then do not forget to rebuild all the indexes. Shrink causes very high fragmentation.

    Try to find some missing indexes, or check if your code is causing the low performance behaivour.

    16GB is small size.

    Regards,

    IgorMi

    Igor Micev,My blog: www.igormicev.com