Hubble Error Messages

solarwindsphish

Please expound and elaborate on these error message on Hubble.

1. Duplicate query detected. This request executed the same query multiple times (with the same paramters). Consider caching the query results so that the query is only executed once.

MS SQL doesn't caches queried results! Why are you asking us to query results!

2. Possible SELECT N+1. This request executed the same query multiple times with different parameters. This is often a sign of a N+1 problem (more details). Consider combining these queries into a single query.

It's you application that does the querying! How are we supposed to combine those queries?!

3. Too Many Stylesheets. There are a large number of stylesheets included on this page. Internet Explorer is limited to 31 styles per page (this includes links to external files and styles defined inline using style tags).

Were already using Chrome but was are still getting this message.

tony.johnson

Hubble is a diagnostic tool used to assist support in analyzing web server response times. This results from hubble should not be interpreted as error messages or as a list of items to "fix" but rather give support a beter understanding of which resources are taking the most time to load. for example:

1. MSSQL can cache results of select queries.The results of any query could also be cached by Orion. This message is an indication that the view is requesting the same query. This could be due to mutiple resources using the same data source.

2. You are not expected to take any action here. This is a recomendation to our developers that there may be possible optimisations achieved by changing the query.

3. This is an informational message for users is IE.

You can learn more about Hubble from the Success Center