SQL server versions , packs ,Builds and new patches release dates.

 

SQL Server 2012
11.0.2316	SQL Server 2012 CU1	12 Apr 2012
11.0.2100.6	SQL Server 2012 RTM	7 Mar 2012
SQL Server 2008 R2
10.50.2811	SQL Server 2008 R2 SP1 CU6	16 Apr 2012
10.50.2806	SQL Server 2008 R2 SP1 CU5	22 Feb 2012
10.50.2796	SQL Server 2008 R2 SP1 CU4	9 Jan 2012
10.50.2789.0	SQL Server 2008 R2 SP1 CU3	17 Oct 2011
10.50.2772.0	SQL Server 2008 R2 SP1 CU2	16 Aug 2011
10.50.2769.0	SQL Server 2008 R2 SP1 CU1	16 Sep 2011
10.50.2500.0	SQL Server 2008 R2 SP1	11 Jul 2011
10.50.1815	SQL Server 2008 R2 CU13	17 Apr 2012
10.50.1810	SQL Server 2008 R2 CU12	21 Feb 2012
10.50.1809	SQL Server 2008 R2 CU11	9 Jan 2012
10.50.1807.0	SQL Server 2008 R2 CU10	19 Oct 2011
10.50.1804.0	SQL Server 2008 R2 CU9	23 Aug 2011
10.50.1797.0	SQL Server 2008 R2 CU8	16 Sep 2011
10.50.1777.0	SQL Server 2008 R2 CU7	16 Jun 2011
10.50.1765.0	SQL Server 2008 R2 CU6	21 Feb 2011
10.50.1753.0	SQL Server 2008 R2 CU5	20 Dec 2010
10.50.1746.0	SQL Server 2008 R2 CU4	18 Oct 2010
10.50.1734.0	SQL Server 2008 R2 CU3	17 Aug 2010
10.50.1720.0	SQL Server 2008 R2 CU2	25 Jun 2010
10.50.1702.0	SQL Server 2008 R2 CU1	18 May 2010
10.50.1600.1	SQL Server 2008 R2 RTM	12 Apr 2010
SQL Server 2008
10.00.5775	SQL Server 2008 SP3 CU4	20 Mar 2012
10.00.5770	SQL Server 2008 SP3 CU3	16 Jan 2012
10.00.5768	SQL Server 2008 SP3 CU2	22 Nov 2011
10.00.5766	SQL Server 2008 SP3 CU1	18 Oct 2011
10.00.5500	SQL Server 2008 SP3	6 Oct 2011
10.00.4330	SQL Server 2008 SP2 CU9	19 Mar 2012
10.00.4326	SQL Server 2008 SP2 CU8	30 Jan 2012
10.00.4323	SQL Server 2008 SP2 CU7	21 Nov 2011
10.00.4321	SQL Server 2008 SP2 CU6	20 Sep 2011
10.00.4316	SQL Server 2008 SP2 CU5	18 Jul 2011
10.00.4285	SQL Server 2008 SP2 CU4	16 May 2011
10.00.4279	SQL Server 2008 SP2 CU3	21 Mar 2011
10.00.4272	SQL Server 2008 SP2 CU2	17 Jan 2011
10.00.4266	SQL Server 2008 SP2 CU1	15 Nov 2010
10.00.4000	SQL Server 2008 SP2	29 Sep 2010
10.00.2850	SQL Server 2008 SP1 CU16	19 Sep 2011
10.00.2847	SQL Server 2008 SP1 CU15	18 Jul 2011
10.00.2816	SQL Server 2008 SP1 CU13	22 Mar 2011
10.00.2812	SQL Server 2008 SP1 CU14	16 May 2011
10.00.2808	SQL Server 2008 SP1 CU12	17 Jan 2011
10.00.2804	SQL Server 2008 SP1 CU11	15 Nov 2010
10.00.2799	SQL Server 2008 SP1 CU10	21 Sep 2010
10.00.2789	SQL Server 2008 SP1 CU9	19 Jul 2010
10.00.2775	SQL Server 2008 SP1 CU8	17 May 2010
10.00.2766	SQL Server 2008 SP1 CU7	15 Mar 2010
10.00.2757	SQL Server 2008 SP1 CU6	18 Jan 2010
10.00.2746	SQL Server 2008 SP1 CU5	24 Nov 2009
10.00.2734	SQL Server 2008 SP1 CU4	22 Sep 2009
10.00.2723	SQL Server 2008 SP1 CU3	21 Jul 2009
10.00.2714	SQL Server 2008 SP1 CU2	18 May 2009
10.00.2710	SQL Server 2008 SP1 CU1	16 Apr 2009
10.00.2531	SQL Server 2008 SP1	7 Apr 2009
10.00.1835	SQL Server 2008 RTM CU10	15 Mar 2010
10.00.1828	SQL Server 2008 RTM CU9	18 Jan 2009
10.00.1823	SQL Server 2008 RTM CU8	16 Nov 2009
10.00.1818	SQL Server 2008 RTM CU7	21 Sep 2009
10.00.1812	SQL Server 2008 RTM CU6	21 Jul 2009
10.00.1806	SQL Server 2008 RTM CU5	18 May 2009
10.00.1798	SQL Server 2008 RTM CU4	17 Mar 2009
10.00.1787	SQL Server 2008 RTM CU3	19 Jan 2009
10.00.1779	SQL Server 2008 RTM CU2	17 Nov 2008
10.00.1763	SQL Server 2008 RTM CU1	22 Sep 2008
10.00.1600	SQL Server 2008 RTM	6 Aug 2008
SQL Server 2005
9.00.5266	SQL Server 2005 SP4 CU3	21 Mar 2011
9.00.5259	SQL Server 2005 SP4 CU2	22 Feb 2011
9.00.5254	SQL Server 2005 SP4 CU1	20 Dec 2010
9.00.5000	SQL Server 2005 SP4	17 Dec 2010
9.00.4325	SQL Server 2005 SP3 CU15	21 Mar 2011
9.00.4317	SQL Server 2005 SP3 CU14	21 Feb 2011
9.00.4315	SQL Server 2005 SP3 CU13	20 Dec 2010
9.00.4311	SQL Server 2005 SP3 CU12	18 Oct 2010
9.00.4309	SQL Server 2005 SP3 CU11	17 Aug 2010
9.00.4305	SQL Server 2005 SP3 CU10	23 Jun 2010
9.00.4294	SQL Server 2005 SP3 CU9	19 Apr 2010
9.00.4285	SQL Server 2005 SP3 CU8	16 Feb 2010
9.00.4273	SQL Server 2005 SP3 CU7	21 Dec 2009
9.00.4266	SQL Server 2005 SP3 CU6	19 Oct 2009
9.00.4230	SQL Server 2005 SP3 CU5	17 Aug 2009
9.00.4226	SQL Server 2005 SP3 CU4	16 Jun 2009
9.00.4220	SQL Server 2005 SP3 CU3	21 Apr 2009
9.00.4211	SQL Server 2005 SP3 CU2	17 Feb 2009
9.00.4207	SQL Server 2005 SP3 CU1	20 Dec 2008
9.00.4053	SQL Server 2005 SP3 GDR (Security Update)	13 Oct 2009
9.00.4035	SQL Server 2005 SP3	16 Dec 2008
9.00.3356	SQL Server 2005 SP2 CU17	21 Dec 2009
9.00.3355	SQL Server 2005 SP2 CU16	19 Oct 2009
9.00.3330	SQL Server 2005 SP2 CU15	18 Aug 2009
9.00.3328	SQL Server 2005 SP2 CU14	16 Jun 2009
9.00.3325	SQL Server 2005 SP2 CU13	21 Apr 2009
9.00.3315	SQL Server 2005 SP2 CU12	17 Feb 2009
9.00.3310	SQL Server 2005 SP2 Security Update	10 Feb 2009
9.00.3301	SQL Server 2005 SP2 CU11	15 Dec 2008
9.00.3294	SQL Server 2005 SP2 CU10	20 Oct 2008
9.00.3282	SQL Server 2005 SP2 CU9	18 Aug 2008
9.00.3257	SQL Server 2005 SP2 CU8	16 Jun 2008
9.00.3239	SQL Server 2005 SP2 CU7	14 Apr 2008
9.00.3233	SQL Server 2005 QFE Security Hotfix	8 Jul 2008
9.00.3228	SQL Server 2005 SP2 CU6	18 Feb 2008
9.00.3215	SQL Server 2005 SP2 CU5	17 Dec 2007
9.00.3200	SQL Server 2005 SP2 CU4	15 Oct 2007
9.00.3186	SQL Server 2005 SP2 CU3	20 Aug 2007
9.00.3175	SQL Server 2005 SP2 CU2	28 Jun 2007
9.00.3161	SQL Server 2005 SP2 CU1	15 Apr 2007
9.00.3152	SQL Server 2005 SP2 Cumulative Hotfix	7 Mar 2007
9.00.3077	SQL Server 2005 Security Update	10 Feb 2009
9.00.3054	SQL Server 2005 KB934458	5 Apr 2007
9.00.3042.01	SQL Server 2005 "SP2a"	5 Mar 2007
9.00.3042	SQL Server 2005 SP2	1 Feb 2007
9.00.2047	SQL Server 2005 SP1
9.00.1399	SQL Server 2005 RTM	1 Nov 2005

