Home
%3CLINGO-SUB%20id%3D%22lingo-sub-388214%22%20slang%3D%22en-US%22%3ETroubleshooting%20logging%20improvement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388214%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Jun%2002%2C%202015%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20%3CB%3E%20Troubleshooting%20logging%20improvement%20%3C%2FB%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20In%20the%20SQL%20Server%202016%2C%20we%20did%20logging%20improvement%20to%20improve%20the%20debug%20ability%20and%20make%20the%20troubleshooting%20easier.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E1.%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Tracing%20setting%20in%20the%20web.config%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3CSOURCES%3E%3C%2FSOURCES%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C!--%20Adjust%20the%20switch%20value%20to%20control%20the%20types%20of%20messages%20that%20should%20be%20logged.%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fsystem.diagnostics.sourcelevels%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttp%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fsystem.diagnostics.sourcelevels%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EUse%20the%20a%20switchValue%20of%20Verbose%20to%20generate%20a%20full%20log.%20Please%20be%20aware%20that%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3Ethe%20trace%20file%20can%20get%20quite%20large%20very%20quickly%20--%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3CSOURCE%20name%3D%22%26quot%3BMDS%26quot%3B%22%20switchtype%3D%22%26quot%3BSystem.Diagnostics.SourceSwitch%26quot%3B%22%20switchvalue%3D%22%26quot%3BWarning%2C%22%20activitytracing%3D%22%22%3E%3C%2FSOURCE%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3CLISTENERS%3E%3C%2FLISTENERS%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C!--%20Set%20a%20directory%20path%20where%20the%20service%20account%20you%20chose%20while%20setting%20up%20Master%20Data%20Services%20has%20read%20and%20write%20privileges.%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EDefault%20path%20is%20Logs%20in%20WebApplication%20folder%2C%20for%20example%20C%3A%5CProgram%20Files%5CMicrosoft%20SQL%20Server%5C130%5CMaster%20Data%20Services%5CWebApplication%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3ENew%20log%20file%20will%20be%20created%20everyday%20or%20every%2010%20mb.%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EWhen%20directory%20size%20hits%20the%20200mb%20limitation%2C%20the%20oldest%20file%20will%20be%20deleted.--%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3CADD%20name%3D%22%26quot%3BFileTraceListener%26quot%3B%26lt%3B%2FP%22%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3C%2FADD%3E%3C%2FP%3E%3CP%3Etype%3D%22Microsoft.MasterDataServices.Core.Logging.FileTraceListener%2C%20Microsoft.MasterDataServices.Core%22%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EinitializeData%3D%22DirectoryPath%20%3D%20Logs%3B%20FileSizeInMb%20%3D%2010%3B%20MaxDirectorySizeInMb%20%3D%20200%22%2F%26gt%3B%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3CREMOVE%20name%3D%22%26quot%3BDefault%26quot%3B%2F%22%3E%3C%2FREMOVE%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EWe%20have%20a%20new%20section%20in%20the%20web.config%20for%20tracing%20setting.%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EBy%20default%2C%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3Ea.%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Tracing%20is%20enabled%20for%20Warning%20and%20below%20level%2C%20plus%20ActivityTracing.%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3Eb.%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20The%20Logs%20are%20saved%20in%20the%20Logs%20folder%20under%20the%20WebApplication%20folder.%20For%20example%2C%20C%3A%5CProgram%20Files%5CMicrosoft%20SQL%20Server%5C130%5CMaster%20Data%20Services%5CWebApplication%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3Ec.%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20The%20file%20file%20will%20be%20created%20for%20each%20day%20or%20every%2010%20mb%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3Ed.%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Maximum%20usage%20on%20Logs%20folder%20will%20be%20200mb%2C%20the%20oldest%20log%20will%20be%20deleted.%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3Ee.%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20The%20log%20format%20is%20CSV.%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E2.%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Log%20format%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CTABLE%3E%0A%20%20%20%3CTBODY%3E%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CP%3ETime%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CP%3EWhen%20the%20trace%20entry%20happens%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CP%3ECorrelationId%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CP%3EOne%20correlation%20id%20is%20assigned%20for%20each%20request.%20The%20all%20the%20traced%20trigged%20by%20this%20request%20will%20share%20the%20same%20correlation%20id.%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CP%3EOperation%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CP%3EThe%20request%20operation%20name.%20If%20the%20request%20is%20web%20ui%20request%2C%20the%20operation%20name%20is%20the%20url.%20If%20request%20is%20API%20request%2C%20the%20operation%20name%20is%20the%20service%20name.%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CP%3ELevel%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CP%3EThe%20level%20of%20this%20trace%20entry.%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CP%3EMessage%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CP%3EThe%20message%20body%20of%20the%20trace%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%3C%2FTBODY%3E%3C%2FTABLE%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EThe%20log%20is%20CSV%20format%20and%20can%20be%20opened%20in%20Microsoft%20Excel%20or%20other%20tools%20for%20filtering.%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E3.%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Correlation%20Id%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EEach%20request%20will%20be%20assign%20a%20correlation%20id%2C%20the%20all%20trace%20trigger%20by%20this%20request%20will%20share%20the%20same%20id.%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EWhen%20an%20error%20happens%2C%20in%20the%20UI%2C%20the%20correlation%20id%20will%20be%20shown%20in%20the%20error%20message.%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EWeb%20UI%3A%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F99870i7B7CEFC7C88617E0%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EExcel%20Addin%20UI%3A%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F99871iC6C87DC4C20360C1%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20t.com%2Fen-us%2Flibrary%2Fsystem.diagnostics.sourcelevels%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Use%20the%20a%20switchValue%20of%20Verbose%20to%20generate%20a%20full%20log.%20Please%20be%20aware%20that%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20the%20trace%20file%20can%20get%20quite%20large%20very%20quickly%20--%26gt%3B%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CSOURCE%20name%3D%22%26quot%3BMDS%26quot%3B%22%20switchtype%3D%22%26quot%3BSystem.Diagnostics.SourceSwitch%26quot%3B%22%20switchvalue%3D%22%26quot%3BWarning%2C%22%20activitytracing%3D%22%22%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CLISTENERS%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3C!--%20Set%20a%20directory%20path%20where%20the%20service%20account%20you%20chose%20while%20setting%20up%20Master%20Data%20Services%20has%20read%20and%20write%20privileges.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Default%20path%20is%20Logs%20in%20WebApplication%20folder%2C%20for%20example%20C%3A%5CProgram%20Files%5CMicrosoft%20SQL%20Server%5C130%5CMaster%20Data%20Services%5CWebApplication%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20New%20log%20file%20will%20be%20created%20everyday%20or%20every%2010%20mb.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20When%20directory%20size%20hits%20the%20200mb%20limitation%2C%20the%20oldest%20file%20will%20be%20deleted.--%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CADD%20name%3D%22%26quot%3BFileTraceListener%26quot%3B%22%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20type%3D%22Microsoft.MasterDataServices.Core.Logging.FileTraceListener%2C%20Microsoft.MasterDataServices.Core%22%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20initializeData%3D%22DirectoryPath%20%3D%20Logs%3B%20FileSizeInMb%20%3D%2010%3B%20MaxDirectorySizeInMb%20%3D%20200%22%2F%26gt%3B%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CREMOVE%20name%3D%22%26quot%3BDefault%26quot%3B%2F%22%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3C%2FREMOVE%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3C%2FADD%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3C%2FLISTENERS%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20We%20have%20a%20new%20section%20in%20the%20web.config%20for%20tracing%20setting.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20By%20default%2C%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20a.%20Tracing%20is%20enabled%20for%20Warning%20and%20below%20level%2C%20plus%20ActivityTracing.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20b.%20The%20Logs%20are%20saved%20in%20the%20Logs%20folder%20under%20the%20WebApplication%20folder.%20For%20example%2C%20C%3A%5CProgram%20Files%5CMicrosoft%20SQL%20Server%5C130%5CMaster%20Data%20Services%5CWebApplication%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20c.%20The%20file%20file%20will%20be%20created%20for%20each%20day%20or%20every%2010%20mb%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20d.%20Maximum%20usage%20on%20Logs%20folder%20will%20be%20200mb%2C%20the%20oldest%20log%20will%20be%20deleted.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20e.%20The%20log%20format%20is%20CSV.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%202.%20Log%20format%3C%2FSOURCE%3E%3C%2FP%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CTABLE%3E%0A%20%20%20%3CTBODY%3E%3CTR%3E%0A%20%20%20%20%3CTD%3ETime%3CP%3E%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CP%3EWhen%20the%20trace%20entry%20happens%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CP%3ECorrelationId%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CP%3EOne%20correlation%20id%20is%20assigned%20for%20each%20request.%20The%20all%20the%20traced%20trigged%20by%20this%20request%20will%20share%20the%20same%20correlation%20id.%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CP%3EOperation%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CP%3EThe%20request%20operation%20name.%20If%20the%20request%20is%20web%20ui%20request%2C%20the%20operation%20name%20is%20the%20url.%20If%20request%20is%20API%20request%2C%20the%20operation%20name%20is%20the%20service%20name.%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CP%3ELevel%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CP%3EThe%20level%20of%20this%20trace%20entry.%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%20%3CTR%3E%0A%20%20%20%20%3CTD%3E%3CP%3EMessage%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%20%3CTD%3E%3CP%3EThe%20message%20body%20of%20the%20trace%3C%2FP%3E%0A%20%20%20%20%3C%2FTD%3E%0A%20%20%20%3C%2FTR%3E%0A%20%20%3C%2FTBODY%3E%3C%2FTABLE%3E%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3CP%3EThe%20log%20is%20CSV%20format%20and%20can%20be%20opened%20in%20Microsoft%20Excel%20or%20other%20tools%20for%20filtering.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%203.%20Correlation%20Id%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Each%20request%20will%20be%20assign%20a%20correlation%20id%2C%20the%20all%20trace%20trigger%20by%20this%20request%20will%20share%20the%20same%20id.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20When%20an%20error%20happens%2C%20in%20the%20UI%2C%20the%20correlation%20id%20will%20be%20shown%20in%20the%20error%20message.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Web%20UI%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F99872i39752827537C0A3B%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Excel%20Addin%20UI%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F99873iD3CCB86899974528%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CSTRONG%3E%20For%20more%20information%3A%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%3CBLOCKQUOTE%3E%0A%20%20%20%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fmt163700(v%3Dsql.130).aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Tracing%20(Master%20Data%20Services)%20%3C%2FA%3E%3C%2FP%3E%0A%20%20%3C%2FBLOCKQUOTE%3E%0A%20%0A%3CLINGO-TEASER%20id%3D%22lingo-teaser-388214%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jun%2002%2C%202015%20Troubleshooting%20logging%20improvementIn%20the%20SQL%20Server%202016%2C%20we%20did%20logging%20improvement%20to%20improve%20the%20debug%20ability%20and%20make%20the%20troubleshooting%20easier.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388214%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Emaster%20data%20services%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Emds%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%202016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esql2016%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Not applicable
First published on MSDN on Jun 02, 2015
Troubleshooting logging improvement

