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 |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2011-09-13 : 20:49:34
|
| We have a Dedicated Server running with Data ware house Databases and the Reports were generated from Reportserver accessing the data from Data Ware House server.End-User who is accessing the reports has complained of being slowdown and sometime even the report has halted. For which I have to run when report is generated using the SQL Profiler using the basic parameters to capture the SQL SP's mainly.While I do this Profiler itself is burden to the server on capturing Server side of Performance, instead of doing this way how can I still capture with profiler being used?Is there any other method to capture them or do I have to run any SQL Agent based job to automate the recordings being stored and later for examination?Can anyone throw some light on this?Thanks All for the participation. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Jason W
Starting Member
19 Posts |
Posted - 2011-09-14 : 00:09:10
|
| We setup SQL traces to run constantly on the server. The nice thing about the traces is that you can load the data into a database table and query on all your historical performance. This link will get you started with using the trace file. Microsoft's website contains all of the information you need, but it is sometimes nice to get the shortened version before jumping into a lot of technical lingo.http://sqloptimizationsschool.com/Pages/Tracking%20Performance/Performance%20Tracing.aspx |
 |
|
|
|
|
|
Capturing Server Side of Performance