更新 SQL SERVER

Use the following table to determine whether your current version of SQL Server already has support for TLS 1.2 or whether you have to download an update to enable TLS 1.2 support. Use the download links in the table to obtain the server updates that are applicable to your environment.
https://support.microsoft.com/en-us/kb/3135244

SQL Server 2014 SP1

12.0.4439.1

Cumulative Update 5 for SQL Server 2014 SP1

KB 3052404 FIX: You cannot use the Transport Layer Security protocol version 1.2 to connect to a server that is running SQL Server 2014 or SQL Server 2012

查看blocking現像

SELECT * FROM sys.sysprocesses  s
CROSS APPLY sys.dm_exec_sql_text(sql_handle)
WHERE s.blocked > 0

查看SQL Server Profiler檔案

使用SQL Server Profiler產生d:\20160615.TRC後，使用下列語法查看內容
SELECT *
FROM fn_trace_gettable
('d:\20160615.TRC',DEFAULT)
ORDER BY CPU DESC