Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Performance   (RSS)
Tuesday, August 25, 2009 3:09 PM

Table Information including Index information (Usage, Blocks and Reads)

== Nov 9 update == In some cases we got integer overflow when running this query. So the table definitions in the query have now changed from using int to bigint to avoid this. == end of update == The query below combines these three queries into one:
Posted by navblog | 0 Comments
Filed under: , ,
Tuesday, May 19, 2009 2:02 PM

How to use WCF Performance Counters with NAV 2009 Server

NAV Server (middle tier) utilises Windows Communication Foundations (WCF), which includes a number of performance counters that you can use to monitor NAV Server performance in real-time. This example shows how to monitor "Calls Per Second" for NAV Server
Posted by navblog | 0 Comments
Filed under: ,
Friday, February 20, 2009 10:33 AM

Cursor Types

One of the changes in Microsoft Dynamics NAV version 5, was to change from primarily making use of Fast-Forward cursor types to Dynamic cursors. The same change was implemented in version 4 from build 26410, which is Version 4, SP3 Update6(940718) + KB950920.
Posted by navblog | 0 Comments
Tuesday, October 14, 2008 10:27 AM

Simple query to check the recent performance history II - now including Query Plan information

One of the queries I use the most, is the pplan-cache query from this post: Simple query to check the recent performance history The good thing about the query is that it shows information that could otherwise require a lot of work (collecting and analysing
Posted by navblog | 0 Comments
Filed under: , ,
Wednesday, June 11, 2008 10:11 AM

Modern NAV/SQL troubleshooting II

Please refer to this post about what I mean with "modern troubleshooting". This post describes methods that work on any version of SQL Server, including SQL2000. It describes one of the most common questions I get, which is "Where do we start"... General
Posted by navblog | 0 Comments
Filed under: , ,
Tuesday, June 03, 2008 10:10 AM

Microsoft Dynamics NAV 5.0 SP1 and SQL Server 2000

Microsoft Dynamics NAV 5.0 SP1 introduces a new way to handle SIFT. Instead of maintaining totals in separate tables, Dynamics NAV 5.0 SP1 uses a SQL feature called indexed views. Indexed views will automatically be maintained by the SQL Server. With
Posted by navblog | 0 Comments
Thursday, May 22, 2008 9:56 AM

What is the cost of maintaining an indexed view?

In previous versions, Microsoft Dynamics NAV maintains SIFT totals in SIFT tables. So updating the main table is done in one query. Updating the related SIFT tables is done by seperate queries run from triggers on the SQL tables. This makes it difficult
Posted by navblog | 0 Comments
Monday, May 12, 2008 9:47 AM

Modern NAV/SQL troubleshooting

This post is the first in a planned series to describe various "modern" methods for troubleshooting performance problems with Microsoft Dynamics NAV on SQL Server. The idea is also to make the best out of information that already exists, either in other
Posted by navblog | 0 Comments
Filed under: , ,
Monday, April 21, 2008 9:44 AM

SQLIndex property

In some situations, using the SQLIndex property on a key in Microsoft Dynamics NAV can harm performance. In this blog I describe what to be careful about, and why the use of this property has been removed in the NAV 5 SP1 application. The property is
Posted by navblog | 0 Comments
Filed under: , ,
Monday, April 14, 2008 9:42 AM

Bulk Inserts in Microsoft Dynamics NAV 5.0 SP1

Bulk Inserts is a new feature in NAV 5.0 SP1 which is designed to improve performance when inserting multiple records by delaying the physical inserts on the SQL Server. Before this change, inserts happen in the order that the C/AL code is running. With
Posted by navblog | 0 Comments
Friday, April 04, 2008 9:37 AM

My experiences with Microsoft Dynamics NAV 5.0 SP1

I spent last week performing a Microsoft Dynamics NAV 5.0 Update 1 to Microsoft Dynamics NAV 5.0 SP1 database conversion for a customer. The process went very smoothly and the customer was very excited about the increase in performance we were able to
Posted by navblog | 0 Comments
Filed under: , ,
Thursday, April 03, 2008 9:35 AM

SQL Pre-processing in Microsoft Dynamics NAV 5.0 SP1

One of the major changes in Microsoft Dynamics NAV version 5 SP1 (in relation to performance on SQL Server), is a new way to send queries to SQL Server. In previous versions of NAV, we some times saw SQL Server 2005 optimizing query plans for extreme
Posted by navblog | 0 Comments
Friday, March 28, 2008 9:30 AM

Simple query to check the recent blocking history

SQL Server 2005 keeps (some) history of the number and time that blocking occurred on indexes. This blog contains a query that queries this information to help identifying on which tables blocking happens most. The query shows accumulated numbers (no.
Posted by navblog | 0 Comments
Filed under: , ,
Tuesday, February 26, 2008 9:24 AM

Index Usage Query

This is a follow up from an earlier blog "Finding Index usage" . In that blog, I described a very simple way to list how indexes are being used. In this blog, the query is much extended so that it now shows your Navision keys, listed by either number
Posted by navblog | 0 Comments
Filed under: , ,
Wednesday, February 20, 2008 9:22 AM

How to detect locking order for a NAV process

The nature of a deadlock is that two processes lock resources in different orders. Deadlocks can in theory be eliminated by ensuring that all processes always lock resources in the same order. This document describes how to determine the locking order
Posted by navblog | 0 Comments
Filed under: , ,
More Posts Next page »
 
Page view tracker