WRITELOG waittype - Implicit vs. Explicit Transaction: disk or coding issue?
'In a OLTP system where concurrency is high observing WRITELOG waittype is normal for a short period of time during peak usage. Generally, a high value of this waittype indicates slow response of the application. So, observing this waittype for a longer period of time and repeatedly for DML operations such as MERGE, INSERT, UPDATE and DELETE, obviously this indicates two specific issues:
- Disk I/O sub-system
- Transaction handing'...
http://sqltouch.blogspot.de/2013/05/writelog-waittype-implicit-vs-explicit.html
Trackbacks
Keine Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt