Simple query to check the recent performance history

Geek Lectures - Things geeks should know about » Blog Archive » Simple query to check the recent performance history

Fri, 04 Jan 2008 17:28:35 GMT

PingBack from http://geeklectures.info/2008/01/04/simple-query-to-check-the-recent-performance-history/

re: Simple query to check the recent performance history

GaspodeTheWonderDog — Thu, 28 Feb 2008 07:04:03 GMT

When I execute the query against my SQL 2005 database I get an error:

Msg 102, Level 15, State 1, Line 25

Incorrect syntax near '.'.

I just copied and pasted it from above. I realise it probably works for you but have you any idea why it doesn't work for me?

re: Simple query to check the recent performance history

Lohndorf — Thu, 28 Feb 2008 11:17:38 GMT

Hi GaspodeTheWonderDog,

Can it be that the compatibility level for either the Nav database, or for Master, is set to SQL2000?

Im not sure how to check this, but you can use sp_dbcmptlevel to change it.

Will be interesting if you can come back, and let us know if this is the problem.

re: Simple query to check the recent performance history

GaspodeTheWonderDog — Thu, 28 Feb 2008 22:42:34 GMT

I read your comment and knew you were right even before I opened the database to look! I have tested it now and yes this is the cause.

I upgraded the database from an old SQL2000 database using a database restore and didn't change the compatability level.

Thanks for your help. This has to be the best blog on NAV there is.

Cheers,

Dave.

SQLIndex property

Microsoft Dynamics NAV Sustained Engineering Team Blog — Tue, 22 Apr 2008 12:26:27 GMT

In some situations, using the SQLIndex property on a key in Microsoft Dynamics NAV can harm performance.

SQLIndex property

Microsoft Dynamics NAV Sustained Engineering Team Blog — Tue, 22 Apr 2008 18:51:50 GMT

In some situations, using the SQLIndex property on a key in Microsoft Dynamics NAV can harm performance

Modern NAV/SQL troubleshooting

Microsoft Dynamics NAV Sustained Engineering Team Blog — Tue, 13 May 2008 11:57:42 GMT

This post is the first in a planned series to describe various "modern" methods for troubleshooting performance

Modern NAV/SQL troubleshooting

Microsoft Dynamics NAV Sustained Engineering Team Blog — Tue, 13 May 2008 20:27:19 GMT

This post is the first in a planned series to describe various "modern" methods for troubleshooting

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

Microsoft Dynamics NAV Sustained Engineering Team Blog — Tue, 14 Oct 2008 13:25:19 GMT

One of the queries I use the most, is the pplan-cache query from this post: Simple query to check the

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

Microsoft Dynamics NAV Sustained Engineering Team Blog — Thu, 16 Oct 2008 02:10:48 GMT

One of the queries I use the most, is the pplan-cache query from this post: Simple query to check the

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

Microsoft Dynamics NAV Sustained Engineering Team — Tue, 28 Oct 2008 17:53:32 GMT

One of the queries I use the most, is the pplan-cache query from this post: Simple query to check the

re: Simple query to check the recent performance history

pdj — Wed, 01 Apr 2009 12:45:25 GMT

Hi Lars,

I really like this query, but I have problems re-creating the troublesome statements in a Query window due to the prepare/execute method introduced in NAV5SP1. Could you please explain how to execute the SQL statements the-NAV-way? Either here, or in this thread: http://mibuso.com/forum/viewtopic.php?f=34&t=33102

Thanks in advance

Peter