If it's any help...
We run 7.6.100a on dual processor servers (both SQL and the program server) that are not Xeon based chips but all users run on a Terminal Server/Citrix server that has dual Xeon's and 4 gig of ram that they must use to access Macola.
We have several customers that use Xeon single and dual processors for both SQL and PSQL platforms with no problems. The first Xeon base processor we deployed Macola on was a PII 450 on Novell 3.2 and the newest twin P4, 4gb ram on Win2003 server / MS SQL. The high speed disk (15k) are a plus.
We use PERC controllers/raid, not drives. They have been no problem last 5 years of service. Would suggest hot swappable version. We only have that on the Xeon server and not the others and I have a drive starting to fail on one of those. The server need to be brought down to change out or rebuild the drive. That works okay in this case but maybe not for your needs.
Can anyone confirm advantages/disadvantages of dual processor versus single for Pervasive 2000 and MS/SQL? I'm getting conflicting information that the dual processors will have little or no effect with either database - I find this hard to believe..
We went with dual for our SQL and Macola servers. While I don't remember the exact reason, performance was to be enhanced by using 2000 Advanced Server with dual processors Vs 2000 server with dual processors.
What I see in production is low overhead of CPU time but some reports and such still take a long time. It is now my understanding that using a gigabyte Ethernet connection will make the desired performance gain we seek. We have not done that yet.
I have seen a performance increase in Crystal reports with mulitple processors. Macola itself and its canned cobol reports still does not run any faster.
Multiple processors has also increased the performance capabilities of SQL itself during backups and maintenance plans.
The gigabit upgrade gives an impressive boost in performance, especially if you are transfering large amounts of data between a Macola server and another server running ODBC.
Dual servers don't do much for Macola but they do allow the operating system to offload tasks like print and file service to the extra processor, so if your site has invoice printers, etc hooked directly to the Macola server or if the server is hosting file archives for other systems, you'll see a boost.
Biggest bang seems to come from memory upgrades. Macola loves RAM.
My general understanding of multiple processors is that you can offload users who do lots of report generation onto their own processor, which will isolate them from the rest of the users, increasing performance on everyday apps for the ordinary user. Not being a network expert, I'm not sure how you route the specific user to the specific processor, but I've heard it works.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.