Performance Monitor for SAP/Sybase ASE.
Monitor/MDA tables are great, but there is a fair amount of work necessary to use them, especially without a tool. AseTune is performance monitoring tool that makes this valuable data readable quickly and easily.
DbxTune supports: SAP ASE, SAP IQ, SAP Replication Server, SAP HANA, MySQL, Postgres, Microsoft SQL-Server and Oracle
Also included: a simple SQL Tool to query any of the above RDBMS
More info: https://github.com/goranschwarz/DbxTune
Features
- What SQL are currently being executed
- How much CPU is consumed for the moment
- What tables/indexes are accessed mostly
- On what tables do we have locking conflicts
- What is a specific "spid" doing right now
- What "spinlocks" do we have contention on
- What is the DBMS waiting for
- Record a Session and review it later
- A centralized dashboard
- no-gui mode to constantly collect data
- Cross platform support; GUI and no-gui
You Might Also Like
Our Free Plans just got better! | Auth0 by Okta
You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your secuirty. Auth0 now, thank yourself later.
Rate This Project
Login To Rate This Project
User Reviews
-
I just downloaded it and started randomly pointing and clicking, but the ease of use and the amount of data that is available is really impressive. Not sure if this is still in development, but I certainly hope so. It really is a great tool.
-
This new version is a great piece of work. Thank you! Mr. Schwarz. I was immediately able to see poorly-performing queries on our production box and figure out what indices needed to be added, including creating covering indices. If you administer ASE, you *need* this. Period.
-
After using Sybase ASE for a quarter century and writing a million dumb scripts to try and sus out perf data, AseTune is revolutionary. I am in awe of what you've done here, and I hope I can convince my employer they ought to contribute. Were I to complain, it's the lack of good help files. (I'm trying to figure out how to save data other than hitting the screen shot button (which is by the way brilliant)). But it's so good, I really don't want to complain.
-
Excellent tool; good alternative to Asemon as no intermediate server is required and can also be used in batch mode. Thanks for this good work