InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 13:44:17 GMT20http://www.sqlservercentral.com/Forums/Topic500205-65-1.aspxThanks for the replies....RegardsRahulThu, 22 May 2008 08:26:31 GMTkasaranenikiran-725528http://www.sqlservercentral.com/Forums/Topic500205-65-1.aspx[quote][b]kaykay005 (5/14/2008)[/b][hr]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 MaxNetwork Interface\ Total Bytes/Sec 23536713 2107 65526893Physical Disk\Avg Disk Queue Length(H) Data 45 0 433 Could you please suggest anything from these counters, what has to be done.??Rahul[/quote]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.Thu, 22 May 2008 05:12:31 GMTTheSQLGuruhttp://www.sqlservercentral.com/Forums/Topic500205-65-1.aspxlooks like some disk tuning required as there is high queue length. all other values seem okWed, 21 May 2008 02:14:52 GMTrajankjohnhttp://www.sqlservercentral.com/Forums/Topic500205-65-1.aspxtry looking at http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/01/24/perfmon-counters-thresholds.aspxI'd also recommend the book SQL Server 2000 performance tuning reference manualWed, 21 May 2008 02:05:29 GMTcolin.Leversuch-Robertshttp://www.sqlservercentral.com/Forums/Topic500205-65-1.aspxI am not able to try to answer your questions one-by-one. But the following link may help.[url]http://www.sql-server-performance.com/articles/audit/hardware_bottlenecks_p1.aspx[/url]Personally, it is a very good one from my personal point of view.Wed, 14 May 2008 09:18:08 GMTSQL ORACLEhttp://www.sqlservercentral.com/Forums/Topic500205-65-1.aspxHi , 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 MaxMemory\Available Mbytes 2106 1818 2141Memory\ Pages/Sec 0.141 0 246Network Interface\ Total Bytes/Sec 23536713 2107 65526893Physical Disk\ Avg Disk Queue Legth (Total) 50.44 0.0001 453Physical Disk\Avg Disk Queue Length(I) Index 4.59 0 453Physical Disk\Avg Disk Queue Length(J) Logs 0.8 0 30Physical Disk\Avg Disk Queue Length(H) Data 45 0 433Physical Disk\Avg Disk Sec/Read(H)Data 0.09 0 0.77Physical Disk\Avg Disk Sec/Write(H)Data 0.03 0 2.37Processor\ % Processor Time 12.62 0.038 92.61Server Work Queues\ Queue Length 0 0 0SQL Server Buffer manager\ Buffer cache hit ratio 99.62 88.66 99.9SQL Server Cache manager\Total cache hit ratio 67.01 66.96 67.08SQL Server General Statistics\ User Connections 40.03 21 94SQL Server Locks\Total Lock Timeouts/Sec 0.18 0 89.2SQL Server Locks\Total Dead Locks/Sec 0.0003 0 0.2System\Processor Queue Length 0.05 0 10 Could you please suggest anything from these counters, what has to be done.?? I ran the PerfMon for the whole day from 10AM to 8PM.We have SQL server 2000 SP4 on Windows 2003 advanced Server. I am confused with Buffer cache hit ratio and Total cache hit ratio? I think Total cache hit ratio should not be <90. So, what was the problem and what can be done? And what can be done for the Avg Disk Queue Length?? The data drive (H) was having 5 disks on the array. Please suggest . RegardsRahulWed, 14 May 2008 00:43:09 GMTkaykay005