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...

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...

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...