Rahul Sharma (Editor)

Virtual Interface Adapter

Updated on
Edit
Like
Comment
Share on FacebookTweet on TwitterShare on LinkedInShare on Reddit

A Virtual Interface Adapter ("VIA") is a network protocol (such as TCP/IP ...). As of July 2006 Microsoft SQL Server 2005 supports it. The specific implementation of VIA will vary from vendor to vendor. In general, it is usually a network kind of interface but is usually a very high-performance, dedicated connection between two systems. Part of that high performance comes from specialized, dedicated hardware that knows that it has a dedicated connection and therefore doesn’t have to deal with normal network addressing issues.

The VIA protocol is used to support VIA devices such as VIA Storage Area Network devices.

Comes in the concept of clustering (i.e)Load balacing method. The load balancer will have this VIA and through VIA it will connect the databases.

Note that the VIA protocol is deprecated by Microsoft, and will be removed in a future version of Microsoft SQL Server. It is however supported in SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014.

References

Virtual Interface Adapter Wikipedia