Sign in

    Windows File Server SMB SQL OLTP Performance

    Windows File Server SMB SQL OLTP Performance
    • Version:

      February 2013

      File Name:

      SMB2 SQL OLTP Workload.pdf

      Date Published:


      File Size:

      1.1 MB

        A file server running Windows Server 2012 is equipped to host storage for server applications, such as for Microsoft® SQL Server®. The workloads are dominated by non-cached I/O data, which is relatively unstudied (from a file server perspective) in comparison to workloads with significant cached data or metadata traffic, such as the end-user, home-folder scenarios. This document describes the changes that address previously unknown, fundamental issues since the creation of the Windows kernel infrastructure for the current SMB client. These are demonstrated on Windows Server 2008 R2 with the SMB 2.1 protocol, on spinning media, under both synthetic loads (IOMETER) and SQL OLTP driven through Microsoft SQL Server 2010.
    • Supported Operating System

      Windows Server 2008 R2, Windows Server 2012

        PDF Viewer
        • To start the download, click the Download button, and then do one of the following:
          • To start the download immediately, click Open.
          • To copy the download to your computer for viewing at a later time, click Save.
          • To cancel the download, click Cancel.