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 |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2010-04-13 : 19:30:06
|
| Hi,We have a datawarehousing Server where the reporting will done. However, when the same report is being accessed by 2 persons then it gets slowed down.What are the parameters that I should monitor and do what to improve the speed of the report generation.Is there any monitoring tool OR any monitoring Scripts either using DMV's or suggestions.Thanks for your replies. |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-13 : 19:58:13
|
| Is there any locking issues with the report? You can find this info under Management/Activity monitor.How long does the report take to open: with a single user? with 2 users?------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-04-13 : 20:22:51
|
| There are NO Locking issues as I have constantly monitoring from the back-end while the reports being executed from the front-end.It was running till otherday without any complaints but users complain of getting slowed down and while preliminary investigation as the users got into contention got slow down yet report is generated.Though the report execution is done but taking MORE TIME while 2nd user is in contention for the same report.All I want to know is what to make the performance to improve like any parameters checking, under the OS level like Buffer usage and memory increments. Any other suggestions would be valuable and thanks for participating. |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-14 : 05:06:09
|
| The thing you need to identify is, what changed to make the report run slower all of a sudden? Was a large amount of data recently added to the report? How complex is the query that supplies the data for the report? Any chance of posting it here, as there may be a way of making it run faster. How often are the indexes that the report is base on rebuilt? If they are stale, then try rebuilding them. Also, if the report is based on a stored proc, you could try re-creating the stored proc to generate a new query plan.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-04-14 : 17:06:06
|
| You can use system monitor and profiler to trace out what is happening when report run slow. |
|
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-04-14 : 18:09:35
|
| As Indicated, I have with Sys Monitor and Profiler which shows no evidence of slowing down. On the otherhand, The data adds up every month but considering the bulk it was small amount, also checked the SP's related to that and the SP behind the SQL was tested on the back end. Found no evidence.After all the above investigations I have sought the forum is there any way that I can still encroach into like incrementing the supporting paramenters for them.your valuable solutions would help me to further investigate and fix the problem.Thanks All. |
|
|
|
|
|
|
|
|
Report Generation Slow