![]() ![]() SSDs are cheap, and they’re only getting cheaper and faster. This works with local SSDs in clusters, too – each node can have its own local SSDs (just like you would with TempDB) and preserve the SAN throughput for the data and log files. (Only clean pages, not dirty pages, are stored there.) The best use case is for read-heavy OLTP workloads. ![]() SQL Server 2014 will automatically cache data there with zero risk of data loss. You can specify an SSD (or an SSD array) to be used to extend memory. They haven’t announced the licensing/pricing, but I’ll tell you what I do know so far.įirst, open this in another tab and hit play so you’ve got some background music while you read. Done with the commercial? Okay, let’s get to it:Ĭache frequently used data on SSDs. Just when you thought SQL Server couldn’t get better, Microsoft is announcing the features for SQL Server 2014.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |