SBS2003 and MYOB Premium Accounting

Discussion in 'Windows Small Business Server' started by Peter, Apr 12, 2004.

  1. Peter

    Peter Guest

    In our office we've just installed a dell server, the specs are P4 2.8, 1gb
    RAM.
    There are about 15 users connected. Everything seems to be running great
    but access to the MYOB Files is very slow, most of the problems come from
    accessing any file over 70mb. Anyone got any clues on how to speed things
    up, we've resorted to transferring the file to the local machine then back
    to the server after we have used it.

    Any ideas from people would be wonderful.
     
    Peter, Apr 12, 2004
    #1
    1. Advertisements

  2. Peter

    Chris Guest

    Chris, Apr 12, 2004
    #2
    1. Advertisements

  3. Peter

    Peter Guest

    Hi Chris

    the clients are mostly wW2K Pro machines

    cheers

    Peter
     
    Peter, Apr 12, 2004
    #3
  4. Peter

    Henry Craven Guest

    MYOB is notoriously slow in a multi-user environment. Has to do, I
    believe, with the proprietary instead of Windows System
    file locking. While it may not be the only issue here, it's worth
    noting.
     
    Henry Craven, Apr 13, 2004
    #4
  5. Peter

    Peter Guest

    Hi Henry

    I've heard that about MYOB

    What do you mean about file locking and proprietary
     
    Peter, Apr 13, 2004
    #5
  6. Peter

    Henry Craven Guest

    In a multi-user application you have to control who has
    priority/authority to
    change a record as it's possible for more than one user to be accessing
    the same record at the same time. Hence the need for a locking mechanism
    ( First in gets the record and can edit it, but locks the others out,
    and / or conflict resolution around that ). My understanding ( which may
    be wrong ) is that MYOB is built on old core where that implemented
    their own, ( Home Grown / Proprietary ) system for P-2-P ( Win3.11 ) and
    while they've updated the UI they've not rebuilt the core to use modern
    networking / Windows file locking which is a lot faster.

    You may want to play with the Pollock setting to see if it that's
    conflicting / helps.

    PC Ext: Explanation of Opportunistic Locking on Windows NT
    http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q129202&

    How do I configure Opportunistic Locking on Windows NT and Windows 2000?
    http://www.jsiinc.com/SUBG/TIP3100/rh3108.htm
     
    Henry Craven, Apr 13, 2004
    #6
  7. Peter

    Mal Osborne Guest

    Yep, I have seen MYOB crawl on fastish hardware. It seesm to for some
    reason move massive amounts of data accross the network. Moving to Gigabit,
    ridiculous as it sounds, may make all the differance.

    Mal Osborne
    MCSE MVP Mensa
     
    Mal Osborne, Apr 13, 2004
    #7
  8. What hasn't been mentioned as a possible cause of slow file access is Volume
    Shadow File Copies. Naturally, any change in the file would result in the
    Volume Shadow Copy Service making a copy of the file. By default Volume
    Shadow Copy is enabled on all volumes of SBS2003, and a shadow copy is made
    daily at 7am and 12pm.
     
    Anonymous Coward, Apr 13, 2004
    #8
  9. You took the words right out of my mouth. We're also using MYOB on a
    beige box server. P4E 2.8, 1gb RAM, 2x 120gb 7200RPm Segate hard drives
    in a RAID 1 array. We were going to get 36gb WD Raptors but there
    weren't any availible. I'm going to try disabling volume shadow copy to
    see if that improves things. There is a Terminal Service version of MYOB
    but that would require adding a member server or dumping SBS <shudders
    at idea of explaining those costs to the boss>.

    Maybe we should work together on this problem...

    Chris Dunkinson
    EMail: chris13 @t bigpond <d0t> net <d0t> au
    MSN:
     
    Chris Dunkinson, Apr 13, 2004
    #9
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.