June 11, 2010 at 10:28 am
We have performance problem with our SQL Server 2008 – in constant duration of time queries execute very slow. After some research we found that in those moments there are a picks in “Log write waits” counter:
http://www.ematura.com/log2.jpg
Server configuration:
RAM: 72GB (60GB attached to SQL)
CPU: Intel Xeon E5520
DISK: FUSION IO 320 MLC (http://www.fusionio.com/products/iodrive/)
SERWER: HP G6
SYSTEM: Windows Server 2008 R2
SQL: SQL Server 2008
Another interesting thing is behavior of the server when we decrease max memory used by SQL server (from 60GB to 20GB) - picks get smaller amplitude, but they still exists (as a matter of fact those picks are on attached image – when SQL had more memory they were 3 times bigger).
We suspected our flash disk because this is rather rare technology but there is no waits disk queues – and another server similar to this one (only with Windows 2008 – no R2) is working just fine. Any clue what to do?
June 11, 2010 at 3:56 pm
Do you have autogrowth turned on? If so, how much do you increase your log by?
SQL guy and Houston Magician
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply