SQL Server Performance

SQL Server 2008 Resource Governor FAQ

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Feb 24, 2008.

  1. Anonymous New Member

    Bottlenecks aka locking &amp; 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 such blocking are: Insufficient resources, requiring additional or upgraded components. Resources of the same type among which workloads are not distributed evenly; for example, one disk is being monopolized....(<a href="http://sqlserver-qa.net/blogs/sql2008/archive/2008/02/25/3626.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3626" width="1" height="1">

Share This Page