SQL Server support lifecycle 技術支援 產品週期

SQL Server support lifecycle 技術支援 產品週期

Products Released	Lifecycle Start Date	Mainstream Support End Date	Extended Support End Date	Service Pack Support End Date
SQL Server 2000 Service Pack 4	5/6/2005	4/8/2008	4/9/2013
SQL Server 2005	1/14/2006	Not Applicable	Not Applicable	7/10/2007
SQL Server 2005 Service Pack 4	12/13/2010	4/12/2011	4/12/2016
SQL Server 2008	11/7/2008	Not Applicable	Not Applicable	4/13/2010
SQL Server 2008 Service Pack 1	3/31/2009	Not Applicable	Not Applicable	10/11/2011
SQL Server 2008 Service Pack 2	9/24/2010	Not Applicable	Not Applicable	10/9/2012
SQL Server 2008 Service Pack 3	10/6/2011	Not Applicable	Not Applicable	10/13/2015
SQL Server 2008 Service Pack 4	7/7/2014	7/8/2014	7/9/2019
SQL Server 2008 R2	7/20/2010	Not Applicable	Not Applicable	7/10/2012
SQL Server 2008 R2 Service Pack 1	7/12/2011	Not Applicable	Not Applicable	10/8/2013
SQL Server 2008 R2 Service Pack 2	7/26/2012	Not Applicable	Not Applicable	10/13/2015
SQL Server 2008 R2 Service Pack 3	Review Note	7/8/2014	7/9/2019
SQL Server 2012	5/20/2012	Not Applicable	Not Applicable	1/14/2014
SQL Server 2012 Service Pack 1	11/7/2012	Not Applicable	Not Applicable	7/14/2015
SQL Server 2012 Service Pack 2	6/10/2014	Not Applicable	Not Applicable	1/10/2017
SQL Server 2012 Service Pack 3	12/1/2015	Not Applicable	Not Applicable	10/9/2018
SQL Server 2012 Service Pack 4	Review Note	7/11/2017	7/12/2022
SQL Server 2014	6/5/2014	Not Applicable	Not Applicable	7/12/2016
SQL Server 2014 Service Pack 1	4/14/2015	Not Applicable	Not Applicable	10/10/2017
SQL Server 2014 Service Pack 2	7/14/2016	Not Applicable	Not Applicable	1/14/2020
SQL Server 2014 Service Pack 3	10/30/2018	7/9/2019	7/9/2024
SQL Server 2016	6/1/2016	Not Applicable	Not Applicable	1/9/2018
SQL Server 2016 Service Pack 2	4/24/2018	7/13/2021	7/14/2026

SQL Server Support Lifecycle
https://support.microsoft.com/en-us/lifecycle/search/1044

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 not been marked as distributed. This stored procedure is executed at the Publisher on a publication database.
只回傳交易序號

sp_replcmds (Transact-SQL)
Returns the commands for transactions marked for replication. This stored procedure is executed at the Publisher on the publication database.
sp_replcmds is used by the log reader process in transactional replication.

將交易轉成SQL命令回傳

sp_replcmds @maxtrans = 500
GO
sp_replflush
GO

sp_replshowcmds (Transact-SQL)
Returns the commands for transactions marked for replication in readable format. sp_replshowcmds can be run only when client connections (including the current connection) are not reading replicated transactions from the log. This stored procedure is executed at the Publisher on the publication database.

將交易轉成易讀的SQL命令回傳

sp_replshowcmds @maxtrans = 500
GO
sp_replflush
GO

sp_replcmds @maxtrans = 500 -- retrieve 500 pending transactions
GO
SELECT dbid, begin_lsn, commit_lsn, rows, cmds_in_tran
FROM sys.dm_repl_traninfo
GO

SELECT count(*) FROM ::fn_dblog(NULL, NULL)
GO
-- Records marked for REPLICATION
SELECT count(*) FROM ::fn_dblog(NULL, NULL) WHERE Description='REPLICATE'
GO

從散發資料庫讀取
[Distributor]
sp_browsereplcmds (Transact-SQL)
Returns a result set in a readable version of the replicated commands stored in the distribution database, and is used as a diagnostic tool. This stored procedure is executed at the Distributor on the distribution database.

從散發資料庫讀取暫存的交易SQL命令

[Reference]

Transactional Replication Conversations

Transactional Replication Conversations

Microsoft SQL Server Replication Web Sites you may want to visit
https://blogs.msdn.microsoft.com/chrissk/2010/03/14/microsoft-sql-server-replication-web-sites-you-may-want-to-visit/

SQL Server Management Studio default locations 執行檔預設路徑與位置

SQL Server Management Studio default locations
執行檔預設路徑與位置


SQL Server 2014
C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe
SQL Server 2012
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe
SQL Server 2008 R2
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe
SQL Server 2005
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe