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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server connection with 2 LAN cards.

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

Posted - 2011-09-21 : 11:45:17
You can configure this in SQL Server Configuration Manager.

I highly doubt that you've even got a network bottleneck though to even need to do this. What proof is there that adding another NIC is going to help? How much memory do you have on your database server? How big is the database?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-21 : 12:26:15
Okay cool. Some people start working on problems that don't exist as they don't understand the actual root problem. But it sounds like you do have a network problem.

I am not clear that adding another NIC is going to solve your problem. That's outside of my area of expertise. I just know that you can configure it how you want with the SQL Server Configuration Manager tool.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -