<div>
Processes like SQL Server Agent, which although in sleeping mode, remain active as listeners (awaiting command) will take up CPU
</div>


Processes like SQL Server Agent, which although in sleeping mode, remain active as listeners (awaiting command) will take up CPU

<div>
Is the CPU Time is this in milliseconds<br />
This is ? -- &nbsp; Disk I/O is this in bytes and to get to megs * by 1024 &nbsp;<br />
<br />
Is it the amount of data that is being processed at the exact time.....<br />

</div>


Is the CPU Time is this in milliseconds
This is ? --   Disk I/O is this in bytes and to get to megs * by 1024  

Is it the amount of data that is being processed at the exact time.....


<div>
Physical IO<br />
<br />
Cumulative disk reads and writes for the process.<br />
<br />

</div>


Physical IO

Cumulative disk reads and writes for the process.



<div>
i always wondered why some are so high oh i see..<br />
No way to divide i suppose ? <br />
What the size 8k ? 
</div>


i always wondered why some are so high oh i see..
No way to divide i suppose ?
What the size 8k ?

<div>
No there is no way to divide it<br />
<br />
&lt;What the size 8k ? &gt;<br />
Not sure what you mean by this
</div>


No there is no way to divide it

<What the size 8k ? >
Not sure what you mean by this

<div>
when you do sp_who2 <br />
the Disk I/O is a figure is this how much data is being requested in and out of data files<br />
<br />

</div>


when you do sp_who2
the Disk I/O is a figure is this how much data is being requested in and out of data files



<div>
<div class="content wysiwyg-content">
When i do sp_who2<br />
&nbsp; &nbsp;There is CPU Time and Disk I/O<br />
&nbsp;<br />
&nbsp; &nbsp;Is this what the particular process is doing at the time.<br />
<br />
&nbsp; &nbsp;CPU Time is this in milliseconds<br />
&nbsp; &nbsp;Disk I/O is this in bytes and to get to megs * by 1024<br />
<br />
If the process is just sleeping are these just taking up value cpu ?<br />
<br />
Thanks
</div>
</div>


When i do sp_who2
   There is CPU Time and Disk I/O
 
   Is this what the particular process is doing at the time.

   CPU Time is this in milliseconds
   Disk I/O is this in bytes and to get to megs * by 1024

If the process is just sleeping are these just taking up value cpu ?

Thanks

sp_who2

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.