June 12, 2017 at 4:38 am
I believe the three scenarios ,Node down or Failover or Service Stop,I can think off will clear the buffer cache and reinitiliaze the tempdb . I am right or missing something?
June 12, 2017 at 4:53 am
anytime the sql server service goes offline the cache will be lost
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 13, 2017 at 4:40 am
Perry Whittle - Monday, June 12, 2017 4:53 AManytime the sql server service goes offline the cache will be lost
Thanks Perry.
So all mentioned scenarios causes clear cache.
June 13, 2017 at 4:58 am
Rechana Rajan - Tuesday, June 13, 2017 4:40 AMPerry Whittle - Monday, June 12, 2017 4:53 AManytime the sql server service goes offline the cache will be lostThanks Perry.
So all mentioned scenarios causes clear cache.
as they all take the service offline, yes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 13, 2017 at 6:02 am
Perry Whittle - Tuesday, June 13, 2017 4:58 AMRechana Rajan - Tuesday, June 13, 2017 4:40 AMPerry Whittle - Monday, June 12, 2017 4:53 AManytime the sql server service goes offline the cache will be lostThanks Perry.
So all mentioned scenarios causes clear cache.
as they all take the service offline, yes
Thanks Perry
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply