Understanding EGDBHealth

yockee

Hi,

I am doing EGDBHealth check but I don't really understand some of the results. Couple of questions : 

From "Overview Context tab" pic :

1. There are 3 Criticals issues. They have different Queryelapsed times. For items 1 and 2 (AttachSizeSql and SqlSdeBintypeSize..) they have time < 100ms, why are the marked Critical ? Whereas the item #3 is Critical too with time > 100ms.

2. I find that QueryElapsedTime are italicized if they are >100ms. Why ? Is there any specific reason ?

From "Expert Context tab" pic :

3. Suppose that I do not want some parameters included in the examination of EGDBHealth. How do I omit those parameters because some of the evaluated parameters are OK ? 

4. Are there any specifics database parameters that directly associated with the values here ? 

I am using Oracle 12c and SDE 10.5

Thanks in advance

168 - OverviewContext Tab.png

168 - OverviewExpert Tab.png

DannyKrouk_ps

Hi Yockee,

I'm glad we're making progress.  On the last item, your #4 in your original email, when "Backups" (or anything else) shows up in the Name column, it does *not* indicate that backups are causing a performance problem.  Instead, it is indicating that there is *some kind of concern* with backups.  To find out the concern, you would follow the hyperlink to see the details.  Some themes (like statementsharing) mostly relate to performance (or scalability).  You can get a good sense of when this might be the case by the "category" column (to the left of the area captured in your screen capture).  There is, for example, a "Performance" category where all of the findings relate to performance.  

On your separate topic, "It is suggested that I should separate between SDE schema and User schema. How do I prove that such separation will increase performance?", I assume you mean that *someone* (not this tool) made that suggestion.  I think a good place to start is to ask that someone "why?" or "how does it increase performance?".  Maybe they don't know.  Or, maybe you don't have access to them.  So, you want to prove directly.  In principle, a time-measuring device on a client pointing to two systems whose only difference is this schema separation is all you need.  I do not know of a way to write a query on one of these system schema patterns that would tell you about its relative performance to another system schema pattern.  In general, I would be skeptical of this kind of advice.  Schemas are largely logical constructs.  Logical constructs do not have many direct tie-ins to performance.  Of course, there could be something that the recommender has in mind ... that isn't occurring to me.  That's why I would start by asking them why they hold this belief and what mechanisms they can point-to that would lead anyone else to hold that belief.

Thanks,

Danny