Very Slow


T

ToyMaster458

I am finding that getting around in MOA is VERY slow! It can take me 30
seconds to a minute just to open a cusotmer. I also see my SQL CPU use going
up to 100% use at times durring slow access. Any thoughts from anyone??
 
Ad

Advertisements

K

Kollen Glynn [MS]

This is not expected behavior. Can you detail the specs of your hardware
like processor and memory?

Thanks,
Kollen
 
A

AngelaTC

I am not the original poster, but I have the same issue and since it's
been a couple of days...

I am running XP SP2. Build 2600

2.60 gigahertz Intel Celeron
8 kilobyte primary memory cache
128 kilobyte secondary memory cache

300.06 Gigabytes Usable Hard Drive Capacity
284.09 Gigabytes Hard Drive Free Space

I hope that enough information.
 
J

Jorn L M \(MS\)

Hi

You did not mention how much memory (RAM) you have in your machine.

And I have a couple of follow up questions:
- Is everything slow on your machine or is it just Office Accounting?
- Is everything slow in Office Accounting?
- Is if every time you open things in the produce or only first time?
- Is your database integrated to BCM?

In general I have a few blog posts about performance and Office Accounting
that could be helpful
http://blogs.msdn.com/jorn/archive/2006/11/13/office-accounting-performance-tips.aspx
http://blogs.msdn.com/jorn/archive/2007/03/28/office-accounting-on-sql-server-performance.aspx

A (probably premature) guess in your case would be to look at the "SQL needs
Repair" section.

Please post back with more info, I would really like to find out know what
is wrong in your case...
 
O

OneDave

Same problem after installing MOA Pro 07 over 06 on an XP machine. Severe
slowdown (unusable application now) with almost constant disk I/O. Will try
your ideas and advise you of results.
 
S

SEOH

I am another with very, very slow response....I am going to write off the
purchase and get something else....I called support and said there is nothing
they can do.

1GB Ram
3.2Ghz Processor
No other programs run slow
Computer is 3 months Old
closed all other programs and is same speed.

This program is bad.
Cannot upload orders
Cannot upload pricing if you have 1000's of products...manual reprice,
yearly nightmare!
Cannot generate a purchase order that has the vendor number unless you
"fudge" the purchase description.

Definately a program written by programmers...not distributors or users.

Find something else.



OneDave said:
Same problem after installing MOA Pro 07 over 06 on an XP machine. Severe
slowdown (unusable application now) with almost constant disk I/O. Will try
your ideas and advise you of results.
--
Thanks
Dave

Jorn L M (MS) said:
Hi

You did not mention how much memory (RAM) you have in your machine.

And I have a couple of follow up questions:
- Is everything slow on your machine or is it just Office Accounting?
- Is everything slow in Office Accounting?
- Is if every time you open things in the produce or only first time?
- Is your database integrated to BCM?

In general I have a few blog posts about performance and Office Accounting
that could be helpful
http://blogs.msdn.com/jorn/archive/2006/11/13/office-accounting-performance-tips.aspx
http://blogs.msdn.com/jorn/archive/2007/03/28/office-accounting-on-sql-server-performance.aspx

A (probably premature) guess in your case would be to look at the "SQL needs
Repair" section.

Please post back with more info, I would really like to find out know what
is wrong in your case...

--
Regards

Jørn Lindhard Mortensen
http://blogs.msdn.com/jorn/


AngelaTC said:
I am not the original poster, but I have the same issue and since it's been
a couple of days...

I am running XP SP2. Build 2600

2.60 gigahertz Intel Celeron
8 kilobyte primary memory cache
128 kilobyte secondary memory cache

300.06 Gigabytes Usable Hard Drive Capacity
284.09 Gigabytes Hard Drive Free Space

I hope that enough information.



Kollen Glynn [MS] wrote:
This is not expected behavior. Can you detail the specs of your hardware
like processor and memory?

Thanks,
Kollen

I am finding that getting around in MOA is VERY slow! It can take me 30
seconds to a minute just to open a cusotmer. I also see my SQL CPU use
going
up to 100% use at times durring slow access. Any thoughts from anyone??
 
Ad

Advertisements

O

OneDave

Check out Jorn's message above. Seemed to explain the performance issue
(i.e., SQL Server problems).
--
Dave


SEOH said:
I am another with very, very slow response....I am going to write off the
purchase and get something else....I called support and said there is nothing
they can do.

1GB Ram
3.2Ghz Processor
No other programs run slow
Computer is 3 months Old
closed all other programs and is same speed.

This program is bad.
Cannot upload orders
Cannot upload pricing if you have 1000's of products...manual reprice,
yearly nightmare!
Cannot generate a purchase order that has the vendor number unless you
"fudge" the purchase description.

Definately a program written by programmers...not distributors or users.

Find something else.



OneDave said:
Same problem after installing MOA Pro 07 over 06 on an XP machine. Severe
slowdown (unusable application now) with almost constant disk I/O. Will try
your ideas and advise you of results.
--
Thanks
Dave

