January 12, 2024 at 12:00 am
Comments posted to this topic are about the item Continuity Across Restarts
January 12, 2024 at 12:04 pm
SQL Server still has sp_procoption so having a proc whose duty is to pre-warm the buffer cache is possible. What would be useful to preload into the buffer cache is probably specific to each organisation. In the OLTP world I would suspect that active product and reference data would be important however I would expect the consuming application to have cached such data for itself.
Perhaps loading the most recent orders would improve the customer experience? It's not easy to answer as it would require a deep knowledge of what data in the buffer cache is needed, for what and what impact its absence has on whom.
I suspect that start up stored procs are of limited value and will go the way of DBCC PINTABLE.
I can see why having a recoverable buffer cache would be useful for Aurora serverless but not for permanently on DB solutions.
January 12, 2024 at 9:52 pm
As fas as which platform might be 'better', that decision might become more and more difficult as your career progresses through the years. Over my 42 years I made heavy use of DB2, DMS, Ingres, and SQL Server and dabbled in a few of the others in the genre of Access and such, along with the front-end languages Cobol, RPG, Visual Basic, etc (when I used Assembler and Autocoder for development we had no database system at all) associated with each and all of them. This introduces the issue of not having been experienced in the 'latest and greatest' of the earlier ones. But we need to be cautious when listening to the claims of any and all providers.
I've earlier mentioned one thing I did through my years. I would go to places such as community colleges to take evening courses in the various genres in order to try to keep myself somewhat updated as things changed. This also was a good supporting move in the event I wanted to move to a position which required such skills. This way I could customize my resume and interviewing according to the needs of the hiring party and would have relatively recent books and documents related to the platform in question. In the early days when I did some front-end development I took the approach of taking evening courses in various systems and programming languages, and these steps were the deciding factor in obtaining one position in particular where a company used Ingres on Unisys and needed someone to begin by supporting a technical design group using Fortran and CAD. At that point Microsoft had a Fortran compiler that served to get me broken in enough to get the position.
That being said, my decided favorite from all the years definitely is SQL Server. And I'll throw in that my least favorite, considering the state of tool development at the time was Ingres. It just seemed to be the least flexible and capable system at that time in my caareer.
Obviously a single college course or two is not going to allow you to delve deeply into an individual system, but it as least accomplishes the basics for gaining insights into a new tool on your own instead of depending on the vendor. But one of the features of this is that the teaching staff may not actually have suficient knowledge and experience to thoroughly prepare you either.
Rick
Disaster Recovery = Backup ( Backup ( Your Backup ) )
January 16, 2024 at 6:57 pm
Kind of related, but some data warehousing platforms like Snowflake support full result-set caching.
https://community.snowflake.com/s/article/Understanding-Result-Caching
I can see this feature as applicable to OLTP databases like SQL Server as well. For example, I've seen more than handful of applications (like Kafka, replication, and even ETL processes) that frequently poll the database on a schedule looking for changes in data. Even when properly indexed the queries take a hit, especially when the interval is every second.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply