Navision 2009 SQL-Server periodically slow (white screens)

Frederik

Hello,

We are randomly experiencing white screens, Navision runs periodically slow, but another time its running normal doing the same things.
I do not really know where to start searching for the reason.
We've a good server with the SQL database on multiple disk systems so the hardware the Navision runs on is ok, but we are experiencing this "white screens" during which Navision does not respond for e.g. 10 or 20 seconds.
I've been thinking this could be due other users are doing things that cause to run Navision slow on the other session. Though I've no idea if there is a way to monitor user activity.
Is there any way to find out where the performance drops come from?

With kind regards,

Frederik

vremeni4

Hi,

Without further investigation it is difficult to say what may be the reason for this.
Anyhow I suspect a blocking(deadlock/locking) issue.
You can find more information about blocking here
http://blogs.msdn.com/b/microsoft_dynamics_nav_sustained_engineering/archive/2008/02/20/how-to-detect-locking-order-for-a-nav-process.aspx
You can also install an SQL script that will monitor Blocks and deadlocks.
http://dynamicsuser.net/blogs/stryk/archive/2008/11/03/blocks-amp-deadlocks-in-nav-with-sql-server.aspx

On the other hand it is also possible that this issue is caused by Hard drives being very busy at a particular time.
It may be also worth using SQL Activity Monitor to see what is going on at that moment in time.
http://technet.microsoft.com/en-us/library/ms175518.aspx

I would also advice to run SQL profile and get some information, what is going on
http://www.youtube.com/watch?v=iGKG9ijE_ks&noredirect=1

I hope this helps.

bbrown

The symptoms you describe indicate general slow performance which results in blocking. These are not the symptoms of deadlocks. Deadlocks would result from conflciting locking sequences and result is user processes failing with explicit deadlock errors. Blocking is the result of excessive duration locking causing delays in other processes. Both bad, but different problems.

Can you provide some details about your system? Include the hardware info also. So we have it. Plus things like NAV version, db size, user count, etc.