topic Re: Mosaic dataset limit in Enterprise database in Imagery and Remote Sensing Questions

Mosaic dataset limit in Enterprise database

JonM32 — Wed, 24 Jan 2024 16:42:57 GMT

Is there a limit to how many mosaic datasets (MD) you can store in a database? Documentation I've seen on this is limited.

My use case: I'm using an enterprise geodatabase in SQL Server and have about 16 MD in it. I'm thinking of creating a good number of new MDs for new imagery collections. Is there any limit to how many I can or should store in the database? Downsides to storing too many in one database?

In future years this number would only grow, so I'm just wondering if I should plan to break my collection of MDs into multiple, different databases.

Thank you!

Jon

Re: Mosaic dataset limit in Enterprise database

MarieCline_Delgado — Thu, 25 Jan 2024 21:44:40 GMT

Hey again Jon - I don't know the answer to your question, but I want to follow and see what info you learn. I have 54 mosaics in one db and haven't considered the need to split into multiple dbs.

Re: Mosaic dataset limit in Enterprise database

JonM32 — Thu, 25 Jan 2024 21:54:09 GMT

Thanks for the input! I have probably 20 so far in ours and was thinking of doing the source/derived mosaic dataset setup for sharing NAIP, but that would add a fair amount of new ones.

If anyone else has examples of their mosaic numbers, I'd love to hear them!

Thanks,

Jon