I’m happy to introduce a new free tool that allows to get initial insights about a database using eDB360/SQLd360 like charts without Diagnostic Pack!!!
(TUN)ing with (A)ctive (s)essions, aka TUNAs360, requires no installation and no parameter when executed; it observes the workload for few minutes and then collects a set of reports on such load.
The idea behind the tool is to help getting started in those situations where there is a concern with database performance but the reason is unknown, the classic “the database is slow but I don’t know why”.
In case further investigation is necessary then eDB360 or SQLd360 can be leveraged.
Once executed TUNAs360 provides several reports for the whole database (cluster and node specific) plus additional reports to help drill into the details of the top 5 sessions and top 5 SQLs during the time the load was observed.
The tool belongs to the “360 family” so it has the same look and many of the charts of its bigger brothers, the main page looks like this
To execute the tool:
- Download the tool from the link on the right side of the screen.
- Unzip file tunas360-master.zip
- Navigate into tunas360-master folder
- Connect as a DBA user and run script tunas360.sql
The tool will run for a few minutes and it will generate a zip file named tunas360_<dbname>_<host>_YYYYMMDD_HH24MI.zip.
As every other tool on its first version I don’t expect it to be perfect so please please please let me know if you run into problems so that I can fix them 😀
Feedbacks and suggestions are welcome as usual too!!!
Mauro Pagano's Blog 