y. The plan cache pressure limit would be 75 percent of 8 GB plus 50 percent ofthe target memory over 8 GB (or 50 percent of 20 GB), which is 6 GB + 10 GB, or 16 GB.

t is that you can customize it. For

example, it would be relatively straightforward to do one more OUTER APPLY, to join this view

with the sys.dm_exec_query_plan function, to get the XML plan for each of the plans in cache.

USE masterGOCREATE VIEW sp_cacheobjects

(bucketid, cacheobjtype, objtype, objid, dbid, dbidexec, uid,

y ...:·y·~ ..........« ...:_'N.'.'~...W.·.-,'_'_' .... :.; "'. '.', ..' •. '.'

em.

Microsoft4P SQL Server 4P 2008InternalsThe definitive deep-dive on core engine features andhow they work

Delve inside the core SQL Server engine-and put that knowledge towork-with guidance from a team of well-known internals experts.Whether database developer, architect, or administrator, you'll gainthe deep knowledge you need to exploit key architectural changes­and capture the product's full potential.

Discover how SQL Server works behind the scenes,including:

• What happens internally when SQL Server builds, expands,shrinks, and moves databases

• How to use event tracking-from triggers to the ExtendedEvents Engine

• Why the right indexes can drastically reduce your queryexecution time

• How to transcend normal row-size limits with new storagecapabilities

• How the Query Optimizer operates

• Multiple techniques for troubleshooting problematic query plans

• When to force SQL Server to reuse a cached query plan--orcreate a new one

• What SQL Server checks internally when running DBCC

• How to choose among five isolation levels and two concurrencymodels when working with multiple concurrent users

Get code samples and bonus chapters on the Web

See the Introduction for details

• •• •

••• •

•

RESOURCE ROADMAP

Developer Step by Step

• Hands-on tutorial coveringfundamental techniques and features

• Practice files on CO• Prepares and informs new-to-topic

programmers

Developer Reference

Expert coverage of core topics

Extensive, pragmatic coding examples

Builds professional-level proficiencywith a Microsoft technology

Focused TopicsDeep coverage of advancedtechniques and capabilities

t~nsive. adaptable coding examples

romotes full mastery of aMicrosoft technology

ocoo'"";'

'".....x

microsoft.comjmspress

U.S.A. $59.99[Recommended1

See inside cover