Tags : #sqlserver

29

Nov

SQL Server 2017: The world’s first enterprise-class diskless database

This post is authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and Performance Architect, Microsoft Database Systems Group.

Perhaps you saw the keynote at the recent PASS 2017 Summit where Microsoft demonstrated the performance of the world’s first enterprise-class “diskless database”. This demonstration showed how Microsoft, Hewlett Packard Enterprise (HPE), and SUSE Linux Enterprise Server partnered together to deliver > 5x performance on analytic queries directly against storage at up to 50 percent of the cost.

Recently HPE published a new world record 1TB TPC-H benchmark result¹ using this configuration with their DL380 Gen10 Server showing 1,009,065 QphH at an incredible price/performance of $0.47 USD per QphH. Performance and price are achieved by combining the power of SQL Server 2017, HPE’s scalable persistent memory, and SUSE Linux Enterprise 12 SP3 Persistent Memory Support.

HPE’s scalable persistent memory is a new innovation which combines standard memory with the persistence of standard storage. It allows database engines like SQL Server 2017 to retrieve data from its data files in a matter of seconds.

To see this technology in action, check out this video. To learn more about this amazing result and technology, read HPE’s blog post and SUSE’s

Share

29

Nov

Upgrade your SQL Server to scale before adding new hardware
Upgrade your SQL Server to scale before adding new hardware

https://blogs.msdn.microsoft.com/sql_server_team/upgrade-your-sql-server-to-scale-before-adding-new-hardware/Source: https://blogs.msdn.microsoft.com/sql_server_team/upgrade-your-sql-server-to-scale-before-adding-new-hardware/   In SQL Server Tiger team, we closely partner with our customers and partners to ensure they can successfully run and scale their Tier 1 mission critical workloads and applications on SQL Server. Based on our experience and READ MORE

Share

22

Nov

How we made backups faster with SQL Server 2017
How we made backups faster with SQL Server 2017

https://blogs.msdn.microsoft.com/sql_server_team/how-we-made-backups-faster-with-sql-server-2017/Source: https://blogs.msdn.microsoft.com/sql_server_team/how-we-made-backups-faster-with-sql-server-2017/   In my previous blog post on enhancements in SQL Server 2017, we briefly introduced improved backup performance for smaller databases in SQL Server 2017 on high end servers. In the recent PASS Summit 2017, Pedro and I READ MORE

Share

21

Nov

Perfect statistics histogram in just few steps
Perfect statistics histogram in just few steps

https://blogs.msdn.microsoft.com/sql_server_team/perfect-statistics-histogram-in-just-few-steps/Source: https://blogs.msdn.microsoft.com/sql_server_team/perfect-statistics-histogram-in-just-few-steps/   A similar question about statistics came to the team twice this week: why does updating with fullscan result in fewer histogram steps than when doing a sampled scan? The answer is: the number of histogram steps can READ MORE

Share

16

Nov

SQL Server 2017: A proven leader in database performance
SQL Server 2017: A proven leader in database performance

This post was authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and Performance Architect, Microsoft Database Systems Group.

SQL Server continues to be a proven leader in database performance for both analytic and OLTP workloads. SQL Server 2017 is fast, built-in with capabilities and features such as Columnstore indexes to accelerate analytic performance and Automatic Tuning and Adaptive Query Processing to keep your database application at peak speed.

Recently, Hewlett Packard Enterprise (HPE) announced a new world record TPC-H 10TB benchmark result¹ using SQL Server 2017 and Windows Server 2016 on their new DL580 Gen10 Server. This new amazing result at 1,479,748 Composite Query-per-Hour (QphH) was achieved at price/performance of .95 USD per QphH continuing to show SQL Server’s leadership in price and performance.

HPE also announced the first TPC-H 3TB result² on a 2-socket system using SQL Server 2017 and Windows Server 2016 with their DL380 Gen Server. They achieved a stellar 1,014,374 QphH on only 2-sockets. These results continue to show how powerful SQL Server can be to handle your analytic query workloads including data warehouses.

SQL Server also is a proven leader for OLTP workloads. Lenovo recently announced a new world-record TPC-E benchmark

Share

16

Nov

SQL Server 2017: A proven leader in database performance
SQL Server 2017: A proven leader in database performance

This post was authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and Performance Architect, Microsoft Database Systems Group.

SQL Server continues to be a proven leader in database performance for both analytic and OLTP workloads. SQL Server 2017 is fast, built-in with capabilities and features such as Columnstore indexes to accelerate analytic performance and Automatic Tuning and Adaptive Query Processing to keep your database application at peak speed.

