marcosqlbi/SsasEventsAnalyzer

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

byobi opened this issue · 1 comments

byobi commented

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

ssaseventsanalyzerdb-sqlcmd-variables

byobi commented
  • 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