In the SQL Server 2016, we did logging improvement to improve the debug ability and make the troubleshooting easier.

1.       Tracing setting in the web.config



<sources>



<!-- Adjust the switch value to control the types of messages that should be logged.



http://msdn.microsoft.com/en-us/library/system.diagnostics.sourcelevels



Use the a switchValue of Verbose to generate a full log. Please be aware that



the trace file can get quite large very quickly -->



<source name="MDS" switchType="System.Diagnostics.SourceSwitch" switchValue="Warning, ActivityTracing">



<listeners>



<!-- Set a directory path where the service account you chose while setting up Master Data Services has read and write privileges.



Default path is Logs in WebApplication folder, for example C:\Program Files\Microsoft SQL Server\130\Master Data Services\WebApplication



New log file will be created everyday or every 10 mb.



When directory size hits the 200mb limitation, the oldest file will be deleted.-->



<add name="FileTraceListener"



type="Microsoft.MasterDataServices.Core.Logging.FileTraceListener, Microsoft.MasterDataServices.Core"



initializeData="DirectoryPath = Logs; FileSizeInMb = 10; MaxDirectorySizeInMb = 200"/>



<remove name="Default"/>



</listeners>



</source>



</sources>



We have a new section in the web.config for tracing setting.



By default,



a.       Tracing is enabled for Warning and below level, plus ActivityTracing.



