To determine if a network interface card (NIC) limitation is causing performance issues, use the Task Manager...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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
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