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