FAQ

Alerts & warnings

• Why can't I select a certain threshold value with the slider?
• What does the "Limit" setting do?
• Why is the "Limit" setting grayed out when I right-click on a node?
• What does the "Auto-adjust" button do?

Wait statistics

• Why does the instance wait chart look different than the query waits chart?
• What is the difference between instance waits and query waits?
• Why can't I drill down from the query waits chart?
• Why can't I see any query waits?

Capacity planning

• What are the essentials of SQL Governor in capacity planning?
• What if my source and target servers have different hardware?
• How much data do I need for capacity planning?
• How does trend calculation work?
• When I should bypass the automatic trend calculation in a capacity planning project?
• When I should use right-sizing or consolidation?

General

• How long is data stored for in SQL Governor?
• How often is the data refreshed in the SQL Governor UI?