I work with a reasonably large team of DBAs. There are 9 of us and we support not only 70+ SQL Server instances but DB2, IMS and Sybase. We have SMEs for each DBMS and we cross train as much as possible, but even so there are some large gaps. As it happens I’m one of the SMEs for SQL Server but I’m a novice at DB2, and I can barely spell IMS and Sybase. So what happens when we have a problem and one of the SMEs isn’t available?
One of my co-workers and I were discussing this yesterday and came up with the idea of creating a document called “When I get stumped I ….”. In this document each of us will put the general process they use when they get stumped. In the case of junior DBAs (for whichever DBMS) this tends to be “Call the SME”, but for the SMEs for the DBMS that doesn’t usually work. Here is an example of what I might put for SQL Server:
It’s too soon to tell but I have high hopes that this document will be very useful over the long haul. Certainly next time I have a DB2 or *shudder* an IMS problem I’m going to give it a shot.