八風的數位修鍊場

  1. Deadlock常常發生。解決方法 2. gmail SMTP 設定     參考這篇文章      https://www.eztrust.com.tw/webdesign/D/1360

  [SQL Server]檢查DB Lock狀態 執行以下這段SQL可以看到各個資料庫鎖定的狀態及各項資訊 SELECT request_session_id AS spid, resource_type AS rt, resource_databASe_id AS rdb, ( CASE resource_type WHEN 'OBJECT' then object_name(resource_ASsociated_entity_id) WHEN 'DATABASE' then '<db_name>' ELSE ( SELECT object_name(object_id) FROM sys . partitions WHERE hobt_id = resource_ASsociated_entity_id) END ) AS objname, resource_description AS rd, request_mode AS rm, request_status AS rs FROM sys .dm_tran_locks