September 22, 2005 at 1:19 am
Can anybody help me to understand the output of DBCC SQLPERF(IOSTATS)
Network Reads 2.5722102E+7
Network Writes 4.3356516E+7
Network Bytes Read -1.7560696E+9
Network Bytes Written -7.0907738E+8
Command Queue Length 0.0
Max Command Queue Length 0.0
Worker Threads 0.0
Max Worker Threads 0.0
Network Threads 0.0
Max Network Threads 0.0
what is the differece between Netwokr Reads and Network Bytes Read, why is it showing a negative value ?
subban
September 26, 2005 at 8:00 am
This was removed by the editor as SPAM
September 26, 2005 at 10:53 am
No longer reliable for sql server 2000
See the books online.
Sql 6.5
The DBCC PERFMON and DBCC SQLPERF statements documented SQL Server performance statistics used for studying SQL Server performance.
Sql 2000
No longer documented. These statements may change in a future release of SQL Server.
Use the Windows 2000 System Monitor Windows NT 4.0 Performance Monitor to monitor the performance counters for SQL Server. For more information, see Monitoring with Windows Performance Monitor.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply