Is it possible to see what has happened to an app in the past 2 weeks?

[Huiying]

Hi

I'm new in trouble shooting. A customer reported that everything works well 2 weeks ago. But during the past 2 weeks, they have serious performance issue.

The app is 6gb big. I plan to use Document Analyzer to check the app. But it would be nice to know what has happened 2 weeks ago to make the performance unbearable.

Could you give me some hints where to start?

Best regards,

Susan

[marcus_sommer]

It sounds that there is something wrong in the datamodel maybe there are some fields missing or too much respectively renamed in any way and now are any joins out of control and/or it creates any synthetic keys or circular loops or something similar.

Maybe a few glances with the tableviewer might be make clear what's happening and if not a comparing of the document- and task-logs from the last few weeks will be quite helpful to detect any differences (these logs are within the program data of the distribution service).

- Marcus