All sturgeon do not get to be huge or even big, in North America the shovelnose sturgeon is your best bet, they usually stay below 18" in an aquarium, maximum size in the wild is about 36" but that would be a very unusual fish, Most are caught at around 24" another good thing that shovelnose are slender fish and swim around in a small tank much better than other thick stiff fish like the European sterlet. I would want at least a 100 gallon tank waiting in the wings if i kept a shovelnose but that is much better than the lake necessary to keep the California sturgeon which gets to be several meters long. In Asia minor these if a sturgeon that only gets to a maximum size of 12" but it is rare and listed.