<div>
There are three counters that indicate a system problem:<br />
<br />
1) System Processor Queue Length<br />
2) Network Interface Output Queue Length<br />
3) Physical Disk Average Disk Queue Length<br />
<br />
<b>values should shed those counters to consider a problem?</b>
</div>


There are three counters that indicate a system problem:

1) System Processor Queue Length
2) Network Interface Output Queue Length
3) Physical Disk Average Disk Queue Length

values should shed those counters to consider a problem?

<div>
<div class="content wysiwyg-content">
Hi experts;<br />
<br />
i am reading about: resource waits, but i do not understand <br />
Network IO<br />
and<br />
Buffer IO<br />
<br />
what are the recommended values? when performance is an issue?
</div>
</div>


Hi experts;

i am reading about: resource waits, but i do not understand 
Network IO
and
Buffer IO

what are the recommended values? when performance is an issue?

activity monitor: resource waits

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.