SQL Server 2008 R2 Service Pack 3 Is Now Available !
Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for download at the Microsoft Support site. SQL Server 2008 R2 Service Pack 3 contains all the hotfixes released since the initial release of SQL Server 2008 R2 RTM.
I suggest to test SQL Server 2008 R2 Service Pack 3 in test environment & then move to Production after satisfactory results.
Cumulative Updates for SQL Server 2008 R2 SP3 will not be released.
KB Article For SQL Server 2008 R2 Service Pack 3
· http://www.microsoft.com/en-us/download/details.aspx?id=44271
Reference : Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN :-
http://www.facebook.com/mssqlfun
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be
Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager.
Steps I perform to resolve the issue, Seems to be a WMI error :-
1) If using Window Server 2008 & above, Run command from command prompt to verify WMI repository : winmgmt /verifyrepository
If you got any error, Please contact your OS team for WMI rebuild.
2) Recompiled the MOF file –> mofcomp.exe "C:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof"
3) Re-registered the SQL Server provider DLL –> regsvr32 "C:Program FilesMicrosoft SQL Server90Sharedsqlmgmprovider.dll"
4) Your issue should be resolved now. If you still face same issue that means there are chances that you may be running with different versions of SQL Server. If yes, Please try to patch SQL Server Management Studio (SSMS) with latest available Service pack.
Reference : Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN :-
http://www.facebook.com/mssqlfun
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
SQL Server Cluster LooksAlive and IsAlive Check
Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and SQL Server level. Heartbeat signals works on UDP.
Microsoft Windows Cluster service perform 2 health checks to perform node & resource availability check.
LooksAlive Health Check
1) LooksAlive is a quick lightweight health check
2) Run at interval of 5 Seconds
3) Does not impact performance but does not perform a thorough check
4) The check will succeed if the service appears to be running even though it might not be operational
5) If Fails calls “IsAlive” health check
6) Polling interval can be changed by adjusting LooksAlivePollInterval property of Cluster service
IsAlive Health Check
1) Run at interval of each 60 Second
2) Perform more detail check then LooksAlive
3) Run @@SERVERNAME to ensure that SQL Server is responding to queries
4) Does not ensure that all user databases are operational
5) Retired 5 times & then try to reconnect SQL Server
6) If all 5 retry fails, the SQL Server resource fails & Windows Cluster service will try to bring it online on other node as per configuration
7) Polling interval can be changed by adjusting IsAlivePollInterval property of Cluster service
Reference : Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN :-
http://www.facebook.com/mssqlfun
http://mssqlfun.com/feed
https://twitter.com/Rgarg86
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
http://beyondrelational.com/members/RohitGarg/default.aspx
Cumulative Update – 12 for SQL Server 2012 Service Pack 1 Is Now Available !
The 12th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.
Those who are facing severe issues with their environment, they can plan to test CU12 in test environment & then move to Production after satisfactory results.
Although, I prefer to have SP2 with latest CU in your environment.
KB Article For CU12 of SQL Server 2012 SP1
- CU#12 KB Article: http://support.microsoft.com/kb/2991533
Previous Cumulative Update KB Articles:
· CU#11 KB Article: http://support.microsoft.com/kb/2975396
· CU#10 KB Article: http://support.microsoft.com/kb/2954099
· CU#9 KB Article: http://support.microsoft.com/kb/2931078
· CU#8 KB Article: http://support.microsoft.com/kb/2917531
· CU#7 KB Article: http://support.microsoft.com/kb/2894115
· CU#6 KB Article: http://support.microsoft.com/kb/2874879
· CU#5 KB Article: http://support.microsoft.com/kb/2861107
· CU#4 KB Article: http://support.microsoft.com/kb/2833645
· CU#3 KB Article: http://support.microsoft.com/kb/2812412
· CU#2 KB Article: http://support.microsoft.com/kb/2790947
· CU#1 KB Article: http://support.microsoft.com/kb/2765331
Reference : Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN :-
http://www.facebook.com/mssqlfun
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
Cumulative Update – 2 for SQL Server 2012 Service Pack 2 Is Now Available !
The 2ndcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.
Those who are facing severe issues with their environment, they can plan to test CU2 in test environment & then move to Production after satisfactory results.
To other, I suggest to wait for SP3 final release to deploy on your production environment, to have consolidate build.
KB Article For CU2 of SQL Server 2012 SP2
- CU#2 KB Article: http://support.microsoft.com/kb/2983175
Previous Cumulative Update KB Articles:
- CU#1 KB Article: http://support.microsoft.com/kb/2976982
Download Link of SQL Server 2012 SP2 :
SQL Server 2012 SP2 : http://www.microsoft.com/en-us/download/details.aspx?id=43340
SQL Server 2012 SP2 EXPRESS : http://www.microsoft.com/en-us/download/details.aspx?id=43351
Reference : Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN :-
http://www.facebook.com/mssqlfun
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx