Buffer Pool Extensions

Question

Post reply

Buffer Pool Extensions

Steve Jones - SSC Editor

SSC Guru

Points: 734449
More actions
April 16, 2014 at 9:37 pm

#75690

Comments posted to this topic are about the item Buffer Pool Extensions
April 17, 2014 at 2:12 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 15 total)

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

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Too easy thanks Steve

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Revenant SSC-Forever Points: 42467 More actions · Answer 2

Ford Fairlane (4/16/2014)
Too easy thanks Steve

+1 -this feature is difficult to miss

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 3

Easy one thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 4

Thank you for the post, SJ.

(I have installed the SQL 2014 help files yesterday night locally and I had to depend on it literally to answer this question, I read the page on BPE and I was like 2014 has some really cool features and hoping one day, I mean before SQL 2020 will be released, then we, Indians, possibly will think of installing and use it 🙂 OR I can buy the developer edition and learn/improve on my own...:cool:)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 5

Revenant (4/16/2014)
Ford Fairlane (4/16/2014)
Too easy thanks Steve
+1 -this feature is difficult to miss

+1 This is one of the main features I was looking forward to.

Everything is awesome!

Richard Warr SSCertifiable Points: 6963 More actions · Answer 6

Richard Warr

SSCertifiable

Points: 6963

April 17, 2014 at 7:25 am

#1706745

Easy (after I looked it up).

david.gugg SSCertifiable Points: 6032 More actions · Answer 7

Wow, as I looked through the possible answers, the correct one was the one I thought was certainly wrong. I always associate buffer pool with RAM, so I wouldn't have thought extending it to physical storage would make sense. Good thing I decided to look it up before answering 🙂

[font="Tahoma"]Personal blog relating fishing to database administration:[/font]
[font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

sknox SSChampion Points: 12388 More actions · Answer 8

I remembered hearing about this at PASS 2013, and remembered correctly!

Some interesting wrong choices, though!

Ed Wagner SSC Guru Points: 287024 More actions · Answer 9

Not having yet played with 2014, I learned something new. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 10

This is a great new feature in Sql Server 2014

Example (http://msdn.microsoft.com/en-us/library/ee210585(v=sql.120).aspx)

ALTER SERVER CONFIGURATION

SET BUFFER POOL EXTENSION ON

(FILENAME = 'F:\SSDCACHE\Example.BPE', SIZE = 50 GB);

Thanks

Igor

Igor Micev,My blog: www.igormicev.com

Hany Helmy SSChampion Points: 13921 More actions · Answer 11

Ed Wagner (4/17/2014)
Not having yet played with 2014, I learned something new. Thanks.

+1

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 12

Igor Micev (4/18/2014)
This is a great new feature in Sql Server 2014
Example (http://msdn.microsoft.com/en-us/library/ee210585(v=sql.120).aspx)
ALTER SERVER CONFIGURATION
SET BUFFER POOL EXTENSION ON
(FILENAME = 'F:\SSDCACHE\Example.BPE', SIZE = 50 GB);
Thanks
Igor

+1 good example.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

free_mascot One Orange Chip Points: 27169 More actions · Answer 13

Thank you! for question on new feature of SQL 2014.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."