2 of 2 people found this helpful
If upgrading the hardware, or adding additional hardware (clustering) aren't options, then you could look at the following
1. Improve dashboard performance. Take a look at the following articles (they're pretty comprehensive) on dashboard performance.
2. You could also look at cache warming. This is where dashboard queries are pre-run, so that when an end user views a dashboard, they get the cached query response, and not have to query the data source directly.
Both of these are only going to get you so far though, and at some point you may well have to 'bite the bullet' and add server resources.
Hope this helps
Thanks!! Glen Robinson