Configuring Deadlock Alert

/* Configuring Deadlock Alert on PRD servers.*/.

 

/* Step 1  -- Enable Trace Flag 1222 to 1 to capture deadlock information  in log files

Note: Trace flag will be reset after every SQL server reset so we need to enable flag after every SQL services restart or configure at startup parameter

*/

/* Step 2 --  Creating an Deadlock Alert and Trigger the Deadlock Job

USE [msdb]

GO

/****** Object:  Alert [DeadLock Alert]    Script Date: 05/16/2012 23:28:16 ******/

EXEC msdb.dbo.sp_add_alert @name=N'DeadLock Alert',

@message_id=0,

@severity=0,

@enabled=1,

@delay_between_responses=0,

@include_event_description_in=1,

@category_name=N'[Uncategorized]',

@performance_condition=N'SQLServer:Locks|Number of Deadlocks/sec|_Total|>|0',

@job_id=N'8a31ce05-3880-4fa4-a020-0263135d0129'

--Job ID needs to be replaced

GO

*/

/* -- Step 3.Create an new job and place an below Query in Job Step*/

/*--Create an temporary table  to capture the data from the log file */

IF OBJECT_ID('tempdb.dbo.ErrorLog') IS Not Null

BEGIN

DROP TABLE tempdb.dbo.ErrorLog

END

CREATE TABLE tempdb.dbo.ErrorLog

(Id int IDENTITY (1, 1) NOT NULL,

logdate DATETIME, procInfo VARCHAR(10),

ERRORLOG VARCHAR(MAX))

/*--Insert the data into errorlog table  from logs using SP_readerrorlog.*/

INSERT INTO tempdb.dbo.ErrorLog

EXEC master.dbo.sp_readerrorlog

/*--Query to execute the alert using DB mail */

BEGIN

DECLARE @servername nvarchar(150)

SET @servername = @@servername

DECLARE @mysubject nvarchar(200)

SET @mysubject = 'Deadlock event notification on server '+@servername+'.'

/* --Use this query in SQl 2000

--IF EXISTS(select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog

where Id >=(select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like '%Deadlock encountered%' 

order by Id DESC))

--BEGIN

-- EXEC msdb.dbo.sp_send_dbmail

-- @profile_name ='DB Mail Profile',

-- @recipients='Deadlock@Gmail.com;Perfteam@Gmail.com ',

-- @subject = @mysubject,

-- @body = 'Deadlock has occurred. View attachment to see the deadlock info',

-- @query = 'select logdate, procInfo, ERRORLOG from tempdb.dbo.ErrorLog where Id >= (select TOP 1 Id from tempdb.dbo.ErrorLog WHERE ERRORLOG Like ''%Deadlock encountered%''  order by Id DESC)

  --   and convert(varchar,logdate,112)=convert(varchar,getutcdate(),112)',

-- @query_result_width = 600,

-- @attach_query_result_as_file = 1,

-- @importance='HIGH'

*/

/* Below query is applicable for SQL 2005 higher versions*/

IF EXISTS(

SELECT TOP 1 B.PROCINFO FROM TEMPDB.DBO.ERRORLOG B ,

(SELECT TOP 1 A.LOGDATE, A.PROCINFO FROM TEMPDB.DBO.ERRORLOG A

WHERE A.ERRORLOG LIKE '%Deadlock%' and A.ERRORLOG not like '%EXEC dbo.proc_MSS%'

--AND CONVERT(VARCHAR,A.LOGDATE,112)=CONVERT(VARCHAR,GETUTCDATE(),112)

ORDER BY A.PROCINFO DESC

)A  WHERE B.LOGDATE=A.LOGDATE AND B.PROCINFO=A.PROCINFO

)

/* Above query is used to find the deadlock in the Errolog table if deadlock exists then below DB Mail Script will be execute with captured deadlock information and will send the mail*/

BEGIN

EXEC msdb.dbo.sp_send_dbmail

@profile_name ='DB Mail Profile',

@recipients='Deadlock@Gmail.com',

@copy_recipients='Perfteam@slk-soft.com',

@subject = @mysubject,

@body = 'Deadlock has occurred. View attachment to see the deadlock info',

/*Actual Query to get the deadlock information and send the information via mail*/

@query = 'SELECT B.* FROM TEMPDB.DBO.ERRORLOG B ,

(SELECT TOP 1 A.LOGDATE, A.PROCINFO FROM TEMPDB.DBO.ERRORLOG A

WHERE A.ERRORLOG LIKE ''%Deadlock%''

--AND CONVERT(VARCHAR,A.LOGDATE,112)=CONVERT(VARCHAR,GETUTCDATE(),112)

ORDER BY A.PROCINFO DESC

)A

WHERE B.LOGDATE=A.LOGDATE AND B.PROCINFO=A.PROCINFO ORDER BY 1',

@query_result_width = 600,

@attach_query_result_as_file = 1,

@importance='HIGH'

END

END

DROP TABLE tempdb.dbo.ErrorLog