Jorn L M (MS) said:
Hi

You did not mention how much memory (RAM) you have in your machine.

And I have a couple of follow up questions:
- Is everything slow on your machine or is it just Office Accounting?
- Is everything slow in Office Accounting?
- Is if every time you open things in the produce or only first time?
- Is your database integrated to BCM?

In general I have a few blog posts about performance and Office Accounting
that could be helpful
http://blogs.msdn.com/jorn/archive/2006/11/13/office-accounting-performance-tips.aspx
http://blogs.msdn.com/jorn/archive/2007/03/28/office-accounting-on-sql-server-performance.aspx

A (probably premature) guess in your case would be to look at the "SQL needs
Repair" section.

Please post back with more info, I would really like to find out know what
is wrong in your case...

--
Regards

Jørn Lindhard Mortensen
http://blogs.msdn.com/jorn/


I am not the original poster, but I have the same issue and since it's been
a couple of days...

I am running XP SP2. Build 2600

2.60 gigahertz Intel Celeron
8 kilobyte primary memory cache
128 kilobyte secondary memory cache

300.06 Gigabytes Usable Hard Drive Capacity
284.09 Gigabytes Hard Drive Free Space

I hope that enough information.



Kollen Glynn [MS] wrote:
This is not expected behavior. Can you detail the specs of your hardware
like processor and memory?

Thanks,
Kollen

I am finding that getting around in MOA is VERY slow! It can take me 30
seconds to a minute just to open a cusotmer. I also see my SQL CPU use
going
up to 100% use at times durring slow access. Any thoughts from anyone??
 
R

R Howard

We are having the same problem. It takes almost 2 minutes to load "Bill and
item Receipts" and there are less than 100 items. SBA 2006 did not do this.
We are running a Dell Server with dual Xeon 2.4 processors with 3 Gig ram
with Server 2003 and SQL2005. Only 1 workstation (Win XP pro and a fast
processor with 2 gig ram)is accessing Accounting 2007 and is virtually
unuseable when accessing Bills. Accounting itself and other things like
customers, employees, etc. seem to load just fine. Any ideas?
 
F

FranOR

VERY SLOW HERE TOO - I think this may be the undoing of this product line
unless MS makes changes.

I am going to post another question about how we might speed things up

SEOH said:
I am another with very, very slow response....I am going to write off the
purchase and get something else....I called support and said there is nothing
they can do.

1GB Ram
3.2Ghz Processor
No other programs run slow
Computer is 3 months Old
closed all other programs and is same speed.

This program is bad.
Cannot upload orders
Cannot upload pricing if you have 1000's of products...manual reprice,
yearly nightmare!
Cannot generate a purchase order that has the vendor number unless you
"fudge" the purchase description.

Definately a program written by programmers...not distributors or users.

Find something else.



OneDave said:
Same problem after installing MOA Pro 07 over 06 on an XP machine. Severe
slowdown (unusable application now) with almost constant disk I/O. Will try
your ideas and advise you of results.
--
Thanks
Dave

Jorn L M (MS) said:
Hi

You did not mention how much memory (RAM) you have in your machine.

And I have a couple of follow up questions:
- Is everything slow on your machine or is it just Office Accounting?
- Is everything slow in Office Accounting?
- Is if every time you open things in the produce or only first time?
- Is your database integrated to BCM?

In general I have a few blog posts about performance and Office Accounting
that could be helpful
http://blogs.msdn.com/jorn/archive/2006/11/13/office-accounting-performance-tips.aspx
http://blogs.msdn.com/jorn/archive/2007/03/28/office-accounting-on-sql-server-performance.aspx

A (probably premature) guess in your case would be to look at the "SQL needs
Repair" section.

Please post back with more info, I would really like to find out know what
is wrong in your case...

--
Regards

Jørn Lindhard Mortensen
http://blogs.msdn.com/jorn/


I am not the original poster, but I have the same issue and since it's been
a couple of days...

I am running XP SP2. Build 2600

2.60 gigahertz Intel Celeron
8 kilobyte primary memory cache
128 kilobyte secondary memory cache

300.06 Gigabytes Usable Hard Drive Capacity
284.09 Gigabytes Hard Drive Free Space

I hope that enough information.



Kollen Glynn [MS] wrote:
This is not expected behavior. Can you detail the specs of your hardware
like processor and memory?

Thanks,
Kollen

I am finding that getting around in MOA is VERY slow! It can take me 30
seconds to a minute just to open a cusotmer. I also see my SQL CPU use
going
up to 100% use at times durring slow access. Any thoughts from anyone??
 
T

Tommy Maz

I have the slowness problem also. My specs are:
Server 2003
2.8Ghz P4
1GB RAM (with ~650MB committed when using MOA, Outlook & IE)
I could write a book on minimizing startup programs, processes, & services
on a system, so that is not the issue here.

Since I am running SQL 2005 Express, does the SQL min server memory option
apply? If so, How do I increase it?

Thanks,

Tom Maz
 
Ad

Advertisements

T

Tommy Maz

Jorn,

Thanks for the response. I've tried all of the suggestions in your MOA & SQL
blogs. I bumped up the min server memory option on my SQL Express. THe
program still runs very poorly. Everything else on my system runs fine, so I
am sure it is related to MOA 2007. It seems that there are several other
users with the same issue.

What else can we try?

Thanks,

Tom Mazowski
 
J

Jorn L M \(MS\)

Hopefully we can figure out what the problem is...

A few questions to help me out:

- Is it slow if you run Office Accounting on the server directly?
- How much memory is your SQL server using?
- How much memory is the Office Accounting client using?
- Is everything slow for you in Office Accounting or is it specific things?
 
T

Tommy Maz

- Is it slow if you run Office Accounting on the server directly?
Yes. That is where is is run most of the time.
- How much memory is your SQL server using?
I had bounced the SQL service after the last time I used MOA, so when I just
checked, it was using 10 MB of RAM and 44 MB of Virtual Memory. After
starting MOA, it climbed up to 140 MB & 160 MB. I ran through a few different
screens, opened on invoice, and close the application. After that, SQL is up
to 165 MB & 184 MB.
- How much memory is the Office Accounting client using?
SBA.exe is using 56 MB & 35 MB.
- Is everything slow for you in Office Accounting or is it specific things?
Opening the program is always slow. No actions are ever quick, including
switching from the main Company screen to the Customers screen. Opening and
saving invoices and vendor bills is always slow. On average, it takes about
about 10 - 15 seconds to save an invoice.

\Tom
 
J

Jorn L M \(MS\)

So you are saying that simply switching between say customer and vendor
screen is slow?

Do you have something else running on the server that is using the CPU or
Disc?
 
T

Tommy Maz

So you are saying that simply switching between say customer and vendor
screen is slow?
That is correct, but I will add that it is much slower when I first open the
program. It seems to get better, after I have gone through the different
screens a few times.
Do you have something else running on the server that is using the CPU or
Disc?
Not that I can see. I did some more tests, and the CPU was idle, until I
perfromed actions in MOA. THose actions caused SBA.exe & mssql to use some
CPU activity.
I also monitored Disk I/O reads, which incremented SQLserver & csrss.exe ( a
Windows system process)

\Tom
 
Ad

Advertisements

J

Jorn L M \(MS\)

ok, this one is a dead end for me, it is expected that the application is
slower the first time you open it as it is loading files into memory, (you
will notice the same thing the first time you open an invoice, and the first
time you save an invoice) but after that it should be ok.

Let's focus on the extreme 10 - 15 seconds it takes to save an invoice on
your machine...

- Is that the time it takes every time (not just the first save after you
open the application)?
- Is the time the same if you try to do it in a sample company?
- What are you selling? inventory items? non inventory items? services?
- Does the time change based on what you put on the invoice?
 
K

Kyle O''Brien

Hi Jorn,
I have read all of the above posts and will try to give you all the info you
need.
Just upgraded to MOAP 2008. Runs on server 2003/SQL 2005 Std.
Server is brand new running new Dual Xeon Quad 2.66GHz 5430 with 4GB RAM
RAID 5 with 7 Raptor 150GB. Right now MOAP is the only app running on this
server.

Clients are Core 2 Duo 2.4GHz with 2GB RAM with Vista Business x86 and
Office 2007

Problem:When creating a new purchase order, you click the dropdown for
vendor name and select the name. app freezes right there with no CPU
activity but about a steady 4% network activity on a 100Mbps LAN. If you
wait it out, about 1-2 minutes, the app comes back to life and you can go and
fill out the purchase order. If, after waiting for the first vendor to fill
in, you select a different vendor you have the same 1-2 minute wait. If you
do the new create purchase order from invoice it is fast with no delays.
This is the only thing that is slow in all of MOAP.

I can recreate the problem on the server also but it is a little different.
The wait is about 15 seconds with only 1 core doing about 70% load.

When this issue was first discovered on the client, network activity was
about 1% and it took about 5 minutes for the app to respond. I did a repair
in Data Tools and that is when we started getting 4% network activity.

All in all, I think this is a database issue. Any suggestions are greatly
appreciated.

Kyle
 
Ad

Advertisements

J

Jorn L M \(MS\)

follow-up questions:

- how many vendors do you have in your system?
- do you see the same on the sales order side? if so; how many customers do
you have?
- how much memory is the SQL server using on the server after you do this?
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

running very slow 4
Very slow operations 3
RMS is VERY SLOW 12
QB4 Running Very Slow... 1
Very Slow Transaction Post 1
Money 2005 very slow 2
Money 2003 is VERY SLOW. 4
Pulling up previews very slow... 0

Top