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/d...br />
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/techin...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