Performance

Exploring Oracle SE & EE performance statistics with Orachrome Lighty

By Franck Pachot . At dbi services, we really like Lighty for Oracle, a tool which helps exploring performance statistics whether they originate from AWR (available only in Enterprise Edition with Diagnostic Pack option) or from Statspack (available via Standard(…)

SQL Server 2014: SELECT INTO operators can run in parallel

A couple of weeks ago, I had to provide some best practices in term of architecture for a “heavy writes” environment that consists in importing data from different sources into SQL Server tables. At the customer place, I was(…)

Stéph@TechEd 2012: Episode2 – SQL Server 2012 & Windows Server 2012

Today it’s the real beginning of the TechEd with several sessions in parallel.

Protecting an Oracle database from block corruption

Data can be corrupted in different ways, for example an I/O issue when reading data from the storage or a memory issue when updating data. The db_block_checking parameter allows to change the behavior of an Oracle database concerning block checking.

Using IOzone for Linux disk performance analysis

Who never had to measure the disk performances on a system? Speaking about Linux performance monitoring includes a significant part on disk performances. If you are facing applications or databases running slower than expected or than on other environments, you(…)

Jonathan Lewis @ dbi services: Oracle Optimizer workshop

Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services BaselArea. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.

‘Query result cache’ in Oracle 11g

Oracle has introduced three new caching features in its Oracle 11g release: Query result cache Client OCI result cache PL/SQL function result cache In this posting, I will present the query result cache feature.

Linux: easing the process and performance monitoring with htop

I'm pretty sure that most of you already struggled with some low performance systems. In order to analyse such cases several tools and utilities, like top, nmon, fuse or lsof are available under Linux. However trying to dig in processes(…)

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).