February 26, 2011 at 12:31 pm
Dear All,
I have a Database that is set to a Simple Recovery Model, some days there are queries that are run (more like transactional queries), I find that after they are run the Server becomes drastically very slow.
I want to find out a way of knowing:
1. The size in which the Transaction Log file is set
2. When to truncate the log files in order to free up space, therefore the the server performance is "good enough"
3. If truncation of log files often is a good practice
4. How often, if any should I be Backing up the log files.
If there are any other areas I should be looking at to improve the Server performance, I would be very grateful if you would pass on your knowledge.
Thank you.
February 26, 2011 at 4:43 pm
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1070069-5-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply