You are viewing limited content. For full access, please sign in.

Question

Question

SQL writelog wait time

asked on February 8, 2016 • Show version history

Dears,

 

One of our customers is facing a long SQL writelog wait time, their DB admin is suggesting the below:

"COMMIT TRAN can help in these situations but this is related to the code within the application."

http://blogs.msdn.com/b/sqlsakthi/archive/2011/04/17/what-is-writelog-waittype-and-how-to-troubleshoot-and-fix-this-wait-in-sql-server.aspx

kindly advise if the above is applicable.

Thanks

 

 

0 0

Replies

replied on February 16, 2016

The above isn't applicable. Try moving the LDF file to a faster disk. If it's already on a very fast disk, then you can open a support case and we'll diagnose what the problem is.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.