Differences
This shows you the differences between two versions of the page.
| — |
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
For the copyright, license, warranty and privacy terms for the usage of this website please see the license, privacy and plagiarism pages.