Does Cluster Failover Clear the Procedure Cache?

• David Goldstein-450388

  SSC Veteran

  Points: 215

  More actions

  September 11, 2008 at 12:12 pm

  #123517

  Hi,

  If I have a SQL Server cluster consisting of 2 nodes, and I first reboot the inactive node followed by the other node, will the procedure cache be cleared?

  Thanks,

  -Dave

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  September 11, 2008 at 12:22 pm

  #870569

  Yes, the procedure cache is in memory so it is tied to the active node.

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  September 11, 2008 at 12:27 pm

  #870573

  When a cluster failover happens, what the cluster does is the following:

  - Stops all services dependent on SQL Server

  - Stops SQL Server

  - Stops the IP and Network name resources

  - Stops the connection to the drives

  - Starts the connect to the drives on the new node

  - Starts the IP and Network name resources on the new node

  - Starts SQL Server on the new node

  - Starts all dependent services on the new node

  Since you have a service stop and start, all cached memory is gone. In this case you have a service stop and start across different physical systems.

  K. Brian Kelley
  @kbriankelley