Disk I/O

Is there a way to monitor disk I/O by database, log or even better by table
without splitting out onto separate arrays?
DanDan,
Check out:
fn_virtualfilestats
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_61ih.asp
HTH
Jerry
"DanR" <DanR@.discussions.microsoft.com> wrote in message
news:19FF5DFB-A29E-43B2-B7AF-E7A3B5E844E5@.microsoft.com...
> Is there a way to monitor disk I/O by database, log or even better by
> table
> without splitting out onto separate arrays?
> Dan|||Best granularity you get is by file. Look up fn_virtualfilestats in BOL.
Note: You will need the 2004 refresh of BOL, available here:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DanR" <DanR@.discussions.microsoft.com> wrote in message
news:19FF5DFB-A29E-43B2-B7AF-E7A3B5E844E5@.microsoft.com...
> Is there a way to monitor disk I/O by database, log or even better by
> table
> without splitting out onto separate arrays?
> Dan