SQL Questions & AnswersClusters, Isolation, and More
A The SQL Server Books Online and msdn.microsoft.com contain overviews as well as technical details on how to determine the correct isolation level. For example, the following isolation levels are explained at "Accessing and Changing Relational Data: Isolation Levels":
A You could use PerfMon. You can start with the following, but may have to add simple scripts to query system tables:
SQLServer:Databases\Log File(s) Size (KB)
SQLServer:Database\Log File(s) Used Size (KB)
SQLServer:Database\Percent Log Used
See the document "SQL Server 2000 Operations Guide: Monitoring and Control". You could also write some simple scripts or use Microsoft Operations Manager (MOM). Some of the Dynamic Management Views (DMVs) that are relevant for SQL Server 2005 might be useful:
© 2008 Microsoft Corporation and CMP Media, LLC. All rights reserved; reproduction in part or in whole without permission is prohibited.