marcosqlbi / SsasEventsAnalyzer

SSAS Events Analyzer
26 stars 9 forks source link

Automate installation #1

Open marcosqlbi opened 8 years ago

marcosqlbi commented 8 years ago

It would be nice to create an installation script with a minimal number of parameters that automatically creates the SQL Server Job Agents that activate trace events automatically. Now you have to manual edit and execute individual T-SQL and XAML scripts.

byobi commented 7 years ago

right now, a large percent of the configuration/setup is controlled in SsasEventsAnalyzerDB project via the use of SQLCMD variables (screenshot below)...

ssaseventsanalyzerdb-sqlcmd-variables

There will still be additional steps needed for proper installation. For example, the service account(s) used to run the SQL Server service and SQL Server Agent service will need correct permissions to the directories containing the xel files.