Post reply

running local or network DB's for speed

  • February 19, 2015 at 4:24 pm

    #304399

    Hi

    I'm looking at optimising access speed on some GIS databases by moving them to either their own virtual server running SQL Server 2008 r2 or onto a virtual server running the program that will be doing 90% of the processing and a local install of SQL Server 2008 r2.

    My question is how does the speed of a network connection between virtual servers compare to running one virtual server as above. Both SQLServer and the GIS application (ArcGIS Server) use a lot of CPU and ram.

    A recent trial nearly stopped all the databases on the server where the GIS databases sit. Other options include replication which we run at the moment.

    Any examples or ideas greatly appreciated.

    Bruce

  • February 19, 2015 at 8:14 pm

    #1778836

    Quick thought, unless you have 2 x LotsOfRAM on a single server, run ArcGis and SQL Server on two separate servers, my guess is that if those two start to compete for the RAM, network latency is not going to matter too much.

    😎

  • February 19, 2015 at 8:49 pm

    #1778837

    my thoughts exactly although both ArcGIS and SQL manage memory really well. When I look at the performance the cpu's max out.

    Thanks.

  • February 19, 2015 at 9:06 pm

    #1778839

    my thoughts exactly although both ArcGIS and SQL manage memory really well. When I look at the performance the cpu's max out.

    Thanks.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply