Microsoft has performed testing on several SCSI and IDE drives using the SQLIOSim utility. This utility simulates heavy asynchronous read/write activity to a simulated data device and log device. Test performance statistics show the average write operations per second between 50 and 70 for a drive with disabled write caching and an RPM range ...

This update enables the following: The forced flush behavior during database write activity like checkpoint and transaction log writes. The configuration setting writethrough=1 and alternatewritethrough=1 options by default. These default settings allow SQL Server to make sure that writes are durably flushed to block devices.

When you use the SQLIOSim utility in SQL Server 2008, the SQLIOSim utility stops if you selected the stamp files or if you specified "StampFiles=TRUE" in the configuration file. The optimizer generates an incorrect execution plan for a query that uses a spatial index in SQL Server 2008.

To work around this issue, follow these steps: Enable TLS 1.0 on the server. Restart the server. Run the SQL Server 2012 or SQL Server 2014 Setup program, and update the SQL Server version to a build that supports TLS 1.2. (For more information about the updates that add support for TLS 1.2, see KB 3052404 .) Disable TLS 1.0. Restart the server.

PSSDIAG is a general purpose diagnostic collection utility that Microsoft Product Support Services uses to collect various logs and data files. PSSDIAG can natively collect Performance Monitor logs, SQL Profiler traces, SQL Server blocking script output, Windows Event Logs, and SQLDIAG output.

Summary. Microsoft is aware of a new publicly disclosed class of vulnerabilities that are referred to as “speculative execution side-channel attacks” that affect many modern processors and operating systems including Intel, AMD, and ARM. To learn more about the vulnerability, go to ADV180002.

This article describes Cumulative Update package 3 (CU3) (build number: 12.0.6259.0) for Microsoft SQL Server 2014 Service Pack 3 (SP3). This update contains fixes that were released after the initial release of SQL Server 2014 SP3.

This article describes Cumulative Update package 4 (CU4) (build number: 12.0.6329.1) for Microsoft SQL Server 2014 Service Pack 3 (SP3). This update contains fixes that were released after the initial release of SQL Server 2014 SP3. Cumulative updates (CU) are now available at the Microsoft Download Center.

This article describes Cumulative Update package 1 (CU1) (build number: 12.0.6205.1) for Microsoft SQL Server 2014 Service Pack 3 (SP3). This update contains fixes that were released after the initial release of SQL Server 2014 SP3.

Microsoft SQL Server 和市场上的许多主流数据库产品目前使用预写日志记录 (WAL) 协议。 预写日志记录 (WAL) 协议. 术语协议是极好的方法来描述 WAL。 它是特定的定义一组要确保该数据所需的实现步骤是正确存储和交换和的已知状态出现故障时可以恢复。 就像网络包含定义的协议，所以以一种一致的和受保护的方式交换数据太 WAL 描述了协议以保护数据。 所有的 SQL Server 版本打开使用 Win32 CreateFile函数的日志和数据文件。 DwFlagsAndAttributes成员包括打开 SQL Server 时的FILE_FLAG_WRITE_THROUGH选项。 FILE_FLAG_WRITE_THROUGH.