Search results

Tom (and others), I appreciate your time in responding, and I know the challenge I have taken on is a bit on the extreme. I am willing to provide what data and test results I can if you are interested in seeing the outcome of this endeavor. I attached the IOMeter test results two posts above...

Tom, That is the ultimate question, is this DB configuration (HW/SW) already at it's highest performance level already? Am I seeing a performance *hit* because the application & DB are designed with latentcy riddled spindle disks in mind, and the lack of latency in SSDs is a problem for the...

That is just it, we did the full dump/load/truncate 2 months ago and we gained nearly a 90% performance increase from the system. MRP is the big hog. It used to take 72 hours to run, and on the test server (and after simply truncating the BI file), we saw a drop of 20 hours from the MRP run...

Starting from the top, these are the entries I want to focus on: Number of Database Buffers (-B): 190000 Current Spin Lock Tries (-spin): 50000 Before-Image Cluster Size: 268419072. (4250) Before-Image Block Size: 8192 Number of Before-Image Buffers (-bibufs): 25 BI File Threshold size...

Here are the log entries from the production server as of March 6th: 14:39:43 BROKER 0: Multi-user session begin. (333) 14:39:43 BROKER 0: Begin Physical Redo Phase at 0 . (5326) 14:39:43 BROKER 0: Physical Redo Phase Completed at blk 0 off 155 upd 0. (7161) 14:39:45 BROKER 0: PROGRESS...

Tom, Here is a snippet from the client .INI file for connection options... Is this what you are talking about? ConnectOptions=-N TCP -H <servername removed> -S 6100 -ld <DBName removed> I am assuming the -S is the DB connection port.

Tom, thankyou for your valuable input. >>A BI file that is 25GB large is wrong. Something is not right with that picture. What is a good BI size? How often should I truncate the BI and re-grow it? Keep in mind, our system turns to a slug when it grows a new BI file (they are 512MB each)...

Spin Lock Retries are set to 50,000 on the production server, apparently they are set to zero on the test server. ok, where would I set the -T parameter, and how would it look if I set it to, say, a "T:\temp" folder?

CJ, I have been logging disk Q and read/write activity in Perfmon for the last 48 hours (yes, our MRP takes that LONG, even on SCSI disks!). I would assume that everything is going to the SSDs right now, this is how it was with the SCSI disks as well. Dumb question, where do I find the -T...

Tom, I gave the reasons for 9.1d in my reply to RealHeavyDude. Nothing I can do about it. Same goes for using AI... Which makes me want to ask, what performance issues will I encounter if it was enabled? And yes, while I am aware of newer hardware/software, the server/app are what they are...

MaximMonon: So, a different set of disks for (-T) temp files as well? How often are they written/read to? As I understand it from the Admin guide, temp files are used when queries (4GL/SQL) have a sort order requirement, so the system writes the data out to the temp file before it applies...

I am going to answer your questions in order, so here goes: RealHeavyDude: Not all 600 users hit the DB at the same time, actual "concurrent" use is probably closer to 100-150 users. We are stuck with the DB because the application requires it (and no, it isn't home grown). We are planning a...

Hi all, I have been working very hard in an attempt to migrate a production Progress 9.1D database with 600+ users from Ultra320 SCSI disks to newer solid state SAS drives, but have been running into performance problems. The test server has 12GB DDR2 ram, Two dual core (or single core...