topic SQLServer instances and Geodatabases in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/sqlserver-instances-and-geodatabases/m-p/372550#M14432 <HTML><HEAD></HEAD><BODY><P>After reading<A href="https://community.esri.com/thread/170980">Multiple GDBs vs Single GDB</A> I thought I would throw another question out there that is sort of related.</P><P></P><P>Are people running their production and publication GDB's on the same SQLServer but in different SQLServer named instances?</P><P>eg SQLServerA\production_instance with GDB's inside and SQLServerA\publication_instance with GDB's inside</P><P></P><P>Or are production and publication on totally different SQLServer servers in default or named instances?</P><P>eg SQLServerA (production GDB's in the default sqlserver instance) and SQLServerB (publication GDB's in the default sqlserver instance)</P><P></P><P>We have been through the process where we were running publication and production on separate servers, have then consolidated all organisation db's (GDB and normal DB) back to one SQLServer and are experiencing performance issues, so we will now be separating them off into separate servers again.</P><P></P><P>Regards</P><P>Steve</P></BODY></HTML> Fri, 22 Jan 2016 05:25:08 GMT StevenBowden 2016-01-22T05:25:08Z SQLServer instances and Geodatabases https://community.esri.com/t5/arcgis-enterprise-questions/sqlserver-instances-and-geodatabases/m-p/372550#M14432 <HTML><HEAD></HEAD><BODY><P>After reading<A href="https://community.esri.com/thread/170980">Multiple GDBs vs Single GDB</A> I thought I would throw another question out there that is sort of related.</P><P></P><P>Are people running their production and publication GDB's on the same SQLServer but in different SQLServer named instances?</P><P>eg SQLServerA\production_instance with GDB's inside and SQLServerA\publication_instance with GDB's inside</P><P></P><P>Or are production and publication on totally different SQLServer servers in default or named instances?</P><P>eg SQLServerA (production GDB's in the default sqlserver instance) and SQLServerB (publication GDB's in the default sqlserver instance)</P><P></P><P>We have been through the process where we were running publication and production on separate servers, have then consolidated all organisation db's (GDB and normal DB) back to one SQLServer and are experiencing performance issues, so we will now be separating them off into separate servers again.</P><P></P><P>Regards</P><P>Steve</P></BODY></HTML> Fri, 22 Jan 2016 05:25:08 GMT https://community.esri.com/t5/arcgis-enterprise-questions/sqlserver-instances-and-geodatabases/m-p/372550#M14432 StevenBowden 2016-01-22T05:25:08Z