Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

If you have multiple instances of SQL Server running on the same windows server system,

a) Does buffer pool is shared amount multiple instances?

b) What is the effect of running DBCC DROPCLEANBUFFER OR DBCC FREEPROCCACHE? Would that only affect the SQL Server instance you ran the command on or all the instance(s) on the windows box would flush SQL server cache?

share|improve this question

migrated from stackoverflow.com Jan 11 '12 at 14:58

This question came from our site for professional and enthusiast programmers.

    
Marthin Smith Thank you –  SQL Learner Jan 11 '12 at 16:15

1 Answer 1

up vote 6 down vote accepted

The buffer pool in SQL Server isn't shared across intances.

DBCC DROPCLEANBUFFER removes all "clean" pages from the buffer pool, "clean" pages are pages which haven't been modified since being read into the buffer pool.

DBCC FREEPROCCACHE removes all cached execution plans from the plan cache.

share|improve this answer
    
OK your answer make sense. Max Server Memory setting controls buffer pool memory allocated to that SQL instance. –  SQL Learner Jan 11 '12 at 16:16
    
That correct Max Server Memory in SQL Server 2008 R2 and lower controls the Single Page Allocations, Multiple Page Allocations aren't controled by the Max Server Memory see for more details sqlservercentral.com/articles/Memory/74867 –  MartinC Jan 11 '12 at 18:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.