Our company has multiple computer platforms. One of them is a Dell T3600, and another is a Lenovo S30. Both systems run the same software, and are configured the same as far as I can tell (I actually created the computer images for both systems,
and did all the initial installations). But when we run our application on the Lenovo, database access takes roughly 8 times longer than on the Dell.
I tried to track down the problem, found the resource monitor inside the SQL Server Management Studio. The difference seems to be Logging. In SSMS there is a Logging Resource Wait, which seems to consume all the difference between the two computers.
Additionally, the Windows Performance Monitor lets you measure a lot of details, including Log Write Time, Log Flush Writes Bytes / sec, etc... This also showed a significant increase in the Log Flush Wait Time on the slow computer (all the other
measured values seem are affected, ie l ...
Go to the complete details ...