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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-24 : 09:41:53
|
| Robert writes "I monitor activity on SQL server and use the usual array of tools + a couple of custom SQL queries which poll sysprocesses for activity information.In trying to achieve maximum speed for users I have noted that pysical_IO in sysprocesses often becomes static.For example:spid blocked Wait MB of cache212 0 .000000 .000000 I/O last_batch 53450 15:23:08.357 Note this poll of activity was taken at 4:54pm and clearly the query/work had completed.I am curious as to why I/O [pysical I/O] counter does not clear[like the memory counter, I rename it as MB of cache]? Are resources continuously being held or is it simply a reflection of the I/O required during the operation in question.If it is a relction of I/O required during the operation is it the max I/O activity or an average. Should it be an area of concern in terms of monitoring activity and performance.Is it a usefull stat? If so suggestion on employing this to tune SQL performance would greatly be appreciated.Thanks.RF " |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-24 : 10:16:34
|
| If you lok it bol it says Cumulative disk reads and writes for the process.i.e. it is the total since the spid logged on.It's useful for seeing if the spid is actually doing anything and if it is increasing quickly it probably means that spid is hogging the disc.If it's static it probably means the spid isn't doing much (but not necessarily).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Physical I/O, SP_Who2 and monitoring