Results 1 to 3 of 3

Thread: DBCC Unpintable

  1. #1
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565

    Unanswered: DBCC Unpintable

    I have a question about dbcc unpintable
    if you unpin a table, it will stay in cache until sql server flushes the cache.
    so
    1. how can you force a cache flush
    2. can this be done programmatically? (ergo: not shutting services down)
    2. can you force a partial flush (dictate, what is or isnt flushed)

    just curious

  2. #2
    Join Date
    Sep 2003
    Posts
    522
    "dbcc dropcleanbuffers" by itself would do just that, - drop unused buffers from the data cache. those buffers contain any data loaded by read-ahead process, as well as data resulted from pinning a table. if you preceed this statement with checkpoint all dirty buffers would be flushed to disk and flagged as clean.

  3. #3
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    interesting how you have to hunt for that one specifically in bol
    and how it isnt in the main dbcc page
    anyhow
    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •