複寫疑難排解 Replication Troubleshooting

複寫疑難排解 Replication Troubleshooting   從TLog讀取 sp_replcounters (Transact-SQL) Returns replication statistics about latency, throughput, and transaction count for each published database. This stored procedure is executed at the Publisher on any database. sp_replcounters sp_repltrans (Transact-SQL) Returns a result set of all the transactions in the publication database transaction log that are marked for replication but have…


複寫監控 Monitor Replication

複寫監控 Monitor Replication Measure Latency and Validate Connections for Transactional Replication 使用Tracer Token監控複寫延遲 保留延遲紀錄作法請參考我這篇   Programmatically Monitor Replication–Programmatically Monitor Replication USE [distribution] GO sp_replmonitorhelppublisher GO sp_replmonitorhelppublisher (Transact-SQL) USE [distribution] GO sp_replmonitorhelppublication @publisher = N’SQLDEV1′ GO sp_replmonitorhelppublication (Transact-SQL) USE [distribution] GO sp_replmonitorhelpsubscription @publisher = N’SQLDEV1′, @publication_type = 0 GO sp_replmonitorhelpsubscription (Transact-SQL) USE [distribution] GO sp_replmonitorsubscriptionpendingcmds @publisher…


SQL Server 2008 R2 Management Studio – Darker Shades of Blue Theme

SQL Server 2008 R2 Management Studio – Darker Shades of Blue Theme SSMS 2008 R2 套用Visual Studio色彩佈景主題環境設定檔 SQL 2012 SSMS以上才支援匯出與匯入環境設定檔 SQL 2008 R2 SSMS需自行調整字型與色彩,以下方法可以直接套用已經設定好的色彩佈景主題   1.Download: CurrentSettings-2016-07-12.vssettings 2.覆蓋以下檔案 預設路徑 C:\Documents and Settings\{user name}\Documents\SQL Server Management Studio\Settings\ CurrentSettings-2016-xx-xx.vssettings 3.重開SSMS就可以套用成功 Reference: SQL Server 2012 Management Studio – Darker Shades of Blue Theme Making SSMS Pretty : My…