Viewing 3 posts - 16 through 19 (of 19 total)
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...
May 4, 2011 at 4:05 am
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...
May 4, 2011 at 2:04 am
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...
May 3, 2011 at 10:48 pm
Viewing 3 posts - 16 through 19 (of 19 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy