We have two application one for public for viewing data and one for internal users for views and updating geodatabase using Enterprise application or Arcmap
1. For internal users Map servcies are published from Enterprise Geodatabase (MS SQL) only.
2. Out of 100 layers may be 10 tables not layers data edited by internal users needs to be displayed simultaneous. and this is actually coming from sensors with possibly 300 records within every 1 minute.
3. Our idea is to let 10 tables be served from Enterprise Geodatabase (MS SQL) and rest server from readonly File Geodatabase to external users.
Please provide your inputs