Patent attributes
Methods and apparatus are provided for obtaining database performance snapshots. Performance data for one or more databases on a host is obtained by obtaining a host burden rating based on one or more of processing, network and input/out statistics of the host; determining a spawn limit based on the host burden rating; and spawning one or more scripts within the spawn limit, wherein each of the scripts collect performance data for a given database and is selected based on a database type of the given database. The host burden rating is a quantitative measure based on a sum of the processing, network and input/out statistics of the host. The collected performance data can be presented to a user in a graphical user interface and/or stored in a repository. The presented collected performance data for a given database comprises, for example, a score and/or a health assessment indicator based on predefined thresholds.
