kaykay005 (5/14/2008)
Hi ,Our company had an Reporting Server which runs very slow. I have put some counters and run System Monitor. And the results are below.
Objects\Counters Avg Min Max
Network Interface\ Total Bytes/Sec 23536713 2107 65526893
Physical Disk\Avg Disk Queue Length(H) Data 45 0 433
Could you please suggest anything from these counters, what has to be done.??
Rahul
Those are the two that jump out at me. Network activity could be showing that you are returning far too much data to the client. That involves investigating and possibly refactoring app code. Reports are the first place to look I would think.
H DQL is well above the 'recommended' 2-per-disk-spindle. It could be simply because you are throwing 25MB/sec back to the client. But more likely you have a) poorly performing queries and b) missing indexes. You can run profiler and capture calls with say > 10K reads and start working those. Or if you aren't experienced you could hire a performance consultant to help you figure out what needs to be done and mentor you on how to do that in the future.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service