Performance

Forefront Endpoint Protection (FEP) 2010 and database policies

I have seen at a customer that the SQL Server's policy doesn't follow the Microsoft's recommendations about antivirus and databases(kb 309422), such excluding *.mdf,*.ndf and *.ldf files. In addition the policy for Oracle doesn't exist in(…)

Partition exchange preview in MySQL 5.6

MySQL 5.6 proposes improved partition maintenance through "partition exchange". Even if not yet available, dbi services performed some tests on the MySQL Community Edition5.6.2 m5 release (still under Development).

How to retrieve previous table statistics using Oracle dbms_stats

Sometimes, you need to modify the statistics of a table. There are various reasons: either for the performance analysis or because the execution plan changed. Oracle offers two methods: statistics restore or statistics export. Both are in the dbms_stats package.

Saving time and increasing service availability with MySQL Enterprise Monitor 2.3

Nowadays MySQL Databases are encapsulated into many mission critical software solutions. Lots of companies host one or many MySQL databases in their data center, sometimes even without knowing it except when the MySQL service is no more available. In order(…)

Simulating and testing I/O performances with ORION

Since Oracle 11.2, Oracle provides ORION in the RDBMS binaries (in ${ORACLE_HOME}/bin). ORION is an I/O calibration tool allowing to simulating and testing I/O performances an Oracle database would be confronted with.   ORION basically supports four kinds of database(…)