Ad hoc query stubs in plan cache

VN:RO [1.9.17_1161]
Rating: 4.0/5 (1 vote cast)
6,140 0 ,
This metric measures the total number of one-time use ad hoc queries in the plan cache that have been stored in the form of a stub, not as a full execution plan. Read more

WriteLog wait time

VN:RO [1.9.17_1161]
Rating: 5.0/5 (2 votes cast)
20,220 0 ,
During a transaction, data is written to the log cache so that it’s ready to be written to the log file on commit, or can be rolled back if necessary. When the log cache is being flushed to disk, the SQL Server session will wait on the WriteLog wait type. Read more