I have been asked to provide some performance indicators for our applications.
Among them
- Max transactions per second
- Max parallel connections
- Max users
Usually we don't monitor them because currently there is no need. Whenever we have problems - and it doesn't happen very often - it is usually IO for complex queries.
Any idea how to get these numbers? I have select catalogue role on some databases and can query during office ours, for everything else I would have to ask the admins.
Marcus