Performance problem - Log write waits?

  • 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?

  • 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