I'm looking for best practices on setting up partitioned service applications in SharePoint. Not the default ones, but a custom one.
As I understand, a partitioned service application like the profile service still uses the same DB as the normal service app does. Only in most tables, the records get an extra identifier in the form of a partitionID key.
So suppose I want to make my own service application with it's own DB. It'll be used in a partitioned environment, so I need to include the partition ID in the tables where that's applicable. Is this just a matter of including a Guid column in each table and including the same Guid in my service methods? Or are there more options on creating service proxy objects to automatically include the partion id in each client call? Does anyone have any experience with this kind of setup?