ArcSDE Data Usage Statistics

ChrisCarpenter — Fri, 10 May 2013 13:50:36 GMT

Does anyone know if there is a way to summarize usage statistics for ArcSDE? For example one of my databases has 31 Feature Datasets and 306 Feature Classes. I would like to know throughout the year the percentage of growth in this database, what types of features account for growth (point,polygon,line) , most frequently used features based on access, most frequently used features based on unique users, etc.. and a likewise summary for the Feature Datasets. This would help me to report on activity and start targeting which layers are most important and need more frequent updates etc...
Thanks for any thoughts,
Chris

Re: ArcSDE Data Usage Statistics

VinceAngelo — Fri, 10 May 2013 17:30:22 GMT

In order to summarize that information you'd first need to collect it.

While row count statistics are easy to collect, row access is not -- You'd probably
need to turn on auditing in your database to capture every query. ArcSDE itself
doesn't know about feature datasets, so you'd probably want to use a Python
app to run the inventory and and another to mine the audit logs.

And if your data is in map services (especially cached map services), you'd need to
enable verbose logging to mine that as well.

- V

topic ArcSDE Data Usage Statistics in Data Management Questions

ArcSDE Data Usage Statistics

Re: ArcSDE Data Usage Statistics