Thanks for the hint!

Well, "hardening" a NAV database outside the internal NAV security system is actually a really mean issue. Once this "$ndo$shadow" role was bypassed - e.g. simply using...

Yeah ... you made my day 😛

This works!

Small thing with tremendous impact ...

THANKS a lot!

Best regards,

Jörg

You're welcome - I'm always glad if I could help 🙂

Hi!

Well, here - http://dynamicsuser.net/blogs/stryk/archive/2008/11/03/blocks-amp-deadlocks-in-nav-with-sql-server.aspx - I describe how I deal with blocks & deadlocks, incl. several code examples.

(Have in min that I'm a NAV-developer and probably my TSQL is not...

Hi!

So, finally we found out what was causing this "overload": it always happens when the DBCC INDEXDEFRAG was executed!

We supposed the DEFRAG being the "smoother" (but less effective) one, but...

Hi!

Here ...

http://dynamicsuser.net/blogs/stryk/archive/2008/11/03/blocks-amp-deadlocks-in-nav-with-sql-server.aspx

... I have described how I deal with blocks & deadlocks; which processes I establish to monitor, analyze, etc. including several TSQL Code templates.

The examples given there are all...

Well, I guess "lightweight pooling" should be handled with care. I found this KB article: http://support.microsoft.com/kb/319942/en-us

Lightweight Pooling

By default, SQL Server uses one thread per active SPID or user process. These...

Is "Hyper-Threading" enabled on that box? This could be a reason ...

Or do you have any special "Affinity Masks" set?

To reduce the number of "Context Switches" you could try to...

Thanks for your reply. I'll try the BULK thing and come back with the results ASAP!

Well, if there is a "long running query" and I need to find the reason for "why" it is running so long, I proceed like this:

1. Run SQL Profiler; searching...

RAID = Redundant Array of Independent Disks

There are a lot of different types, just to point out the most important ones:

0 (Striping): Data is striped over multiple disks; this reduced...

Hi!

Uhh ... just to add my "two cents" ... you are not talking about a backup taken from "Microsot Dynamics NAV (Navision)"? Because there is a proprietary Backup-Feature - even...