How to open the Support Services drilldown
From the Spotlight Client
- Select the connection from the left Connections pane.
- Click Monitor | Support Services from the ribbon.
About the Support Services drilldown
Full Text Search page
Shows performance details for all full-text indexes on the server. In full-text indexing, a separate catalog is maintained that indexes each word in a database field as a separate index entry.
If some of the details are incomplete for all of the rows, the Full Text Search Service may not be running. Check the Services Status grid on the Service Status page to confirm this.
State changed column behavior in SQL Azure
Scenario 1
When the SQL Azure connection is not linked to its host operating system connection (SQL script is used), the State Changed column displays the database service start time. This value may not reflect the actual start time or state change time of the service.
Limitation: When using an SQL script, the service start time cannot be retrieved.
Scenario 2
When the SQL Azure connection is linked to its host operating system connection (WMI query is used), the State Changed column remains blank. In this case, the procedure returns a value of 0 when the main process for the service is not found (i.e., the service is not running).
Limitation: For services that are not running, the service start time cannot be retrieved even when using a WMI query.