October 4, 2006 at 12:28 pm
Hello,
The question that I have is this...I have a group of database servers that our vendor wants set to Simple recovery mode. Our standard does not allow this. The vendor claims that this is the cause of our slowness in their application. My argument is that all transactions are logged, even in simple mode. The only difference is that they are flushed from the log quicker. If the transaction log is properly sized and not fragmented on disk this shouldn't really matter much for performance. I understand that if the file fills up and needs to grow that will affect the performance.
Am I right about this? Or am I misunderstanding something about the way that SQL works?
Thanks,
Brian
October 5, 2006 at 1:29 am
In a nutshell you're correct and the vendor is talking out of his/her *&%$£ , however, if you don't actually need transaction logs and you're not making transaction log backups then I'd say put the database(s) into simple.
I guess if the backup drive and transaction log drive are not seperated from the data drive it might be feasible to infer the transaction log activity woould slow the server down, but that's a hardware issue.
Note that growths of devices during operations do degrade performance, I always attempt to reduce any growths of devices to an absolute minimum.
I just love application vendors and I will have to add this claim to my list of memorable statements!!!! Ask them if their app runs on Oracle and if they make the same suggestion.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
October 5, 2006 at 5:32 am
Colin is right (as normal...) If your vendor insists on showing their ignorance in this way, ask them to give you some benchmark statistics to prove what they are saying is true.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply