Nav 3.10 became slow maybe this week it started..

yuppicide

Navision has become a little slow lately.. maybe the past week. Here and there the hourglass pops up for maybe 3 - 5 seconds each time. It's never done this before.

People have been complaining, but I don't know what to tell them since it's never happened before. I haven't done any modification to Navision or any server changes. Far as I know we've had no power outages or anything.

We have our 2011 line of clothing coming out and recently we created a bunch of new item cards. Most of the items are entered already, but we do find 1 here and there that we missed. We just came back from a large tradeshow and it was pretty good, so we're entering a bunch of orders.

Any ideas of something I should look at ... we have 10 licenses and right now 5 of them are in use, although 1 of the people is out of the office right now so not really using. Right now 3 of us are entering orders at the same time.

Looking at the database information it says the following:

Database Used (KB) 5894568 84%
Database Size (KB) 7000000 11%
Licensed Size (KB) 65536000
DBMS Cache (KB) 332800
Commit Cache not checked off
Object Cache (KB) 8000

We're over TCP. We have a server dedicated for Navision (not sure of the specs off hand) on WIN2K, our main server where we login, store files runs WIN2003SBS, and our machines all run WINXP Pro with latest updates.

Maybe something just needs to be rebooted? I'd be worried about rebooting the Navision server if I had to, since it's something I've never done before. I may have accidentally done it once while fixing the battery backup.

Just thought I'd gather up as much information as I could for the post, so some of that might not be necessary.

Savatage

We had crappy DBMS Chache settings too until I followed Kriki's Blog & How To.

Blog:
http://mibuso.com/blogs/kriki/2008/05/2 ... -database/
How to:
http://www.mibuso.com/howtoinfo.asp?FileID=10

I would suggest commit cache to YES
And you'll see in the how to.. Stop the service & Restart it with Start Parameters
CACHE=850000
COMMITCACHE=YES

ps where is this hourglass poping up? everywhere? or sales orders or during posting?

I would also drop the database used to around 70-75% by expanding your database.
Do you have the DB split onto multiple drives?
* Don't let the slowest PC post orders

Got $1500 burning a hole in your pocket?
http://cgi.ebay.com/ws/eBayISAPI.dll?Vi ... :MEWAX:VRI
oooh!
http://cgi.ebay.com/Dell-PowerEdge-6600 ... 1c08f2e1cd
I love these make an offer ones - I've never been turned down by asking for $200.00 less.

yuppicide

$1500 burning a hole in "the company" pocket you mean. I wish. I can't even get them to buy us new computers like we discussed in the past.

I was upset yesterday because I was busy at work and I missed snagging a $200+ video card (for my personal use) on eBay.. it ended up for 99 cents with 0 bids! Seller didn't end auction early either.. it ended on it's own! Shipping was $17 bucks, but that's still worth it.

yuppicide

BTW, what does commit cache do?

You know if I goto File, Database, Information it gives me what I posted to you above.

If I goto tools and options I have both cache as 8000 and Commit Cache Yes.

It's been a long time. I forget how to change database size.

Savatage

review the blogs & how to - posted above.

These changes need to be made on the server. You'll have to stop the server.
Administratove tools->Services - Scroll thru to you see Navserver - it''s called something like that - you'll stop the server & when restarting you'll have to add in the parameters yourself - see step 6 of howto "changing the parameter on the service".

yuppicide

Yep. I read that link. I've looked at the scripts and see they're harmless. I'll do the recommended 10% of DB used space. So, I can just copy over those two files, browse to that drive from My Computer, and double click the cmd file to make it run?

Looking in Navision, our DB is on E:\Attain Data\Filename.fdb

On my computer E: is a DVD burner.. I have that drive mapped as R:.. should I map it to E: instead?

What I don't see on those links is how I change the database size. I did it one other time, but forget how.

Savatage

Drill into the database name if you see one entry then your DB is not split.
E is the drive it's on in the server.

Mine is:
E:\Database\database.fdb 23000000
F:\Database\database1.fdb 23000000

I'm just about to move my database to a new server.
Right now it's on two raid 1 scsi 15k drives.
I will be splitting it to 6! MORE HEADS MORE SPEED.
\Database\database.fdb
E:\Database\database1.fdb
F:\Database\database2.fdb
G:\Database\database3.fdb
H:\Database\database.4fdb
I:\Database\database5.fdb
So I have to install the server software. I just need to find some time.

When I do I'll see If I can make a video that you can review.

One thing I will be using is this old download that help tremendously the last time.
Nice wizard - lets you put in all the correct parameters:
http://www.mibuso.com/dlinfo.asp?FileID=304

Savatage

yuppicide wrote:

It's been a long time. I forget how to change database size.

File-> database -> Expand

then enter a value in the ADD field.
If you have a split database use ADVANCED Button
http://www.youtube.com/watch?v=g0rnMk47wXY

Be careful how much you add - you just want to get around 70%.
It's easier to add then to remove so don't just add some huge #

Savatage

Here's how you can change the parameters of your native server.
YOu have to do this on the server. PS Everyone should be out of nav before shutting down the service.

The server starts out with 750000 DBMS & Commit Cache = NO
First demo I will change DBMS Cache from 750000 to 795000
Then log backinto nav so you can see.
second demo change Commit Cache from No to YEs
log back in so you can see.

Note..I know my limit on this demo server is 795000.
The service won't start on 800000.

So basically start out with trying 950000. If it starts then great, if not keep bringing down the number until it does.
950000
940000
930000
etc.
http://www.youtube.com/watch?v=tNczFWMwNZg

You asked about commit cache before - here's a good explanation
http://wiki.dynamicsbook.com/index.php? ... mmit_cache

To get to the services - Administrative Tools->Services

yuppicide

I finally got around to doing this today, thanks. I've expanded the database and I'm using about 65% right now.

As for the DBMS cache, I'm not sure what is up..

When I try it with the cmd file or with that handy software you pointed me to in Navision it says 332800 and Commit Cache is unchecked.

If I run the file server.exe it reports correctly. Here's a screen shot:



As you can see I doubled the number that was there, although I forget what amount of memory the server has since I don't have access to it.. unless there's a way to see remotely.

David_Singleton

Just in case anyone else reads this thread and does the same.

NEVER expand a database without a full and tested backup. During the expand process, the version principle is switched off, so if anything happens, the database is dead, and even C/DART probably wont recover it.