Differences

This shows you the differences between two versions of the page.

Link to this comparison view

fuss:microsoft_sql_server [2018/05/11 05:03] (current)
office created
Line 1: Line 1:
 +====== Optimizing Microsoft SQL Server inside a Virtual Machine ======
  
 +Microsoft SQL Servers are designed to run a timer in 1ms intervals for precise timekeeping. Unfortunately,​ tight timers inside virtual machines generate a lot of context switches due to threads having to be awoken in very short intervals. The consequence thereof is that a virtual machine may start to consume a large CPU slice.
 +
 +The ''​-T 8038''​ MSSQL trace flag disables the 1ms interval timer thereby preventing the CPU consumption inside a virtual machine. The trace flag must be added as a startup parameter to MSSQL.
 +
 +{{fuss:​fuss_microsoft_sql_server_t8038.png?​512}}

fuss/microsoft_sql_server.txt ยท Last modified: 2018/05/11 05:03 by office

Access website using Tor Access website using i2p


For the copyright, license, warranty and privacy terms for the usage of this website please see the license, privacy and plagiarism pages.