The Properties view displays database properties that correspond to the data returned by the SQL Server DatabasePropertyEx function. For more information about these properties, see the Transact-SQL Reference section in Microsoft® SQL Server Books Online.
The Database Details panel allows carrying out the following tasks:
• |
Monitoring database space and history — using the Summary pane, which displays a graphical representation of the disk space usage for databases, as well as various statistics for each database. For further details, see Monitoring Database History . |
• |
Monitoring file groups — using the File Groups pane; see Monitoring File Groups in the Selected Databases . |
• |
Monitoring data files — using the Data Files pane, which displays all files (excluding the Transaction Log) in the selected databases; see Monitoring data files . |
• |
Monitoring transaction logs — using the Transaction Logs pane; see Monitoring Transaction Logs in the Selected Database . |
• |
• |
Monitoring tables — using the Tables & Indexes pane, which displays statistics for all tables and indexes in the selected databases (by default, 50 rows are displayed); see Monitoring Tables and Indexes . |
NOTE: The panes from File Groups to Tables and Indexes display tabular and graphical information about other areas down the storage level hierarchy, currently selected in the Databases table. The charts on each of these panes display the amount of space allocated to the area for each selected database (Space Chart), and the amount by which each of the areas is growing over time (Growth Chart). |
• |
Monitoring disk space — using the Disk Space pane, which displays each logical disk on the server, with a detailed graphical representation of the disk space usage for all disk. For further details, see Monitoring Disk Space . |
The Summary pane displays three separate charts showing various statistics relating to recent I/O activity on each database. You can select which data each graph should display.
To view a particular graph, select it from the Database History list.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center