SQL Server Performance Forum – Threads Archive
dbcc PINTABLE
Hi, As per the details given in BOL DBCC PINTABLE option is removed from SQL Serve 2005. Do anyone know any other way to achieving PINTABLE functionality in SQL Serve 2005. Please provide me your input. Thanks and RegardsRavi K
It works and it will not have any affect.
Why do you want to do so, it is not advisable to PINTABLE Although DBCC PINTABLE can provide performance improvements, it must be used with care. If a large table is pinned, it can start using a large part of the buffer cache and not leave enough cache to service the other tables in the system adequately. If a table larger than the buffer cache is pinned, it can fill the whole buffer cache. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
You can schedule a task that repeatedly selects from the table in question to keep it in RAM. But that in itself will consume resources and may defeat the purpose… Basically the best thing is to ensure you have enough RAM, and let SQL Server manage its cache itself…
The data from a frequently queried table is in the buffer cache anyway. So what do you want to achieve? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
leave this alone unless you really know what you are doing
Hi,
are you facing any performance issue !? Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
]]>