Virtual Interface Adapter Explained

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.^[1]

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 balancing method.The load balancer will have this VIA and through VIA it will connect the databases.

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.^{[2] [3]}

See also

• System Area Network

References

• Book: Wood, Dan . Beginning SQL Server 2005 Administration . 2009-10-08 . 2006 . Wrox-Wiley Pub. . 978-0-470-04704-0 . Wood2006.

Notes and References

1. Web site: Choosing a network protocol . Microsoft . 2009 . 2009-10-08.
2. Web site: Creating a Valid Connection String Using VIA Protocol . Microsoft . 2011 . 2011-11-07.
3. Web site: Hardware and Software Requirements for Installing SQL Server 2014 . Microsoft . 2013 . 2014-09-04.