Chapter 1
1. In general, this requires the existence of two tasks. However, it is possible for a task to block itself. In reality, this occurs rarely and generally results in a deadlock. Its existence can affect scripts used to monitor or investigate blocking.
2. Queries never directly cause physical IO in SQL Server; therefore, physical IO counters are not included. All physical data page IOs are issued by the buffer pool as part of managing the set of cached pages.
Chapter 3
1. Remember that SQL Server has two memory settings that you can control using sp_configure. They are max and min server memory. These two settings really control the size of the SQL Server’s BP. They do not control the overall amount of physical memory consumed by ...
Get SQL Server 2005 Practical Troubleshooting: The Database Engine now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
