Axaptapedia is now maintained by AgileCadence For more information please click here.

SQLServerFetchCount

From Axaptapedia
Jump to: navigation, search

Description[edit]

Here is a small job that can be used to experiment with the CacheLookup property on tables. try it out in 2 tier and 3 tier and compare the results.

My results[edit]

Here is what I got on a 2tier installation:

Tutorial SQLServerFetchCount.PNG

Download[edit]

Download the job

this job will work best on Axapta 3. Since Axapta 4 the used SystemMonitor is only an empty hull without any functionality inside - so you'll have to use the sql-trace (don't forget to allow the client-trace on aos-server!)

See also[edit]

Original post about this job