Remove 2016 Remove Database Remove Hardware Remove Testing
article thumbnail

Reinventing Performance Testing: New Architectures

Alex Podelko

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Another major trend is using multiple third-party components and services, which may be not easy to properly incorporate into testing. – Cloud.

article thumbnail

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server According to Bob

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. The following chart shows the same 1TB database testing. SQL Server 2016. SQL Server.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Thoughts on SQL Server 2019 Editions

SQL Performance

As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features. I wrote about this in a post entitled, " A Big Deal : SQL Server 2016 Service Pack 1."

Servers 40
article thumbnail

The SQL Server Basic Installer: Just Install It!

SQL Server According to Bob

desktop machine (I won’t tell you the hardware details. Today we are introducing the new Basic Installer experience for SQL Server 2016 Express , SQL Server 2016 Developer , and SQL Server 2016 Evaluation Editions. Go install it”. So I proceeded to install SQL Server 4.20 on my Windows NT 3.1 It would scare you).

Servers 40
article thumbnail

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. In the Sep 2014 the SQL Server CSS and Development teams performed a deep dive focused on scalability and performance when running on current and new hardware configurations.

article thumbnail

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

SQL Server According to Bob

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

article thumbnail

How To Use systemd in Linux to Configure and Manage Multiple MySQL Instances

Percona

Why not just create another database on the same instance? Backup testing. You can run multiple instances on a server to test your backups with the correct version and configs. So you put multiple MySQL servers on a single machine instead of multiple databases inside one MySQL instance. AFAIK Facebook does this.