Step 4: Network bandwidth

Find out how to determine if a network interface card (NIC) limitation is causing performance issues in SQL Server 2000.

To determine if a network interface card (NIC) limitation is causing performance issues, use the Task Manager...

results.


Windows Task Manager: Networking view

To fine tune the overall network usage, the following Performance Monitor counters should be reviewed:

  • Network Interface: Bytes Received/sec
  • Network Interface: Bytes Sent/sec
  • Network Interface: Bytes Total/sec
  • Network Interface: Current Bandwidth
  • Network Interface: Output Queue Length


Hunt down SQL Server performance problems

 Home: Introduction
 Step 1: CPU usage
 Step 2: Disk IO queuing
 Step 3: Memory consumption
 Step 4: Network bandwidth
 Step 5: Transaction-level performance

ABOUT THE AUTHOR:   
Jeremy Kadlec
Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also the SearchSQLServer.com Performance Tuning expert. Ask him a question here.
Copyright 2005 TechTarget
This was first published in December 2005

Dig Deeper

PRO+

Content

Find more PRO+ content and other member only offers, here.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

This Content Component encountered an error
Close