I've just started a job and I'm responsible for administrating (will define later) a few massive OLTP databases. These are not direct transactional systems, but they are published directly by the main OLTP system (so they mirror the production tables). I am responsible for these tables. Precisely I need to accomplish the following:
1- Create ERD models for the tables. The tables, since they are replica/mirror of the production have *zero* references or key relations established. Nobody has access to the main OLTP and there are no documentations obviously. How could I establish keys (FK or PK relations) without actually having access to the main source?
2- Understand most used tables and most important tables
3- Monitor incoming sources, data load into the server. Not the databases that I'm responsible for, but the server. Basically, to analyze how the SQL Server server is being used by the tools that are connected to it.
I'm completely lost. Any help, guidance, blogs, third-party tool suggestions is very much appreciated.