sql server database location for enterprise

AndyIngall

Hello

Just looking for thoughts or ESRI's comments on the location of the enterprise geodatabase within a SQL server.  Is it recommended that the GIS database be located on its own SQL server or can it be located within a SQL Server containing many databases - what is the best or preferred method??

Thanks

 

VinceAngelo

There isn't really an answer for this, and asking for an Esri response from the user forums isn't the right approach -- Even if employees do respond, they aren't speaking for the corporation (and asking them to actually reduces participation).

That said, the recommendation is to use a server adequate to the task. Is that a standalone server? Well, maybe. But give the DBA the benefit of the doubt, since requiring that they add a box they don't want to use (and that has to be paid for) isn't likely to make their life easier.

In the end, the "best" solution is the one that works for everybody. If the shared server is overloaded, adding GIS to the mix isn't going to help, but you'll be able to benchmark that. Sometimes everything seems fine in the TEST system, but moving into PRODUCTION demonstrates a scaling issue, even with a standalone server. And increasing the number of servers doesn't always improve performance, either, because sometimes the network or the SAN is the bottleneck. Each deployment is different, and can have wildly varying "best" solutions.

- V