nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Monitoring SQL Server/SDE Memory Usage

MikeSchonlau

Can anyone suggest some sql queries/scripts that could help me monitor SQL Server's system memory usage on an active enterprise geodatabase instance? This SQL instance is primarily supporting ArcGIS Server REST services. There are very few Desktop connections. I'm hoping to really examine my memory usage so I can right-size my database server going forward. Thanks

Trouver plus de publications taguées avec

Accepted answers

ChrisSmith7

Have you looked into any of the monitoring tools developed by Red Gate or SolarWinds? There are also some tools provided by SQL Server - Performance Monitoring and Tuning Tools

All comments

MikeSchonlau

Thanks, Vince. Haven't used SDE app server in many years. I am looking for just what you describe - database tools that help me analyze specifically how SQL is using memory. Bottom line is do I need 8 or 16 Gb on my new database server?

MikeSchonlau

Thanks, Chris. I'm trying out the SolarWinds DPA trial. Looks useful. I also stumbled across the DBCC MEMORYSTATUS command for SQL. Also provides some good info.

VinceAngelo

If you're not using an ArcSDE Application Server (and you shouldn't be using one with ArcGIS Server at this point), then ArcSDE doesn't exist to utilize memory. Generic database tools, provided by the RDBMS vendors, should be the only tools necessary to evaluate memory usage on the database server.

- V

MikeSchonlau

Thanks, Jake. I tried using the System Monitor tool a couple of years ago. I found it difficult to use and seemed to focus more on ArcGIS Server performance than on database performance. Have their been improvements in the last year or so?

MikeSchonlau

Thanks, Chad. I'm actually referring to memory usage on the database server - not the ArcGIS Server.

ChadKopplin

Since this server is primarily used for serving rest services, you can go into the Task Manager, go to the processes and see the number of SOC services that are running. By default ArcGIS server will make 2 available/service unless to change the settings. We were consuming 7 gb of RAM out of 8 just to have these accounts available and ready when the service would be used. We have changed to have a minimum of 0 in the service settings, now the account is created when the service is actually accessed, not we have 6 -7 gb available at any time.

jskinner

I would also recommend taking a look at the System Monitor tools:

http://www.arcgis.com/home/item.html?id=848f48b0f88e4de7a036377197453efe

ChrisSmith7

Have you looked into any of the monitoring tools developed by Red Gate or SolarWinds? There are also some tools provided by SQL Server - Performance Monitoring and Tuning Tools

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.