Tag: performance

Duplicate indexes in MySQL

Valerie Parham-Thompson explains why duplicate (redundant) indexes are sometimes helpful.

Read More >

Investigating IO performance on Amazon RDS for Oracle

Maris Elsins, Lead Database Consultant at Pythian, provides an in-depth examination of IO Performance on Amazon RDS for Oracle.

Read More >

How to store performance counters directly on SQL server using TypePerf Command

Introduction Every DBA should know that the baseline is one of the most important pieces to make a proactive troubleshoot to discover potential problems in your SQL Server environment. The baseline is a key point to measure the instance performance…

Read More >

Analyze index validate structure – the dark side

Know the performance implications of a command before deciding to use it.

Read More >

Oracle’s CREATE INDEX command can take a hint

Christo Kutrovsky, ATCG Principal Consultant and Oracle ACE at Pythian, shares something useful he discovered by accident when playing with Auto DOP.

Read More >

Use case for SQL server table partitioning

Michelle Gutzait, one of Pythian’s SQL Server Experts, offers some helpful use cases for those who have trouble deciding which tables they should partitioning or not.

Read More >

Recursion in Hive – part 1

In Part 1 of this series, Valentin Nikotin, will teach you about migrating from RDBMS to Hive, while maintaining the simplicity and flexibility of a SQL approach.

Read More >

ORA-10173: Dynamic sampling time-out error

  Recently on a heavily used and freshly upgraded 12.1.0.2 ware-house type database, we started seeing lots of ORA-10173 dumped into the alert log. The information out there on this error is somewhat sparse, and it is often linked to…

Read More >

High “cursor: pin S wait on X” waits?

If your system meets any of the following criteria: – Oracle 12.1.0.2.0 or higher – Partitioned tables – Parallel query heavily used – Bind variables in use, as they should be and, you’re seeing unusually high “cursor: pin S wait…

Read More >

Slimming Down Oracle RAC 12c’s resource footprint

Oracle Grid Infrastructure 12c uses a considerable amount of RAM and CPU resources; here are a few tips to shoehorn it into a 2GB virtual machine.

Read More >
Page 3 of 512345