March 14, 2013 at 6:30 am
Hello,
I would like to ask for some insights about SQL Server Clustering. When you fail over an instance to another node, does the cache also gets reset?
Thank you.
March 14, 2013 at 6:46 am
Failing over a clustered instance is, in effect, stopping it on one node and starting it again on another. So you should expect everything that happens when you stop SQL Server to happen also when you fail it over.
John
March 14, 2013 at 6:47 am
A failover involved SQL starting cold on the second node. There's no memory transfer, the databases are shared but that's all.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 14, 2013 at 7:33 am
Thanks for the quick reply guys.
That's what I thought at first but I really wanted to get the opinion of experts like you guys. I'm new to this clustering thing. I'm glad there's a lot of kind experts here willing to share their knowledge.
Thank you.
March 16, 2013 at 7:57 am
The shared databases represent only the upper layer of the shared objects. At the base level, each cluster node that is part of the failover instance shares the virtual IP, virtual network name and the storage disks too. Upon failover the network name and IP are ubound from the current active node and transferred\bound to the failover partner. The storage layer is also transferred to the new partner and all resources are brought online in a defined order, which is as follows
first
storage
virtual IP
second
virtual network name
third
SQL server service
fourth
SQL server agent service
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy