Monitoring

From SQLBWiki

Right click on a server node and choose 'Monitor' will launch the monitoring of this server. The Monitor shows a 'sp_who' like panel refreshed every second or so. It allows to spot long running processes

• Display
  • Active lines are always on top and painted in light red, unless you sort differently
  • Blocked lines are showed in strong red

• Toolbar
  • Sleep time is configurable
  • "Resume/Pause" suspends the monitoring
  • "Reset Sorting" resets the sotring to the natural sort, i.e. most active line first. This is when you have otherwise sorted by clicking on a column
  • "System Spids" tick box allows to show/hide system spids
  • "Trace" outputs a trace in the output window. Warning, this consumes a lot of memory!
  • "Back and Forth Arrows" navigate through history
  • "History" is the history size. Warning, changing this to a large number consumes a lot of memory!
  • "Clear" clears history

• Contextual Menu
  • "Mark or UnMark" highlights a spid or group of spids to follow them visually
  • "Show-Plan" launches a sp_showplan (or substitution proc) on the curent spid, provided you have the proper authorization
  • "Kill" kills the current spid, provided you have the proper authorization