Documentation

Collector.ServersDetail
This table holds extended info on all the servers in dbo.Servers.  It holds data that can typically be considered more volatile than the properties in the d...
Mon, Mar 22, 2021 at 9:58 AM
Troubleshoot: Resource Governor Collection
There may be times when you're not getting data you think you should be.  This will discuss the types of issues that may come up. Why am I not ge...
Mon, Mar 22, 2021 at 10:19 AM
Suspect Pages Collection
So you don't have to put a local alert on every server, we provide a suspect pages collection. This pulls data directly from sys.suspect_pages in each ...
Sun, Nov 6, 2022 at 12:57 PM
Pending Reboot Collection
It is often helpful to know the status of a server reboot before you start any install or update operations.  It can help you plan the outage better.  We co...
Sun, Nov 6, 2022 at 1:38 PM
Object - Stored Procedure: Servers.ByApp
Minion allows you to setup applications and tie them to servers.  This SP shows you the servers associated with a specific application. Na...
Wed, Jul 12, 2023 at 2:33 PM
Object - Stored Procedure: Servers.ByEnviro
NameTypeDescription @Enviro varchar The name of the environment as defined in dbo.ApplicationEnvironment. @DistinctOnly bit Returns a distinct list of s...
Wed, Jul 12, 2023 at 2:26 PM
ReturnSchema
You'll see this parameter in a lot of our SPs.  It returns the schema and call for that SP. The idea is simple.  We want Minion to be as useful as p...
Wed, Jul 12, 2023 at 2:07 PM