axStart: missing indexes and caching

[Blog bot]

Источник: http://feedproxy.google.com/~r/axsta...RZiUo/Blog.php
==============

While analyzing performance in a huge implementation with BizTalk and AIF, I found the next missing Cluster indexes, Primary indexes and recID indexes.My personal opinion is that every table...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]


Источник: http://feedproxy.google.com/~r/axsta...RZiUo/Blog.php

[Vadik]

Удивительная история о том, как создав кластерный индекс на таблице AifAdapterLookup автор "did the job" "while analyzing performance in a huge implementation with BizTalk and AIF"

[axstart]

Vadik,
There is a lot of fun in AIF, all
Every time a new message is processed the table AIFSchemastore is get from db not cache,
If you add cache it still does not work The query use SchemaID and that is not indexed at al.

Next AIFRuntimeCache has a cluster index with a GUID in it. The insert is always somewhere in the middle.
Do you wane hear more?

[Vadik]

Hi stranger,
No offense, but the list of tables in your original blog post is irrelevant to AIF performance - that's why I could not help smiling. I have no doubt that you did your job well, but the nature of problem, performance metrics that were used and the solution itself are still not clear to me.
Glad to see that you fixed the 'self-diagnostics script'

Цитата:

Do you wane hear more?

Sure, I am waiting for next AIF related posts..

[axstart]

Vadik,
the point is that all AIF tables are not cached. so a lot of opsolete round trips between AOS and SQL every time a messages get's in.