Browse by Tags

• Best Practices
• Performance

• Performance impact: thread mode vs. fiber mode

  SQL Server can run in one of two modes: thread mode or fiber mode. By default, SQL Server runs in thread mode in which a SQL Server worker is associated with a Windows thread throughout all phases of its execution. This can be changed with the sp_configure Read More... Posted Monday, May 04, 2009 4:56 PM by Linchi Shea | 7 Comments Filed under: Best Practices, Performance, SQL Server 2008, Testing Attachment(s): image002.gif

• Performance impact: a large number of virtual log files – Part II

  In my previous post on the performance impact of having a large number of virtual log files (VLFs) in a transaction log, I showed that a large number of VLFs could be very bad for SQL Server 2008 performance. The test workloads were large batch delete, Read More... Posted Thursday, February 12, 2009 1:40 AM by Linchi Shea | 5 Comments Filed under: Best Practices, Performance, SQL Server 2008, Testing Attachment(s): VLF002.gif

• Performance impact: a large number of virtual log files – Part I

  It is generally known that having a large number of virtual log files (VLFs) in a database transaction log is undesirable. A blog post by the Microsoft support team in Stockholm showed that a large number of virtual log files could seriously lengthen Read More... Posted Monday, February 09, 2009 1:13 PM by Linchi Shea | 25 Comments Filed under: Best Practices, Performance, SQL Server 2008, Testing Attachment(s): VLFs.gif