Monitor network resources used by single database

Hi,

Is there any methord to monitor network utilization per database on single instance of SQLServer2005 or SQLServer2000.

Please help

Regards

Mohd Sufian

The tools are Profiler, accessable from the Tools menu in SSMS or Start/Programs/SQL Server/Performance Tools or perfmon accessable from Start/Programs/Administrative Tools/Performance.

The tool to use depends on the meaning of "network utilization". Profiler will allow you to run a trace you can use to aggregate reads, writes and duration by database. Perfmon has many counters that can be used by database.

See SQL Server 2005 Books Online topics:

SQL Server, Databases Object

http://msdn2.microsoft.com/en-US/library/ms189883.aspx

Monitoring Resource Usage (System Monitor)

http://msdn2.microsoft.com/en-us/library/ms191246.aspx