Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2014-04-01 : 12:05:41
|
| This is 2014 related but there isn't a forum for it yet even though it was officially released hours ago ;)I've been reading about the new buffer pool extension in 2014...http://www.sqlpassion.at/archive/2014/03/11/buffer-pool-extensions-in-sql-server-2014/And have a question...If I create a buffer pool extension on an ephemeral SSD (in AWS) and that SSD is lost does that impact my disaster recover plan? What are the consequences of losing the buffer pools on database operation and restoration?Thanks. |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2014-04-02 : 17:36:58
|
| Found my answer..."What does it mean that there is no risk of data loss? BPE only processes clean pages, which ensures that all data in the extension is already committed. Machine crash or power failure? No additional risk compared to the data in memory. What about SSD storage failure? The feature disables itself automatically and can be either re-enabled manually in the same session or attempts to re-enable automatically on instance restart."http://blogs.technet.com/b/dataplatforminsider/archive/2013/07/25/buffer-pool-extension-to-ssds-in-sql-server-2014.aspx |
 |
|
|
|
|
|
buffer pool extensions and drp