SEP
07
0

Diagnosing Performance Issues (Part 1 of 8192)





Diagnosing Performance Issues (Part 1 of 8192)

Picture a Rubik’s cube in your mind: at the core is the holy grail of system performance, and every colored tile is a potential bottleneck preventing you from attaining that perfection. On one side, you find database issues, another side is the network, there are the physical servers, and mixed throughout is plain old bad code. Today we’ll focus on a few big red flags related to your physical system resources: CPU, memory and disk.

My CPUs are on FIRE! 

When it comes to CPUs, you need to know one thing and check three:

Continue reading
599 Hits
MAY
01
2

Dump and Load Strategies Part II: Dumping Data

Dump and Load Strategies Part II: Dumping Data

Wow - it's been a month since my last blog entry. Time flies!

If you read Part I, you've already analyzed your data and designed your Type II storage areas and you're ready to dump your existing data and load it into the new structure. If you're still using Type I storage areas, this will probably be the slowest part of the entire D&L process so don't despair. The load and the index rebuild should take considerably less time than the dump.

You have three choices when it comes to dumping your data:

  1. ASCII Dictionary Dump
  2. ASCII Custom Dump 
  3. Binary Dump

This blog post is going to concentrate on the binary dump as that's what most of you are going to use. Unless the database is very small or you need to do some conversions during the dump, there's really no reason to use the dictionary dump for anything other than users and sequence current values.

Continue reading
Recent Comments
Paul Koufalis
I did not mean "in series". I really meant "in parallel". I try to run as many binary dumps as possible all at the same time. Yes ... Read More
Thursday, 07 May 2015 09:35
21374 Hits
MAR
30
4

Dump and Load Strategies Part I: Type II Storage Areas

Dump and Load Strategies Part I: Type II Storage Areas

Congratulations! You finally decided to join the modern world and take advantage of Type II Storage Areas (SAII). Hey - better late than never. There's a lot of old, out-of-date or just-plain-wrong information out there, so ignore all that stuff. I have conveniently digested some useful, pertinent and correct information right here.

Basic stuffYou need OpenEdge 10DB Block Size: Pretty self-explanatory. Typically 8Kb on UNIX and 4Kb on Windows and LinuxBPC = Blocks Per Cluster: The number of database blocks formatted each time an object requires more spaceValid values are 8, 64, 512RPB = Records per Block: How many ROWIDs should be reserved for each database blockValid values are 1, 2, 4, 8, 16, 32, 64, 128 or 256Keep data, indexes and LOBs segregated Storage area are typically defined in a file called dbname.st Controversial Assumptions 

A few seasoned DBAs will disagree with the following assumptions. These DBAs are wrong except in very specific cases (0.1% of you) and I can and have proven it mathematically.

Continue reading
Recent Comments
Paul Koufalis
For such small databases (10 Gb), I wouldn't even bother with any of that. I would just create two SAII for data and two SAII for ... Read More
Wednesday, 06 May 2015 20:02
Paul Koufalis
You are correct. I will fix.
Friday, 08 May 2015 13:38
23348 Hits
MAR
08
5

Is Progress Going to Audit Your Licences? YES!

Is Progress Going to Audit Your Licences?  YES!

Disclaimer: I am not a lawyer and this is not legal advice. The information below may or may not be applicable in your environment.

How many of you have been through a licence audit recently? If you haven't then expect it...and soon. Progress has relied on honour-based licensing for 30 years and now...well...maybe now they're questioning your honour just a little bit!

Continue reading
Recent Comments
Tom Bascom
One small comment -- do not assume that you are under-licensed. Many clients discover that they have a bunch of licenses that the... Read More
Monday, 09 March 2015 11:33
Paul Koufalis
@Montoya: I would expect yes.
Tuesday, 17 March 2015 18:09
Paul Koufalis
Eric, Having dealt with a number of SAM auditors at Progress, I can tell you that there are some that do understand the technolog... Read More
Monday, 16 November 2015 13:33
22798 Hits
FEB
23
1

Migrating OpenEdge to Linux is Easier than You Think

Migrating OpenEdge to Linux is Easier than You Think

Over the past 10 or so years, the number of [AIX, HPUX, Solaris] to Linux migrations have been increasing steadily, along with the "safe" recommended maximum number of concurrent users. The reason is simple, of course: cost. Unless your OpenEdge application is serving thousands of users, Linux can probably do the job just as well as one of the proprietary Unix flavours. If you have less than 250 concurrent users then this should be a no-brainer for 98% of you.

Here are some points to consider for the OpenEdge migration:

Continue reading
Recent comment in this post
Kandavel Elangovan
Very useful info!! Waiting for your blog on OE Upgradation
Tuesday, 24 February 2015 13:07
24172 Hits
FEB
13
0

OUCH! Backup Time Stamp on Windows

OUCH! Backup Time Stamp on Windows

I was called in to consult at a site where the backups were exhibiting strange behaviour. The backup file was the normal 15Gb in size and the time stamp was from last night, but when they restored it in test there was no new data.  In fact, the most recent data they could find was from a couple of weeks ago.

Looking at the DB log file, it didn't take long to ascertain that the backups were actually failing.  On Windows, if the backup file already exists, probkup just writes on top of it without resetting the size to zero. Furthermore, even if no backup ever occurred, probkup still "touched" the file, changing the time stamp.  The result: a full sized backup file with a valid date and time stamp but still the contents from two weeks ago.

Continue reading
20829 Hits