Perfmon Counters thresholds
Just in case you missed the link to The Premier's blog http://sqlblogcasts.com/blogs/thepremiers/archive/2008/01/23/monitoring-sql-server-using-performance-monitor.aspx they've just posted details of a perfmon trace viewer. But what is more important is the attached documentation on perfmon counters, you can find as an attachment to the post, " Performance Counter Guidance.zip "
If you download this you'll find four documents which cover SQL Server, SSRS, SSAS and Windows Server, as well as listing the actual counters to monitor are explanations of likely values and causes. Important here is the coverage for SSRS and SSAS, I've been looking into the overall performance tuning and trending of SSRS and there's not a lot of info on tuning that I can see. It's worth pointing out that the samples which come with SQL 2005 install CD include a log analysis application - or to be more precise a set of tables, a SSIS package to extract data from SSRS and some reports to interpret the data, a performance dashboard for SSRS. I've installed this and it does give excellent information and is a good starting point for starting to produce management reports on SSRS usage and performance.
I've not had cause to tune SQL 2005 Analysis Services, yet, but if you're using SSAS then I suggest you have a read though the document. There's not been too much for SQL Server 2005 on the microsoft blogs of late so it's a nice suprise to find such a gem. Thanks guys.