With the increase in data that is being stored and analyzed , the concepts such as Big Data, Column Store and In Memory databases have been in discussion or being used by different organizations. Also there are multiple vendors at play, the one size fits all doesn't seem to be working. Please see this video where in Michael Stonebraker talks about the different concepts such as Column Store, Big Data and In Memory databases. He specifically mentions not to give in to the marketing hype and use proper proof of concepts on site with the data that needs to be analyzed to arrive at the right solution needed for an Organization. Here is the link for the video, it is a bit old but I felt is very relevant in terms of the questions to be asked.
https://www.youtube.com/watch?v=_00H1cgXeWw. Mike specifically talks about how important columnstore is going to be in Data warehouses.
Showing posts with label In Memory. Show all posts
Showing posts with label In Memory. Show all posts
Thursday, July 23, 2015
Thursday, September 11, 2014
SQL Server 2014 - Top Features...
Here is a summarised list of new features in SQL Server 2014 that could be worth an upgrade. There are still a lot of customers on SQL Server 2008, they could take the path straight to 2014 instead of going to SQL Server 2012.
1. New In-Memory OLTP Engine
2. Enhanced Windows Server Integration
3. Enhancements to AlwaysOn Availability Groups
4. Enhancements to Backups
5. Updateable ColumnStore Indexes
6. SQL Server Data Tools for Business Intelligence
7. PowerBI for Office 365 Integration
The New-In Memory OLTP Engine and ColumnStore Indexes are bound to attract the OLTP and OLAP Customer base. Please read through these feature details in the following link. The link gives a more detailed description of the features.
http://sqlmag.com/sql-server-2014/sql-server-2014-important-new-features.
1. New In-Memory OLTP Engine
2. Enhanced Windows Server Integration
3. Enhancements to AlwaysOn Availability Groups
4. Enhancements to Backups
5. Updateable ColumnStore Indexes
6. SQL Server Data Tools for Business Intelligence
7. PowerBI for Office 365 Integration
The New-In Memory OLTP Engine and ColumnStore Indexes are bound to attract the OLTP and OLAP Customer base. Please read through these feature details in the following link. The link gives a more detailed description of the features.
http://sqlmag.com/sql-server-2014/sql-server-2014-important-new-features.
Wednesday, May 7, 2014
SQL Server 2014 and Tempdb...
One of the challenges faced in SQL Server development is how to handle tempdb and make sure that temp tables are not causing excessive disk i/o. Then came table variables and there have been lot of posts about which is better (table Variables vs temp tables). Now in SQL Server 2014 there has been some kind of improvement for tempdb. Please read the blog post below from SQL Server Expert Kendra Little:
http://www.brentozar.com/archive/2014/04/memory-ssd-tempdb-temp-table-sql-2014/
One thing to note is that tests were run on machines which had storage on SSD. The above blog article is built upon the original blog post listed below:
http://blogs.msdn.com/b/psssql/archive/2014/04/09/sql-server-2014-tempdb-hidden-performance-gem.aspx. To quote from the original blog article:
"Prior to the SQL Server 2014 change the select into may have written all the pages accumulated to disk. The SQL Server 2014, eager write behavior, no longer forces these pages to disk as quickly as previous versions".
http://www.brentozar.com/archive/2014/04/memory-ssd-tempdb-temp-table-sql-2014/
One thing to note is that tests were run on machines which had storage on SSD. The above blog article is built upon the original blog post listed below:
http://blogs.msdn.com/b/psssql/archive/2014/04/09/sql-server-2014-tempdb-hidden-performance-gem.aspx. To quote from the original blog article:
"Prior to the SQL Server 2014 change the select into may have written all the pages accumulated to disk. The SQL Server 2014, eager write behavior, no longer forces these pages to disk as quickly as previous versions".
Tuesday, April 1, 2014
SQL Server 2014 - Evaluation...
As folks are getting comfortable SQL Server 2012, In some cases I have heard that users want to bypass SQL Server 2012 and upgrade straight to SQL Server 2014 from SQL Server 2008. One of the big attractions is use of in memory technologies across the OLTP, Data warehousing and BI platforms. There not been much of improvements in SSIS and SSRS but SSAS/BI has got some new features. Please check the following link for all the features and the product itself.
http://www.microsoft.com/en-us/server-cloud/products/sql-server/#fbid=l3BkTG6tymf.
The image below was taken from the SQL Server 2014 Data Sheet...which talks about In memory across all workloads.
Hope one of these days I will get to install and evaluate SQL Server 2014.
http://www.microsoft.com/en-us/server-cloud/products/sql-server/#fbid=l3BkTG6tymf.
The image below was taken from the SQL Server 2014 Data Sheet...which talks about In memory across all workloads.
Hope one of these days I will get to install and evaluate SQL Server 2014.
Monday, November 25, 2013
SQL Server 2014 - In Memory OLTP...
In the Pass Summit held in Charlotte last month, there was lot of focus on SQL Server 2014, especially the In Memory OLTP component. This particular topic has triggered interest in this version. In order to test this feature out of course needs to set up the environment right. Please refer to the following links for detailed information about In Memory OLTP operation. The following links answers questions like :
Is In-Memory OLTP the solution to all my performance concerns?
http://blogs.msdn.com/b/sqlcat/archive/2013/11/13/sql-server-2014-in-memory-oltp-discussions-at-pass-summit-2013.aspx
http://blogs.technet.com/b/dataplatforminsider/archive/2013/09/17/new-amr-tool-simplifying-the-migration-to-in-memory-oltp.aspx .
http://blogs.technet.com/b/dataplatforminsider/archive/2013/10/11/in-memory-oltp-how-durability-is-achieved-for-memory-optimized-tables.aspx.
Hope the readers have a good insight into In Memory OLTP.
Is In-Memory OLTP the solution to all my performance concerns?
http://blogs.msdn.com/b/sqlcat/archive/2013/11/13/sql-server-2014-in-memory-oltp-discussions-at-pass-summit-2013.aspx
http://blogs.technet.com/b/dataplatforminsider/archive/2013/09/17/new-amr-tool-simplifying-the-migration-to-in-memory-oltp.aspx .
http://blogs.technet.com/b/dataplatforminsider/archive/2013/10/11/in-memory-oltp-how-durability-is-achieved-for-memory-optimized-tables.aspx.
Hope the readers have a good insight into In Memory OLTP.
Wednesday, December 12, 2012
In Memory Analytics...
In the past couple of years there has been a lot of growth in the different type of Analytics that is being performed at various organizations. There has been a tremendous requirement for companies to be very Agile and have a speed to market to introduce their products and services. This has resulted in lot of exciting requirements for the BI Analytics domain to fullfill. In the SQL Server space, Microsoft first introduced inMemory analytics through PowerPivot. Now with SQL Server 2012 we have a new type of Analytics called the Tabular Model which uses InMemory Analytic capabilties. This is different from the SSAS model of analytics. These days the end users/Business users have been provided with tools to harness the power of inMemory Analytics. The couple of in Memory technologies available in SQL Server 2012 are xVelocity Analytics, xVelocity Column Store and Power Pivot. Quoting the Microsoft web site(www.microsoft.com),xVelocity is a family of memory-optimized technologies spanning Analytical, Transactional, Streaming and Caching data. Designed for industry standard hardware, xVelocity is a built-in capability in SQL Server 2012, SQL Server Parallel Data Warehouse, Office Excel 2013 and Windows Azure. Please read the following the blog post in the link provided below about a very fast inMemory analytics project from Microsoft, this is still in Private customer Preview.
http://blogs.technet.com/b/dataplatforminsider/archive/2012/12/11/how-fast-is-project-codenamed-hekaton-it-s-wicked-fast.aspx
http://blogs.technet.com/b/dataplatforminsider/archive/2012/12/11/how-fast-is-project-codenamed-hekaton-it-s-wicked-fast.aspx
Subscribe to:
Posts (Atom)
