option of pinning the tables in memory

Question

option of pinning the tables in memory

Pyman

SSChampion

Points: 13830
More actions
September 29, 2011 at 9:23 am

#259389

Does sql server 2008 r2 support pinning tables to memory. If so do we have any disadvantage?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

No, it does not.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

CarpenterBob Ten Centuries Points: 1026 More actions · Answer 2

http://msdn.microsoft.com/en-us/library/ms143729.aspx

Disadvantages:

what if the power goes out ?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

CarpenterBob (9/29/2011)
http://msdn.microsoft.com/en-us/library/ms143729.aspx

The list of deprecated engine features?

If you were referring to DBCC PinTable, then...

DBCC PINTABLE Has no effect.

It was removed because misused it could cause poor performance, not because there was any problems with power outages or restarts.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Not that it matters now, but what would happen if you'd pin a table that has 10 GB of data with only 8GB on the box?

That seems like a good recipe for bad perf! 😀

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 5

Sapen,

Table Pins were more important when you had incredibly limited RAM on the older 32 bit machines. These days anything you'd want to pin will remain a 'hot' page simply due to better mechanics in SQL 2k5+ and the fact that it's constantly referenced.

So, no, it's a defunct feature that's no longer necessary and was akin to a shotgun without a safety.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA