Adjust the service log level as required

There are are 6 logging levels:
 

Level	Typical use
Fatal	Something bad happened; application is going down
Error	Something failed; application may or may not continue
Warn	Something unexpected; application will continue
Info	Normal behavior like mail sent, user updated profile etc.
Debug	For debugging; executed query, user authenticated, session expired
Trace	For trace debugging; begin method X, end method X

Note: By default, the logging is set to Warn. 

The services below write to the logging database.
This can be changed by going to each service configuration file location at:
 

Default Service Path	Service Name
C:\Program Files (x86)\SDL\SDL Server\Application\ApplicationService.exe.config	Application Service
C:\Program Files (x86)\SDL\SDL Server\Application\ExecutionService.exe.config	Execution Service
C:\Program Files\SDL\SDL Server\Custom Properties Service\nlog.config	Custom Properties Service
C:\Program Files\SDL\SDL Server\Editor Service\Sdl.EditorService.Host.exe.config	Editor Service
C:\Program Files\SDL\SDL Server\Editor Service Router\Sdl.EditorServiceRouter.Host.exe.config	Editor Service Router
C:\Program Files\SDL\SDL Server\FGAService\Sdl.FineGrainedAlignmentService.Agent.exe.config	Fine Grained Alignment
C:\Program Files\SDL\SDL Server\LanguageResourceService\Sdl.LanguageResourceService.Host.exe.config	Language Resource Service
C:\Program Files\SDL\SDL Server\Notification Service\nlog.config	Notification Service
C:\Program Files\SDL\SDL Server\Reporting Service\nlog.config	Reporting Service
C:\Program Files\SDL\SDL Server\Statistics Service\Sdl.StatisticsService.exe.config	Statistics Service
C:\Program Files\SDL\SDL Server\TMService\Sdl.TMService.Host.exe.config	TM Service Host
C:\Program Files\SDL\SDL Server\TMService\Sdl.TMService.Agent.exe.config	TM Service Agent
C:\Program Files (x86)\SDL\SDL Server\Management\nlog.config	GroupShare Resource Management Service
C:\Program Files\SDL\SDL Server\Translate And Analysis Service\nlog.config	Translate And Analysis Service
C:\Program Files\SDL\SDL Server\TranslationModelService\Sdl.TranslationModelService.Builder.exe.config	Translation Model Service Builder
C:\Program Files\SDL\SDL Server\TranslationModelService\Sdl.TranslationModelService.Host.exe.config	Translation Model Service Host
C:\Program Files\SDL\SDL Server\Verification Service\Sdl.Verification.Host.exe.config	Verification Service
C:\Program Files (x86)\SDL\SDL Server\File Processing Service\Sdl.Core.FileProcessingService.FpsExe.exe.config C:\Program Files (x86)\SDL\SDL Server\File Processing Service\Sdl.Core.FileProcessingService.FpsWindowsService.exe.config	File Processing Service

The services below are not writing to the logging database (their logging level can only be adjusted to writing data to logfiles).
C:\Program Files\SDL\SDL Server\BCM Service\NLog.config
C:\Program Files\SDL\SDL Server\Logging Service\nlog.config


To adjust the logging level for the database you need to adjust the following line

<logger minLevel="Warn" writeTo="database" />

To adjust the granularity of the information which is written in the log files adjust the following line

<logger minLevel="Warn" writeTo="logFile" />

Where 'Warn' = Logging level.

For example, you want to change the logging for TM Service Agent service to 'Debug':

Open the Sdl.TMService.Agent.exe.config located in C:\Program Files\SDL\SDL Server\TMService\ in a text/xml editor and change the following line:

<logger minLevel="Warn" writeTo="logFile" />

To

<logger minLevel="Debug" writeTo="logFile" />

Make sure you make the change for the line where it specifies writeTo="logFile", as you have the same line that writes to "coloredConsole" just above it.

The same procedure can be applied for writing into the database, however the line that needs to be adjusted contains writeTo="database"

Restart the service for which you have modified the logging level in order to apply the setting.

You require more information about occurring problems and the current log files do not contain enough information and therefore the logging level should be set to a level which includes all information about the interactions on application level. Therefore setting the log level to i.e. 'Debug' is needed.

Alternatively you notice that to much information is written into the database and the database size increases dramatically and it needs to be readjusted to reduce the amount or level of data logged.

More information about nlog can be found here.