Search results

Nothing that I would use on a database I cared about. Why the need for the rename?

Tom will be in shortly to yell at me about this :D but... Your real world experience with RAID 5 will vary based on a number of factors. While it is very true that writing to parity based raid is slower than a comparable RAID 1/10 array... sometimes that doesn't matter. Or doesn't matter...

The easy way to get started... 1) Figure out which changes can be done "online" vs offline. 2) Hopefully you already have scripts to shutdown/startup your DB. 3) Write a simple bash script to call mbpro/bpro <your connection info> -p load_my_df.p - Where load_my_df.p contains...

Some really interesting design decisions were made over the years for the Dataservers.. it does work pretty well once you embrace the madness a bit. Especially if you pass the point of no return and start using the SQL specific calls (stored procs, pass through queries, etc). Unless you are...

The default connection management is pretty awful for the OE Dataservers (imo). Here is a KB with two parameters you can use to somewhat manage the number of connections per client, as well as a high level description of the internals. Progress KB - How to limit connections to Microsoft SQL...

I guess it depends on your definition :p I consider it a debacle because it was presented as a method to huge performance gains (to my company at the time) and an easy way to do online maintenance for multi TB databases. There was some lively debate about their approach and why it would not...

OpenEdge 10.2B Product Documentation - Wiki - OpenEdge General - Progress Community The Application Server section :-)

The difference between client server and shared memory can be quite drastic for any non trivial code. Assuming you have the proper licenses on the Unix machine setting up an appserver and connecting to it is pretty simple really. The documentation has quite a few examples on how to do this...

I agree that OE will never catch up with Oracle across the board. That ship sailed back in the 90s. None of what I described above are Exadata features btw... that all comes with any version of Oracle that runs on the same hardware that OE does. It is a crying shame that quite a few of the OE...

Oh boy... Another chance to compare Oracle and OE :D I am going to (mostly) leave Oracle Exadata out of this discussion... mostly because it is crazy complicated under the covers. But the high level idea is that the storage hardware and the database know quite a bit about each other and you...

Next year Larry... next year :cool: It was a lot of fun. Some of the talks did seem a little short considering how many questions were raised... but varying the length of the presentations and preventing overlap is obviously quite a challenge. Way more valuable than any of the official...

Listen to RHD... he speaks the truth. Subverting code pages is the path to madness and despair.

Did they switch the licensing model for AppServer again? Isn't it agent (not user) based? This command will give you some of the info you asked for... just not sure you need it. asbman -name <appservername> -query

I completely agree Tom.. that was the point I was trying to make in my first post. Most likely too brief/terse due to lack of sleep and coffee because of my company chosen (cheap) late night flight back home from the PUG :( I didn't mean to throw stones at readprobe... just point out that if...

I did say as a benchmarking tool :p Obviously it is a fine tool for massive reads/scans. I just don't consider tests without writes, networks and the appropriate OE components a benchmark.

Keep in mind that readprobe is a very specific test designed to test one thing. It is utterly meaningless as a benchmarking tool.

In preparation for ProTop being installed... make sure your -tablerangesize and -indexrangesize are set properly. Take a look and _UserTableStat and _UserIndexStat records for those web requests and see what floats to the top (compared to what they should be doing). Put in a request for an OE...

So you have one checkpoint with flushes (when the backup starts)... not a checkpoint issue. IO in general and the cache/code like Tom says are your likely issues. You can try adding -Bp 64 to your probkup command to try and avoid clearing the OE buffer cache. OS and SAN cache is another matter...

1) You don't want to shorten the total length of the checkpoint.. longer times are almost always better. 2) In the second part of your post there are buffers being flushed at checkpoints.(1046104).. those are bad but the sample size is too large. Try and track down when those are happening per...

What tables is it complaining about after the auditreconfig? Did you move the audit table and the audit indexes to different areas?