Read_COMMITTED_SNAPSHOT && size tempdb

  • Hello everyone

    Is there a risk of tempdb saturation if I activate these fuction on my database

    does the shrinkfile always remain functional with this function

    USE [master]
    GO
    ALTER DATABASE [test] SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT
    GO
    ALTER DATABASE [test] SET ALLOW_SNAPSHOT_ISOLATION ON
    GO

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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