Performance dreams of sql server 2014

Editor's Notes

• #7: When it comes to security the results speak for how important we feel providing the best security is for our customers. As you can see per the latest NIST Comprehensive Vunererability Database published on 4/17/2013 we continue to lead the way 5 years in a row as the least vulnerable database amongst the Top data platforms tracked. In addition it is important to note that we ware the most utilized paid database in the market per IDC with 42% market share. When it comes to security features we have achieved CC certification at High Assurance level for SQL Server. When it comes to separation of duties, SQL Server 2014 now separates Database Administrator role from System Administrator role for greater security. In addition you can even create more granular DBA roles, with different access rights for greater compliance. For example you could have a DBA roles that can manage database but cannot see user data. SQL Server offers Transparent Data Encryption capabilities that are becoming even more important in multi-tenant environments like cloud. Encryption key management allows you to store you encryption keys on a separate server than the one running the SQL Server instance for greater security. Also if you want to reduce the attack surface area even further SQL Server 2014 also support Windows Server Core and finally the last item is not a feature but critical when it comes to achieving these great results. We have redefined our entire SQL Server engineering security processes about 6 years ago when SLAMMER hit and it is a big part of why you see the results that you do. Security is a mantra in SQL Server engineering across all disciplines from development to test. Notes: Update as of 4/17/2013 inclusive. Chart counts NIST CVE – Reported Software Flaws by --------- “published” date, utilizing the NIST ND. SQL Server Query = Vendor Name: Microsoft Corporation; Product Names: sql_server, sql_server, sql_server_desktop_engine, sql_server_express_edition, sql_server_reporting services, sql_srvsql_srv_desktop_engine; Oracle Query = Vendor Name: Oracle; Product Name: ‘Any’, all CVEs where “Vulnerable software and versions” lists a database product; DB2 Query = Vendor Name: IBM; Product Names: db2, db2_content_manager, db2_content_manager_toolkit, db2_server, db2_universal_database; MySQL Query = Vendor Name: mysql, mysql-ocaml, mysql_auction, mysql_eventum, mysql_quick_admin, mysqldumper, mysqlnewsengine; Product Name: ‘Any’ CC certification at High Assurance Level Transparent Data Encryption Encryption Key Management – (note for talktrk- mean keys can live on a separate machine than the machine running SQL Server for greater security) Redefined Engineering Security Processes
• #9: Key capabilities at a high level when it comes to mission critical include In-memory capabilities across all workloads including OLTP, DW and BI. When it comes to security SQL Server has consistently been ranked the most secure with the least amount of vulnerabilities 5 years in a row including this year according to National Institute of Standards and Technology Comprehensive Vulnerability Database. SQL Server 2014 with WS 2012 and WS 2012 R2 can provide to cost effective mission critical scale across physical and virtual environments. We know mission critical is all about the 9’s when it comes to High Availability and with SQL Server 2014 we have made the customer favorite AlwaysOn feature even better to give you the 9’s you need for your mission critical applications. Finally none of these features matter unless we are there to support you in case of issues or failures and we certainly offer the live mission critical support you expect for your mission critical workloads.
• #11: Move this to Futures section
• #15: Move this to Futures section
• #21: Move this to Futures section
• #27: Lets take a look at SQL Server Scalability and how new capabilities in Windows Server 2012 and Windows Server 2012 R2 enable SQL Server to scale. When it comes to scaling compute, Windows Server 2012 not only provide scale for large mission critical databases in a physical environment but also in a virtual environment. WS 2012 supports up to 640 logical processers to tackle the largest applications. In a virtual environment you can utilize up to 64 virtual CPUs per VM and up to 1TB of memory per VM. In addition you have now have up to 64 nodes in a SQL Server cluster. You can also scale networking with network virtualization capabilities in WS 2012 R2. This helps SQL Server because it also you to move on workload from one datacenter to another without having to worry about the underlying network. With the Nic Teaming feature in WS 2012 you can pool multiple NICs with allows for greater network flexibility for SQL Server databases. You can also assign minimum and maximum bandwidth criteria to improve Network QoS. With WS2012 you can also virtualize storage allowing you to accumulate all of your storage and assign pieces to different workloads. You can also tier the storage for higher performance for example a mix of SSDs and standard disks allowing you to create tiers so you can keep hot data in the fastest tier and less utilized data in lower tiers improving performance without increasing costs. Just like WS2012 allows you to create pools of infrastructure and refine and tier those pools, SQL Server take that a step further and provides this type of tiering at the SQL Server instance level with Resource Governor. In addition to being able to pool CPU and Memory you can now with SQL Server 2014 pool IO and tier the pool per your criteria ensuring greater scale and performance predictability for your SQL Server workloads.