SQLCAT publish new article on transaction log performance..
Read the publication here https://sqlcat.com/technicalnotes/archive/2008/12/09/diagnosing-transaction-log-performance-issues-and-limits-of-the-log-manager.aspx
Also note the new SQL Server 2008 transaction log specification:
1. Amount of “in-flight” I/O Limit.
a. SQL Server 2008: limit of 3840K at any given time
b. Prior to SQL Server 2008: limit of 480K at any given time
Comments
- Anonymous
December 30, 2008
PingBack from http://www.sqldocumentor.com/report-manager-sql-server-no-longer-uses-rdtsc-performance-monitors