Microsoft and Oracle SQL systems performance and tuning
by Mountain Computers Inc, Publication Date: Saturday, February 25, 2023
View Count: 179, Keywords: Microsoft, Oracle, SQL, Tuning, Performance, Hashtags: #Microsoft #Oracle #SQL #Tuning #Performance
In the last few years, I have witnessed several SQL database architectures that have been, shall I say, out of balance, not normalized nor indexed properly or basically in terms of database refactoring.
For me, it's easy to see when you have some SQL execution plan, trace logs, I/O metrics, all of that in front of you, both in production and test, and you are puzzled as to why the performance is so slow; yes, "so slow" is a valid KPI term. Expectations aside, I prefer data to be processed within chucks and batches, not linear.
a funny note: when I see slow performing systems, I ask myself, it there some sort of debugging enabled as to interfere with production? It means, when you enabled debugging and logging, it sometimes quadruples or more the processing throughput and performance, killing the streamlined optimization that currently exists.
What does that mean? I prefer to analyze the execution plan results and explore the data schema within it.
Soon, you realize, wow, how did this happen and then you go about fixing it. How does one go about doing that?
First, Ask questions (don't make statements), and show observations, explore the history of why things are the way they are, and if no one has a valid idea, then make suggestions, and then based on everyone's nod of acceptance, backup your architecture, complete the changes in your test environment (and if you don't have one, figure out to make one inexpensively and in your licensing compliance), and then implement the change, look for positive results, and hope nothing breaks. If all goes well, implement in production in between any and all things important that is already on the schedule.
I know that's a long paragraph above, yet its comprehensible. I'll drop in some references shortly.
side-note of the day:
more to come...
if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.
© 2023 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.