Recently, Hewlett Packard Enterprise (HPE) announced a new world record TPC-H 10TB benchmark result¹ using SQL Server 2017 and Windows Server 2016 on their new DL580 Gen10 Server. This new amazing result at 1,479,748 Composite Query-per-Hour (QphH) was achieved at price/performance of .95 USD per QphH continuing to show SQL Server’s leadership in price and performance.

HPE also announced the first TPC-H 3TB result² on a 2-socket system using SQL Server 2017 and Windows Server 2016 with their DL380 Gen Server. They achieved a stellar 1,014,374 QphH on only 2-sockets. These results continue to show how powerful SQL Server can be to handle your analytic query workloads including data warehouses.

SQL Server also is a proven leader for OLTP workloads. Lenovo recently announced a new world-record TPC-E benchmark

Share

16

Nov

SQL Server 2017: A proven leader in database performance
SQL Server 2017: A proven leader in database performance

This post was authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and Performance Architect, Microsoft Database Systems Group.

SQL Server continues to be a proven leader in database performance for both analytic and OLTP workloads. SQL Server 2017 is fast, built-in with capabilities and features such as Columnstore indexes to accelerate analytic performance and Automatic Tuning and Adaptive Query Processing to keep your database application at peak speed.

Recently, Hewlett Packard Enterprise (HPE) announced a new world record TPC-H 10TB benchmark result¹ using SQL Server 2017 and Windows Server 2016 on their new DL580 Gen10 Server. This new amazing result at 1,479,748 Composite Query-per-Hour (QphH) was achieved at price/performance of .95 USD per QphH continuing to show SQL Server’s leadership in price and performance.

HPE also announced the first TPC-H 3TB result² on a 2-socket system using SQL Server 2017 and Windows Server 2016 with their DL380 Gen Server. They achieved a stellar 1,014,374 QphH on only 2-sockets. These results continue to show how powerful SQL Server can be to handle your analytic query workloads including data warehouses.

SQL Server also is a proven leader for OLTP workloads. Lenovo recently announced a new world-record TPC-E benchmark

Share

15

Nov

Announcing SQL Operations Studio for preview
Announcing SQL Operations Studio for preview

We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.

Download SQL Operations Studio to get started.

It’s easy to connect to Microsoft SQL Server with SQL Operations Studio and perform routine database operations—overall lowering the learning curve for non-professional database administrators who have responsibility for maintaining their organization’s SQL-based data assets.

As more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves taking responsibility for developing and operating databases. These individuals often do not have time to learn the intricacies of their database environment, making hard to perform even the most routine tasks. Microsoft SQL Operations Studio takes a prescriptive approach to performing routine tasks, allowing users to get tasks done fast while continuing to learn on the job.

Users can leverage their favorite command line tools (e.g. Bash, PowerShell, sqlcmd, bcp and ssh) in the integrated terminal window right within the SQL Operations Studio user interface. They can easily generate

Share

15

Nov

Announcing SQL Operations Studio for preview
Announcing SQL Operations Studio for preview

We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.

Download SQL Operations Studio to get started.

It’s easy to connect to Microsoft SQL Server with SQL Operations Studio and perform routine database operations—overall lowering the learning curve for non-professional database administrators who have responsibility for maintaining their organization’s SQL-based data assets.

As more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves taking responsibility for developing and operating databases. These individuals often do not have time to learn the intricacies of their database environment, making hard to perform even the most routine tasks. Microsoft SQL Operations Studio takes a prescriptive approach to performing routine tasks, allowing users to get tasks done fast while continuing to learn on the job.

Users can leverage their favorite command line tools (e.g. Bash, PowerShell, sqlcmd, bcp and ssh) in the integrated terminal window right within the SQL Operations Studio user interface. They can easily generate

Share

15

Nov

Announcing SQL Operations Studio for preview
Announcing SQL Operations Studio for preview

We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.

Download SQL Operations Studio to get started.

It’s easy to connect to Microsoft SQL Server with SQL Operations Studio and perform routine database operations—overall lowering the learning curve for non-professional database administrators who have responsibility for maintaining their organization’s SQL-based data assets.

As more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves taking responsibility for developing and operating databases. These individuals often do not have time to learn the intricacies of their database environment, making hard to perform even the most routine tasks. Microsoft SQL Operations Studio takes a prescriptive approach to performing routine tasks, allowing users to get tasks done fast while continuing to learn on the job.

Users can leverage their favorite command line tools (e.g. Bash, PowerShell, sqlcmd, bcp and ssh) in the integrated terminal window right within the SQL Operations Studio user interface. They can easily generate

Share