Articles tagged

30 December 2014
30 December 2014

Oracle GoldenGate 12c New Features – Part 2

1
The Oracle GoldenGate software package delivers low-impact, real-time data integration and transactional data replication across heterogeneous systems for continuous availability, zero-downtime migration, and business intelligence. Oracle GoldenGate 12c empowers organizations to capture, route, transform, and deliver transactional data between heterogeneous databases in real time with minimal overhead.… Read more
24 November 2013
24 November 2013

High Availability and SLA requirements for Oracle database

0
Designing a highly available database system involves taking various elements and combining them to suit your business needs and requirements. At the beginning of architecting a new high available Oracle database system it’s important to understand the need to make design and infrastructure decisions in the context of meeting Service Level Agreements (SLA). The SLA targets can be usually achieved… Read more
21 May 2012
21 May 2012

A first look at SQL Server 2012 Availability Group Wait Statistics

If you are trouble-shooting an AlwaysOn Availability Group topology, a study of the wait statistics will give a pointer to many of the causes of problems. Although several wait types are documented, there is nothing like practical experiment to familiarize yourself with new wait stats, and Joe Sack demonstrates a way of testing the sort of waits generated by an availability group under various circumstances.… Read more
23 January 2012
23 January 2012

Confessions of a DBA: My worst mistake

Over the next few months, we'll be asking various well-known DBAs to describe their worst disaster caused by a mistake they made. To kick off the series, we asked Phil Factor to confess. He came up with a classic: The mistaken belief that a backup WITH CHECKSUM guaranteed a good backup that could be restored, and the ensuing disaster.… Read more
26 October 2011
26 October 2011

Resource Governor

If you suffer from runaway queries, if you have several database applications with unpredictable fluctuation in workload, or if you need to ensure that workloads get the memory or CPU they need according to certain priorities, then you need Resource Governer, and you need Roy Ernest's clear explanation of the technology.… Read more
29 June 2011
29 June 2011

The One Way That High Availability Will Help You

High Availability (HA) is a term that is beloved of the marketing people, with its connotations of an unspecific sense of reassurance. However, service reliability cannot be bought like bath salts: But, explains a seasoned and cynical expert in the field, HA can be more than the start of 'HAHA!'. There is a role for HA in keeping your services running, if used as part of a broader solution.… Read more
13 January 2011
13 January 2011

7 Things that High Availability is Not

54
Wesley has heard High Availablity touted as all sorts of technological cure-all for busy SysAdmins and DBAs, and now he's taking a stand against it. There are a range of things that High Availability is regularly confused with (either deliberately or innocently), and Wesley's clearing it all up.… Read more