The SQLCMD variables in the SsasEventsAnalyzerDB project need to be documented.

[byobi]

All SQLCMD variables in the SsasEventsAnalyzerDB project (shown below) need to be documented as they will differ from installation to installation...

[byobi]

• flg_create_sql_agent_jobs
  • determines if sql agent jobs are created during post-deployment (1 = yes, 0 = no)
  • default value = 1
• flg_xevent_decode_load
  • determines if xevent decode lookup table is populated during post-deployment (1 = yes, 0 = no)
  • default value = 1
• powershell_exe_path
  • path to powershell executable on target system
  • default value = C:\Windows\System32\WindowsPowerShell\v1.0\Powershell.exe
• powershell_script_dir
  • path to directory where powershell scripts are deployed
  • default value = C:\SsasEventsAnalyzer\powershell_scripts\
• Process_xEventFiles_JobName
  • name of SQL agent job for processing xEvent files
  • default value = Process-xEventFiles
• ssas_events_analyzer_server
  • name of server to monitor
  • default value = SQL-DEV-02
• ssas_instance
  • name of ssas instance to monitor
  • default value = SQL-DEV-02\SSAS_TAB
• StartProcessTrace_JobName
  • name of SQL agent job for starting Processing xEvent trace
  • default value = xEventProcessTrace-Start
• StartQueryTrace_JobName
  • name of SQL agent job for starting Query xEvent trace
  • default value = xEventQueryTrace-Start
• start_process_trace_post_deployment
  • determines if processing trace starts immediately after deployment (1 = yes, 0 = no)
  • default value = 0
• start_query_trace_post_deployment
  • determines if query trace starts immediately after deployment (1 = yes, 0 = no)
  • default value = 0
• StopProcessTrace_JobName
  • name of SQL agent job for stopping Processing xEvent trace
  • default value = xEventProcessTrace-Stop
• StopQueryTrace_JobName
  • name of SQL agent job for stopping Query xEvent trace
  • default value = xEventQueryTrace-Stop
• xevent_decode_source_filepath
  • path to trace definition xml file used as source for xEvent decode table
  • default value = C:\Program Files\Microsoft SQL Server\MSAS13.SSAS_TAB\OLAP\bin\Resources\1033\tracedefinition130.xml
• xevent_trace_archive_dir
  • xevent trace files are "archived" in this directory after being shredded
  • default value = C:\Program Files\Microsoft SQL Server\MSAS13.SSAS_TAB\OLAP\Log\xevent_trace_archive
• xevent_trace_dir
  • directory where xevent files are created (by default this is the LogDir for the SSAS instance)
  • default value = C:\Program Files\Microsoft SQL Server\MSAS13.SSAS_TAB\OLAP\Log\
• xevent_trace_processing_dir
  • xevent trace files are moved to this directory before being shredded
  • default value = C:\Program Files\Microsoft SQL Server\MSAS13.SSAS_TAB\OLAP\Log\xevent_trace_processing