b.      The Logs are saved in the Logs folder under the WebApplication folder. For example, C:\Program Files\Microsoft SQL Server\130\Master Data Services\WebApplication



c.       The file file will be created for each day or every 10 mb



d.      Maximum usage on Logs folder will be 200mb, the oldest log will be deleted.



e.      The log format is CSV.



2.       Log format





Time

When the trace entry happens

CorrelationId

One correlation id is assigned for each request. The all the traced trigged by this request will share the same correlation id.

Operation

The request operation name. If the request is web ui request, the operation name is the url. If request is API request, the operation name is the service name.

Level

The level of this trace entry.

Message

The message body of the trace





The log is CSV format and can be opened in Microsoft Excel or other tools for filtering.





3.       Correlation Id



Each request will be assign a correlation id, the all trace trigger by this request will share the same id.



When an error happens, in the UI, the correlation id will be shown in the error message.





Web UI:







Excel Addin UI:







t.com/en-us/library/system.diagnostics.sourcelevels

Use the a switchValue of Verbose to generate a full log. Please be aware that

the trace file can get quite large very quickly -->

<source name="MDS" switchType="System.Diagnostics.SourceSwitch" switchValue="Warning, ActivityTracing">

<listeners>

<!-- Set a directory path where the service account you chose while setting up Master Data Services has read and write privileges.

