Hello all
Hope you're doing well!
As I said here, I've
created a repository on GITHUB to share some
scripts that I like to make and that help me in my day-to-day life as a
DBA.
Today's script is showplan.sql and is in the SQLPLAN directory.
The script serves to help monitor and check active execution plans and try to create an advisor for sql plans with problems.
The script serves to help monitor and check active execution plans and try to create an advisor for sql plans with problems.
It's the first version, so I'm sure the Advisor needs some 'tuning' 😆. The attempt here is to flag potentially problematic plans, just a starting point for further analysis.
You can use this script in combination with Carlos Sierra's coe_xfr_sql_profile.sql to define a better plan, for example.
Remember that these are scripts that you can use and change at your own risk. They help me a lot, but they may not be as functional for you.
My script, my rules for advice and tuning, ok?
Remember that these are scripts that you can use and change at your own risk. They help me a lot, but they may not be as functional for you.
My script, my rules for advice and tuning, ok?
The repository is https://github.com/MarioBarduchi/Scripts2DBA.
And always remember:
- Some scripts are a compilation of several other scripts I've created.
- Some scripts are based on and adapted from existing scripts. Those that I found reference to the author I obviously identify in the script.
- So, if there's a script that you're the author of and I've adapted to my reality and it's not mentioned, please let me know and I'll be happy to reference it.
- Because they're my scripts, they have my logic and help me in my day-to-day work, it doesn't mean that they're the best or that they're always the most refined and concerned with good practices. They can help you, but that's all.
- Feel free to make changes, but please keep the reference to the authors.
- If you find any mistakes, please let me know.
Regards
Mario Barduchi
