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.