Forum Replies Created

Viewing 3 posts - 16 through 19 (of 19 total)

  • RE: Shrink Database Log files (Full recovery mode)

    temp I m using following query to manage DB size (but this is not a proper solution)

    ========================================

    USE Database_name;

    GO

    – Truncate the log by changing the database recovery model to SIMPLE.

    ALTER DATABASE...

  • RE: Scripts

    Thanks for the replay.

    I just want to know that If I run in our other SQL servers, what will be the counter values required my attention.

    I mean counter value range...

  • RE: Scripts

    Hi;

    Thanks for the query to check "BufferCacheHitRatio" & "PageLifeExpectancyInSeconds". below is the result of my one SQL 2005 server, can u please advice action to enhance server performance as per...

Viewing 3 posts - 16 through 19 (of 19 total)