I am using ESRI suit 10.1 (ArcGIS Desktop, ArcGIS Server, ArcGIS JSAPI 3.3/3.4) at my end and having few performance questions regarding ArcGIS Map service.
-We have three simple map services published on our server.
-Each map services contains query layer and with the help of query layer, we have created few xy events source layer in each map service.
-Integrated those map services in ArcGIS Java script application.
-While querying on the map we are facing load at our sql server database (I think the request coming from client side as we used query layer)
-Interesting thing is that in down time we got request only from arcgis server machine (On DB server machine, checked the machine details and host name it’s our arcgis server machine)
So is it possible to set map service in idle mode when not in used? I checked the pooled and non-pooled option but in 10.1, all map services are pooled.
Going through System Design Strategies
Any help regarding this will be great !!
EDIT
According to @Alex Tereshenkov answer I can set the minimum number of instance to be zero so
-Is it take time to UP the instance?
-How many no. of instances to be set in Maximum number of instances (default is two)?