Hi there Alteryx team,
We have a set of new server administrators in our team, and we're looking for self-paced / self service training that we can use to go from relative novice to well-informed server managers.
Does the Alteryx team have any of these kind of resources that we can use? We may have something as comprehensive as the Microsoft training materials based on their certification programs (https://www.amazon.com/Training-70-462-Administering-Microsoft-Databases/dp/0735666075/ref=sr_1_1?ie...) but even a 200 page PDF would be a HUGE help so that we can start getting smarter?
Key areas that I'm hoping we can learn and become self sufficient:
- Sizing our server infrastructure - how many; how to size; the different server roles (workers / web server / load balancers)
- Setup considerations (co-location vs. multi-location; partitioning; business continuity / fail-over; load balancing) and implementation tradeoffs
- Guide to securing the servers (using LDAP/Kerberos passthrough preferrably)
- reference / best practice setup for dev/test/prod environments
- how many environments do people usually have (dev/prod or dev/test/prod) - what is the recommendation?
- what is the recommended access for each environment? Should we let people run their own canvasses in Dev / test, or does that leave us open to people running their flows forever in Dev/test in stead of going to prod? What is the recommendation about procedural controls for this?
- What is the recommended setup for districts
- Recommendations for access & usage of prod. For example, should we allow people to run jobs on-demand in prod, or only allow shedules. How about interactive apps; apps with Run /download tools; etc
- what is the recommended way of managing promotion from dev -> test -> prod - is this something that should always be managed by a central team, or is it recommended to allow users to self-serve. What are the tradeoffs, and best practices / recommendations
- Monitoring; management; etc
- How do you recommend managing scheduling choke-points (where due to human psychology people schedule canvasses on the hour (08:00 or 09:00 or 10:00), so every hour we have a rash of canvasses kicking off)
- How about overly aggressive scheduling - e.g. a canvas that is scheduled to run every 2 mins, but which is taking huge amounts of resourcing
- what are the standard monitoring / server admin team responsibilities (daily / weekly responsibilities like re indexing; monitoring performance; looking for resource hogging jobs; etc)
- How do you recommend that the server team manage driver versioning so that drivers are alwasy up to date on the server
- Newer capabilites
- best practice around server pooling;
- database access (do you recommend a generic login for "Alteryx server" or can we do pass-through kerberos from the logged in user, etc)
- Can we set up connection pooling so that if many different jobs are hitting the same server using the same connection details, it pools connections rather than opening / closing etc
- Is there any way to scan Alteryx jobs to look for bad practices before allowing them to promote to prod? For example, look for data fields that are never used after the input control.
Very keen to find out what is available because right now we're figuring this out as we go along, and I strongly suspect that we're not using the server to it's best capability because of our level of knowledge (or lack thereof).
If this is not yet available, we'd be more than happy to work with the Alteryx team to be the guinea pig for the first drafts and provide comprehensive feedback on any initial versions.