Question : Does Sybase have a tool like AWR in Oracle which can be used to identify high load SQL, […]
Tag: tuning
How to monitor load on database server
Question : Could anybody please suggest me a way to monitor the load on my database server? What perfmon counters […]
Same query same data different server different query plan
Question : I have a query that hits a view, which references other views etc…several levels down. The query plan […]
Are individual queries faster than joins?
Question : Conceptual question: Are individual queries faster than joins, or: Should I try to squeeze every info I want […]
Can SQL profiles be deployed to other Oracle Databases?
Question : When using The SQL Tuning Advisor in SQL-Developer. I get often some recommendations to accept a SQL-Profil. I […]
Hash Match inner join in simple query with in statement
Question : I am running the execution plan for the following query: select m_uid from EmpTaxAudit where clientid = 91682 […]
MySQL 5.5 – Innodb – innodb_log_file_size higher than 4GB combined?
Question : When reading online about innodb_log_file_size, it says The combined size of the log files must be less than […]
MySQL 5.1.63 – using tuning-primer – Table Cache question
Question : tuning_primer says the following: TABLE CACHE Current table_open_cache = 812 tables Current table_definition_cache = 256 tables You have […]
Database Tuning Issues
Question : I’m not a DBA so looking for some advice on tuning a MySQL (MyISAM) database. I’ve found that […]
Improve performance for my plsql block
Question : First of all let me make kind of a disclaimer here: 1) i’m a developer, not an administrator; […]