Home » Windows Cluster
Category Archives: Windows Cluster
What’s new in SQL Server 2016 installation?
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules it will automatically moves to Next window. 2) On Server Configuration page, MS specifically ask to GRANT PERFORM VOLUME MAINTENANCE TASK permission to service account. SQL Services needs this access to perform instant file initialization … Continue reading
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) … Continue reading
Renaming or Changing SQL Server Cluster Instance
Renaming or Changing SQL Server cluster instance process is bit different from renaming a stand-alone instance. Refer : Rename or Change SQL Server Standalone Default Instance http://mssqlfun.com/2014/06/30/rename-or-change-sql-server-standalone-default-instance/) Refer : Rename or Change SQL Server Standalone Named Instance (http://mssqlfun.com/2014/07/29/rename-or-change-sql-server-standalone-named-instance/) The name of the virtual server is always the same as the name of the SQL Network … Continue reading
Add Node to Windows Server 2008 Cluster
Steps : Add Node to Windows Server 2008 Cluster 1) Open Cluster Administration wizard > Right click on Windows Cluster & select Add Node 2) Add Node Wizard appears, Click Next to start 3) Browse Node to add, We select Node 3 to add 4) Select if you want to validate cluster settings or not … Continue reading
Thanks to Toadworld.com team for recognition !
Thanks to Toadworld.com team for recognition ! Toadworld.com Profile : http://www.toadworld.com/members/rohit-garg/blogs/default.aspx If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun Reference : Rohit Garg (http://mssqlfun.com/)