none
(Sumber: milis SQL Server) shrink temp db RRS feed

  • Pertanyaan

  • dear master2 ,

    mohon pencerahannya

    bolehkah tempdb baik itu mdf maupun ldfnya di shrink ?

    dampaknya apa apabila tempdb di kecilkan datanya maupun lognya ?

    apakah akan meningkatkan performance ?

    trims


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Senin, 01 April 2013 09.48
    Moderator

Jawaban

  • Tempdb boleh dishrink. Mengecilkan tempdb tidak ada pengaruh signifikan terhadap kinerja aplikasi. Jika mau tuning tempdb bisa pindahkan tempdb ke disk yang paling cepat, dan atau memecah tempdb ke beberapa file.

    Dijawab oleh: Ahmad Masykur


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Senin, 01 April 2013 09.48
    Moderator

Semua Balasan

  • Tempdb boleh dishrink. Mengecilkan tempdb tidak ada pengaruh signifikan terhadap kinerja aplikasi. Jika mau tuning tempdb bisa pindahkan tempdb ke disk yang paling cepat, dan atau memecah tempdb ke beberapa file.

    Dijawab oleh: Ahmad Masykur


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Senin, 01 April 2013 09.48
    Moderator
  • Tidak ada benefit mengecilkan tempdb.

    Kecuali benar2 fakir space. :)

    Karena naturenya dia akan autogrow, sesuai dengan kebutuhan proses.

    Dijawab oleh: Ishak


    Best Regards,
    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Senin, 01 April 2013 09.48
    Moderator