Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hammad_siddiqui
Starting Member
3 Posts |
 Posted - 2011-09-21 : 11:40:27
|
| Hi,We have 1 Database Server and 1 Application/Web server.The Application gets a big bunch of Data from the SQL Database server which creates network bottleneck. As a result I have installed another LAN card in both App and Database servers and have planned to connect them through one switch so that the network capacity b/w both servers can be increased to twice.But could anyone guide me how I will use both networks cards at a time and how these cards would be able to share the load??? and How will I connect the application to the database as I will have two IP addresses now..?? please suggest me any solution..Thanks,Please inform me if you have any question. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
hammad_siddiqui
Starting Member
3 Posts |
Posted - 2011-09-21 : 11:54:36
|
| Thanks for your quick response :),The overall DB size is 155GB with one (content database of SharePoint) having size of 80 GB.The RAM is of 32 GB.Sometime in peak hours the network utilization reached to 99% and I see some jobs as waiting in the Activity Monitor with wait type NETWORK_IO..The network in my office is of 100 mbps (not 1 GB) which makes me think about going for another LAN card to increase the capacity to 200 MBPS.Thanks. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
hammad_siddiqui
Starting Member
3 Posts |
Posted - 2011-09-21 : 16:47:50
|
| Thanks Tara,Can any other person help me in it???Thanks,Hammad A. siddiqui |
|
|
|
|
|
|
SQL Server connection with 2 LAN cards.