Jump to content

Virtual Interface Adapter

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Bender the Bot (talk | contribs) at 23:50, 7 November 2016 (References: clean up; http→https for Google Books using AWB). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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

See also

References

  • Wood, Dan (2006). Beginning SQL Server 2005 Administration. Wrox-Wiley Pub. ISBN 978-0-470-04704-0. Retrieved 2009-10-08.

Notes

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