Found a very interesting bit of information about SQL Standard Edition's 128GB limit, and how it still might exploited with persistant memory, without it affecting the 128GB limit. Needs a bit more use case decoding, but here it is:
All releases of SQL Standard edition restrict the buffer...
My understanding is that Optane SCM DIMMS are useed in block mode require no changes to the software stack, while still reaping a 10X improvement vs NVMe, where as to get 100x improvement you have to use DAX mode which does require a change to the underlying software. There's certainly no limit...
128GB RAM is already maxed out (it's the limit allowed by the version of SQL Server each OLTP database server uses) which is why I mentioned 128GB being the limit. I guess it really doesn't matter if we almost never restart the servers and flush the hot cached data off RAM, but this isn't going...
Up to 500 GB of structured data (unstructured files and images are going to be on NVMe drives anyways, and would be considered cold data), so small potatoes by "Big Data" standards, but big enough to create havoc when dealing with hundreds of tables, thousands of joins, and indexes galore to...
Yes but neither of these are the priority, nor in the parameters of my question. The focus of the question isn't max RAM (again, in my spec, the limit is 128GB) nor validation. The question is all about random access performance of pages against a SQL Server database, and the latency it takes...
Say you're thinking of upgrading your servers and you're goal is fast access to SQL Server data (Database with lots of joins and tables rendering web pages over the web). In this case your ceiling of RAM will be 128GB.
While I appreciate the raw power and value of Epyc vs Xeon, it seems to me...
I'm having trouble understanding the difference in drive write reliability rating vs cost. Assume I have a SQL Server app doing heaving OLTP workloads. Database size is say 500 GB.
Now assume you need to upgrade your database server. Wouldn't it be the same in terms of endurance if I shopped...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.