Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Maxer_Ars
Starting Member
2 Posts |
 Posted - 2009-08-10 : 14:56:22
|
| We have SQL Server, and a separate SSRS server install.All the users for these servers are from an ASP.NET site hosted on some IIS servers that are load balanced.What I would like to do is setup a system to allow us to monitor the load on SQL Server and the SSRS services, locate bottlenecks, and ideally track what reports are being run/requested by users of the website so we can focus on performance tuning the most popular reports.Any suggestions on where to start, the direction to go, solid 3rd party tools or a guide on how to use the ones that come with SQL server?Basically thoughts and guidance overall on this.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Maxer_Ars
Starting Member
2 Posts |
Posted - 2009-08-10 : 15:50:52
|
| Do you do anything with monitoring the SSRS reports and load? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Suggestions for monitoring SQL server and SSRS