HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Scripting Microsoft Data Warehouse Wizard

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
wizardscriptingwarehousemicrosoftdata

Problem

I am trying to automate the MDW setup process in my environment. Currently I have everything complete except for enabling the data collectors (usually uses a wizard as seen ).

Has anyone seen or used a script for this? Or have any suggestions?
Thanks.

Solution

This is not my area of expertise, but you might look at Dennes Torres Simple Talk post from January 2015 for any takeaways that help you.

https://www.simple-talk.com/sql/database-administration/centralize-your-database-monitoring-process/

Two subheadings of particular interest may be:

  • Configure Data Collector through CMS



  • Configure Collection Sets through CMS

Context

StackExchange Database Administrators Q#110829, answer score: 4

Revisions (0)

No revisions yet.