SQL server 高速缓存 关机后 高速缓存的数据会不会丢失？？

Question

高速缓存既然没写到磁盘里 那么关机后这些数据会不会丢失？
SQL server本身的高速缓存

Answer 1

I just think you question did not descript well what you want to ask.

I have some questions:

What kinds of cache?

What the cashe want to do?

What kinds of data in cashe?

 

 

Answer 2

Which cache? In cpu or on disk controller?

Answer 3

不知道你说的高速缓存是指什么.CPU，磁盘都是有cache的。不过,已提交的事务,会全部写入日志文件.只要磁盘不出问题,意外关机不会影响数据.

---

想不想时已是想，不如不想都不想。