Resolving DTC Related Waits and Tuning Scalability of DTC
First published on MSDN on May 11, 2010 Authored by Mike RuthruffAuthor: Mike Ruthruff Contributors: Gert Drapers, Fabricio Voznika Reviewers: Prem Mehra, Jimmy May, Kun Cheng During a recent performance lab we encountered a large number of waits related to the use of distributed transactions.Monitoring free space in tempdb transaction log
First published on MSDN on Dec 14, 2009 Authored by Thomas KejserAuthor: Thomas Kejser Reviewers: Peter Byrne, Sunil Agarwal, Prem Mehra, Peter Scharlock, Lindsey Allen, Mark SouzaAs part of your database monitoring, you may be keeping track of the free space in the transaction log.Looking deeper into SQL Server using Minidumps
First published on MSDN on Sep 11, 2009 Authored by Thomas KejserAuthor: Thomas Kejser Reviewers and Contributors: Bob Ward, Michael Thomassy, Juergen Thomas, Hermann Daeubler, Mark Souza, Lubor Kollar, Henk van der Valk (Unisys) and Peter Scharlock For advanced troubleshooting and understanding of SQL Server, you can sometimes benefit from creating a dump file of the sqlservr.Previously committed rows might be missed if NOLOCK hint is used
First published on MSDN on Feb 01, 2007 Authored by Lubor KollarI received a question from one of our customers about using the NOLOCK hint: can it cause missing rows in scans even if the rows were committed well before my SELECT with NOLOCK starts? The NOLOCK hint is employed by many users to avoid contention on tables where updates are performed concurrently with selects.
