November 27, 2009 at 2:28 pm
I've had some users complaining of performance issues on our SQL-2008 Report Server, and I've been looking at some information on BOL on how to monitor system performance:
http://msdn.microsoft.com/en-us/library/ms159809.aspx
However, this info is not enough.
I need some guidelines on counters that are most useful to look at on first go, and values/ranges to watch out for.
Anyone know where I can find this info?
I found this link on SQL 2005, but nothing yet on SQL 2008, which has changed quite a bit:
http://blogs.msdn.com/bimusings/archive/2005/07/26/443511.aspx
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
December 1, 2009 at 9:30 am
Check out the SQLScrubs project. First release targets SSRS 2008. Extracts execution log data into a DW, and provides a set of reports so you can track slow reports, queries, users, etc.
The Community Edition is on codeplex. The Premium Edition offers a lot more reporting in the box.
Some links:
SQLScrubs Overview: http://www.summitcloud.com/solutions/scrubs
CodePlex Project: http://scrubs.codeplex.com
Article on things to look for in Optimization Analysis of SSRS:
http://blog.summitcloud.com/2009/11/analyze-and-optimize-sql-server-reporting-services-ssrs-reports/[/url]
December 1, 2009 at 9:38 am
David 62010 (12/1/2009)
Check out the SQLScrubs project. First release targets SSRS 2008. Extracts execution log data into a DW, and provides a set of reports so you can track slow reports, queries, users, etc.The Community Edition is on codeplex. The Premium Edition offers a lot more reporting in the box.
Some links:
SQLScrubs Overview: http://www.summitcloud.com/solutions/scrubs
CodePlex Project: http://scrubs.codeplex.com
Article on things to look for in Optimization Analysis of SSRS:
http://blog.summitcloud.com/2009/11/analyze-and-optimize-sql-server-reporting-services-ssrs-reports/[/url]
Thank you! So when is this coming out, any ideas?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
December 1, 2009 at 9:39 am
December 1, 2009 at 9:42 am
David-Leibowitz (12/1/2009)
It's out...Check the links.
Excellent, thanks again!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply