Bottlenecks aka locking & blocking is a quite common scenario within a RDBMS platform, that too SQL Server is not an exception at all. With an access to shared resources causes bottlenecks and demands on shared resources cause poor response time and must be identified and tuned. Few root causes for...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
02-25-2008
Filed under: sql server, performance, memory, dba, i/o, disk, 2008, development, cpu, best practice, capture, resource governor
So far from the CTP release of SQL Server 2008 there has been few enhancements to the Database Mirroring, few of them I would like to list from what has been stated in BOL: Log Performance Enhancements Compression of stream data for which at least a 12.5 percent compression ratio can be achieved. Write...