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

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.


This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.