Default path is Logs in WebApplication folder, for example C:\Program Files\Microsoft SQL Server\130\Master Data Services\WebApplication

New log file will be created everyday or every 10 mb.

When directory size hits the 200mb limitation, the oldest file will be deleted.-->

<add name="FileTraceListener"

type="Microsoft.MasterDataServices.Core.Logging.FileTraceListener, Microsoft.MasterDataServices.Core"

initializeData="DirectoryPath = Logs; FileSizeInMb = 10; MaxDirectorySizeInMb = 200"/>

<remove name="Default"/>

</listeners>

</source>

</sources>

We have a new section in the web.config for tracing setting.

By default,

a. Tracing is enabled for Warning and below level, plus ActivityTracing.

b. The Logs are saved in the Logs folder under the WebApplication folder. For example, C:\Program Files\Microsoft SQL Server\130\Master Data Services\WebApplication

c. The file file will be created for each day or every 10 mb

d. Maximum usage on Logs folder will be 200mb, the oldest log will be deleted.

e. The log format is CSV.

2. Log format



Time

When the trace entry happens

CorrelationId

One correlation id is assigned for each request. The all the traced trigged by this request will share the same correlation id.

Operation

The request operation name. If the request is web ui request, the operation name is the url. If request is API request, the operation name is the service name.

Level

The level of this trace entry.

Message

The message body of the trace



The log is CSV format and can be opened in Microsoft Excel or other tools for filtering.

3. Correlation Id

Each request will be assign a correlation id, the all trace trigger by this request will share the same id.

When an error happens, in the UI, the correlation id will be shown in the error message.

Web UI:



Excel Addin UI:



For more information:

Tracing (Master Data Services)