Virtual Interface Adapter

A Virtual Interface Adapter (VIA) is a network protocol (such as TCP/IP ...) supported by Microsoft SQL Server since July 2005. 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.


Stub icon

This computer networking article is a stub. You can help Wikipedia by adding missing information.

Stub icon

This computing article is a stub. You can help Wikipedia by adding missing information.

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.