What are the two types of system performance metrics that are useful for troubleshooting SQL Server performance issues?
What will be an ideal response?
The first are basic measures of resource utilization (e.g., processor utilization, available memory, and average disk throughput). These metrics (for example, sustained activity or spikes in activity relative to the baseline performance) help you understand how busy a resource is and whether the level of activity is abnormal. The second type of metric enables further diagnosis of a problem by analyzing the number of backlogged requests that are waiting for the resource to become available.
You might also like to view...
Line ________ or thickness can be adjusted around a shape
Fill in the blank(s) with correct word
An advantage to naming a range of cells is that you can use the name in a ________
A) data table B) lookup table C) table array D) formula