Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Buffer Pool Extensions Expand / Collapse
Author
Message
Posted Thursday, April 17, 2014 9:00 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:25 PM
Points: 4,809, Visits: 4,257
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
Post #1562703
Posted Friday, April 18, 2014 3:45 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:36 AM
Points: 3,162, Visits: 3,299
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,
SQL Server developer at Seavus
www.seavus.com
Post #1562953
Posted Saturday, April 19, 2014 3:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 1,766, Visits: 737
Ed Wagner (4/17/2014)
Not having yet played with 2014, I learned something new. Thanks.

+1
Post #1563226
Posted Saturday, April 19, 2014 4:00 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 1,766, Visits: 737
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.
Post #1563227
Posted Monday, April 21, 2014 12:17 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, January 21, 2015 1:05 AM
Points: 2,631, Visits: 2,069
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."
Post #1563390
Posted Tuesday, April 22, 2014 7:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, January 21, 2015 9:20 PM
Points: 2,035, Visits: 592
easy one..
thanks steve.
Post #1563844
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse