Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Yes, it is definitely possible to store multiple application logs in a central location using EL. </p> <p>An Enterprise Dashboard application that lets you view exceptions across applications and tiers, and provides reporting is a great reason to centralize your logging. So I'll say yes to question b as well.</p> <h3>Possible Issues/Negatives</h3> <p>I'm assuming that you are using the Database Trace Listener since you mention that in your question. If there are a large number of applications logging a large number of log entries combined with users querying the (potentially large) log database, there is the potential for performance to degrade (since the logging is done synchronously) which could impact your application performance. <br></p> <h3>Another Approach</h3> <p>To mitigate against this possibility, I would investigate <a href="http://msdn.microsoft.com/en-us/library/cc511849.aspx" rel="nofollow noreferrer">using the Distributor Service</a> to log asynchronously. In that model, all of the applications would log to a message queue (using the MSMQ Trace Listener). A separate service then polls the queue and would forward the log entries to a trace listener (in your case a Database Trace Listener) which would persist the messages in your dashboard database. This setup <strong>is</strong> more complicated. But it does seem to align with what you are trying to achieve and has some other benefits such as asynchronous processing and the ability to log even if the dashboard database is down (e.g. for maintenance).</p> <h3>Other Considerations</h3> <p>You may also want to think about standardizing some LogEntry properties across applications. For example, LogEntry doesn't really have an "application" property so you could add an ExtendedProperty to represent the application name. Or you may standardize on a specific format for the Message property so that various information can be pulled out of the message and stored in separate database columns for easier searching and categorization.</p>
    singulars
    1. This table or related slice is empty.
    1. POCan MS Enterprise Library Logging be used for multiple applications?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRandy Levy
    1. USRandy Levy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCan MS Enterprise Library Logging be used for multiple applications?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYes I'm using the Database Trace Listener. One of the first apps to use it is about to be refactored to use MSMQ so I can take that experience and apply it to my logging. Thanks for bringing the Distributer Service and ExtendedProperty(ies) to my attention too. And thanks for helping out a fellow Torontonian :)
      singulars
      1. PO
      1. UStforster
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload