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-05-10 : 21:40:09
|
| Our End-users were consistently complaining about the Slowness of the data being extracted while doing the reporting.In order to fix that I have increased number of processes and make sure the other unwanted users process were relinquished thereafter.But I think some thing I am missing to fix for them to have speed in the reports generation.Which DMV's should I enquire of for the Data buffers allocation and other memory allocations.Can anyone tell what needs to be done to adequate with speedness for the report generation.Advance thanks. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2010-05-11 : 00:50:47
|
i'd first check that query plans are reasonable. look for table and index scans - scanning large tables will hurt.
elsasoft.org |
 |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2010-05-11 : 20:41:13
|
| I have checked the Query Plans using Perfmon and ran some queries against them, since they were all fine 'within the range', couldn't find fault where to lay.Still there is some thick fog.....I have checked the Process monitor and found some sleeping and on kill some reprieve, but I am not still out of the woods.Any other suggestions. thanks Jezemine. |
|
|
|
|
|
|
Find Memory allocations