Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-02 : 10:47:06
|
| Mike writes "I am pining tables in memory uising sp_tableoption, then doing a select * to pre load the cache....will this preload index pages as well or only data pages ? Will I need to run a query to load index pages in to memory ?ThanksMike" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-02 : 11:22:30
|
| I can't find anything in Books Online that states index pages are pinned as well, and I don't think you can have them pinned by using index hints either. It's better that indexes are NOT pinned in memory, because they'll just take away buffer RAM that can be used for something else. This is especially true if you're pinning small tables as recommended; pinning the indexes would be a complete waste of RAM.Have you tested that PINTABLE improves performance? Really tested it? I've come across a few instances where it made no difference for the table that was pinned, and slowed down some other table operations. |
 |
|
|
|
|
|
SQL Server 7 Memory and PINTABLE