LOCK_ESCALATION Disable 이슈 및 RowLock 힌트로 인한 슬로우 쿼리 발생 가능.
https://www.littlekendra.com/2016/02/04/why-rowlock-hints-can-make-queries-slower-and-blocking-worse-in-sql-server/



저작자 표시
신고


https://svenaelterman.wordpress.com/2016/05/23/performing-a-silent-install-of-sql-server-management-studio-2016/


SQL2016 SSMS 한방에 설치하기^^ 


SSMS-Setup-KOR.exe /install /passive /quiet /norestart

저작자 표시
신고


Because this data is available in real time without needing to wait for the query to complete, these execution statistics are extremely useful for debugging query performance issues.

https://msdn.microsoft.com/en-us/library/dn831878(v=sql.130).aspx

Live Query Stats button in showplan

신고