Improve SQL Server Performance with DC500M Enterprise SSDs

Feb 2020

Blog Home

Save Time and Money

This whitepaper demonstrates how using Kingston Technology’s Data Centre DC500 Enterprise Solid-State Drives (SSDs) can reduce your overall capital and licence costs by 39%.

SQL Server 2008 workloads can cost effectively be migrated to a modern hardware and software solution using modern servers and Kingston Technology DC500M Enterprise Solid-State Drives (SSD) with Microsoft SQL 2017 Windows Server 2019 Datacenter Edition..

Most customers will finally retire the 2008-era hardware on which the SQL Server 2008 currently runs and can now decide on enterprise-class, reliable performance hardware to run their migrated workloads.

Download Whitepaper

Why is this important?

Microsoft has changed to a per-core licensing model for both SQL Server and Windows Server, making licensing decisions more complicated, and poor licensing decisions more expensive.

Well-informed choices can minimise software licence cost, as we will demonstrate.

What this whitepaper will detail.

What it means to you as you upgrade your SQL Server 2008 R2 servers to SQL Server 2017, cutting your SQL Server licensing costs by 75% and achieving better performance.
Using DC500M drives makes it possible to reduce the vCores needed to get similar performance to your existing database solutions. This is because the DC500M Enterprise SSD can process more transactions with lower latency.
By reducing the number of host servers needed, you reduce both hardware and software licence costs.
Greater workload consolidation using fewer cores requires fewer per-core licences, helping you realise significant savings.

#KingstonIsWithYou

Was this helpful?

Blog Home

Enterprise Database Performance Under Real I/O Pressure

A white paper assessing the Kingston DC3000ME SSD’s performance under storage pressure.
SSD Power Loss Protection: How Hardware & Firmware PLP Prevent Data Loss

How power loss protection helps SSDs safeguard data during sudden power loss.
How Hardwareluxx Upgraded Their Server Infrastructure to Handle Rapid Growth

A real‑world look at modernizing server infrastructure for high‑traffic digital platforms.
How to test an enterprise SSD part 1: Use your exact environment with real data, apps and hardware

SSD test beds for enterprise servers should be done with the real hardware, OS and data. We’ll explain why.
Reliable backups for cloud computing

A look at how companies manage their systems when cloud computing is unavailable.
What Is ECC in Memory and SSD? Why It Matters for Servers and Enterprise Systems

How ECC in memory and SSDs protects data integrity and reliability in server environments.
Understanding EU Data Sovereignty: Compliance, Cloud Risk & Data Control

Your guide to EU data sovereignty, risks, and secure data storage strategies.
Server memory buying guide: top 10 tips you need to know

10 expert tips for buying server memory: ECC, compatibility and performance.
Different types of server memory and how they impact performance

Explore server memory types and how each affects server performance and reliability.
How Memory Fits Into The Virtualisation Space

Key drivers for IT adoption include the many benefits in virtualising a data center and consolidating server hardware.
Intel Xeon 6 guide: Key features, benefits and use cases

From performance to DDR5, this Xeon 6 guide helps enterprises understand next-gen processors.
PCIe Gen5 NVMe for AI: MLPerf Storage v2 Findings on Kingston's DC3000ME Executive Summary

Machine learning training is resource-intensive, but how does a Kingston SSD measure up to the task?
Why DDR5 memory is important for data center performance and efficiency

Learn why DDR5 server memory improves data center performance and efficiency.
Turning data into insight: Kingston’s role in smarter manufacturing

Kingston and Taiwan Intelligent Robotics Company highlight smart manufacturing and AI, powered by Kingston’s trusted technology.
Understanding a new generation of DDR5 memory modules: CUDIMM, CSODIMM, CAMM2 and MRDIMM

Learn how innovative memory solutions are transforming laptops, desktops and data centers.
Optimise server storage with PCIe Gen5 SSDs for AI and big data

Explore how SSDs are transforming data centers with advanced technology and performance.
Mission Digital enhances their workflows with DC600M SSDs

Learn how Kingston SSDs transformed Mission Digital’s workflow with speed and capacity.
The importance of SSDs in data centers – expert insights

Join Simon Bestman to explore SSD benefits over HDDs and the latest storage trends.
Why a home NAS should be for everyone

Reasons why a NAS would benefit your home or small office setup.
Building trust through performance: Kingston’s enterprise solutions elevate system integrators

System integrators in India grew their business and reputation using Kingston’s reliable products.
How to choose the right drive for your data

Here is a list of USB security features to consider for data protection.
The 3-2-1 data backup method: your best defence against ransomware attacks

Learn what the 3-2-1 data backup method is and why it is your best defence against ransomware.
The evolution and challenges of data centers – Expert insights

Simon Besteman explains the current and future challenges for data centers.
The evolution of memory technology – eBook

Explore DRAM technology’s evolution and gain insights into future trends in our eBook.
Enterprise versus client SSD

Built for disparate purposes, client SSDs and enterprise SSDs have different properties.
Understanding SSD endurance: TBW and DWPD

Learn how Terabytes Written and Drive Writes Per Day are defined, and their differences.
How to choose server memory

We explore the different types of memory & how to make the right choice for your server.
Revolutionising data center efficiency with VMWare vSAN and DC600M

Read the whitepaper to learn how DC600M helps vSAN demand performance and efficiency.
Unlocking the secrets of Kingston’s DRAM module testing

Kingston sets industry standards with unwavering commitment to quality and reliability.
How do Kingston SSDs & QNAP NAS power the DCP workflow for digital cinemas?

Kingston and QNAP have improved the efficiency of digital cinemas with their hardware.
Find the best SSD for your data center

Questions to ask when seeking the right SSD for your organisation’s data center.
How many Drive Writes Per Day (DWPD) do you actually need?

Here are some key points to help you better balance price, performance and longevity.
Memory and storage unleashed: Fuelling creativity in entertainment

We explore the how media organisations can speed up workflows through storage and memory.
2024: Technology experts’ predictions

2023 has been a year full of challenges and innovations. But what will 2024 bring?
Kingston DC600M data center SSD: Now VMware ESXi and vSAN compatible

Elevate your data center with Kingston's VMware compatible DC600M enterprise SSDs.
Enhancing content creator’s workflow with Kingston SSDs and memory

Kingston's server SSD and memory transformed Android Basha's production workflow.
Performance photographer Ralph Larmann in the digital darkroom

Kingston storage solutions help improve performance photographer Ralph Larmann’s workflow.
How did Kingston SSDs help DASH Pictures transform on-location and post-production workflows?

DASH Pictures enhances their media production efficiency with Kingston SSDs.
More for less: Why is upgrading important in today's economic climate?

Discover why upgrading your technology in this economy matters more than ever.
Unlocking the power: 5 reasons for using data center SSDs

Server SSDs have higher endurance, better reliability and improved performance over client SSDs.
Extend the life of your IT: Upgrade vs replace

We explore the benefits of upgrading vs replacing, and how organisations can succeed.
Upgrading server hardware vs buying the latest platform

Assess your existing server hardware to extend its lifespan and maximise your investment.
NVMe is the silent IT revolution – what is it, and why you should adopt it?

Learn about NVMe and why choosing it is beneficial to your organisation’s infrastructure.
The rise of the digital twin: The secret weapon to next level operations

We discuss the journey of digital twin technology, exploring real-world examples for success.
SDS vs hardware RAID vs software RAID: What is the future?

In this whitepaper, we explain the benefits of SDS, vs their HW and SW RAID counterparts.
Kingston and 2CRSi solve data centers energy consumption challenges

In this video, we explain how Kingston and 2CRSi work together to solve data center challenges.
Kingston memory and SSD meet integrator APLIGO GmbH's strict requirements

Learn why APLIGO chose Kingston SSD and Memory to support their system integration business.
Evaluating storage products for your enterprise needs

Choosing storage products for your enterprise is a complex process. Kingston offers our expertise.
Optimising storage in a creative world

Learn how Kingston and QNAP solutions help to optimise content creation.
Kingston memory and storage supporting the needs of a leading hosting provider

Learn how Kingston supported a leading hosting provider with optimal configuration.
Build resilient, responsive databases with Kingston’s DC1500M Enterprise NVMe SSDs

Kingston examines how its DC1500M Enterprise NVMe SSD affects workloads and compares to competitors.
SSDs: The changing face of data storage eBook

In this eBook, we speak with experts about the journey of data storage, and what the future holds.
SSDs and RAM power every step of the streaming media and entertainment pipeline

From shooting to post-production, encoding and distribution at data centers, SSDs and RAM are powering the world of OTT Media & Entertainment (M&E) video and audio streaming.
Top 12 tips SMEs can take to enhance cybersecurity

We explore the top 12 tips small and medium size enterprises can take to enhance cybersecurity.
What is driving the growth of data centers?

This infographic is about the different types of data centers, the myths and Kingston's DC solutions.
Kingston’s 3 predictions for the data center and enterprise IT in 2022

We’ve examined several factors using unique research to identify what may impact markets globally in 2022.
2022: Technology expert predictions

2021 has been a year full of challenges and innovations. But what will 2022 bring?
Digital transformation: Sustaining success in a new business era

Read our eBook, about the rise of digital transformation and what the future holds.
Sustained commitment required for cybersecurity

Bill Mew shares his thoughts how the largest security challenges need commitment from the boardroom.
Are you close to the edge? Why edge computing needs security

Rob May shares his thoughts on how close we are to edge computing and the security it requires.
Enterprise capabilities in the palm of your hand: a videographer’s experience with the DC500M

The high-performance DC500M Server SSD is the best storage choice for a pro videographer.
How memory and storage have supported the digital evolution

Memory and storage have evolved over the years, get an insight from our industry expert.
Accelerate your server performance with SSD RAID arrays

Our partnership with Microchip’s RAID controllers helps deliver high performance for server storage.
Case Study: How Simply Hosting benefited from collaborative service and support

Kingston helped to optimise Simply Hosting’s storage in their data centers to ensure they were always on.
How Kingston helped lower data center power costs by 60%

Learn how Kingston helped to lower power costs, increase performance so Hostmein could deliver on SLAs.
Beyond smart cities: How IoT is changing the world

In this eBook we speak with experts about IoT’s journey and prepare organisations for IoT’s future.
The critical roles of data centers during COVID-19

The pandemic has increased internet traffic, which has placed importance on the role of data centers.
Should I Make the Switch to NVMe?

Cameron Crandall of Kingston helps you decide if you should move to your server storage to NVMe SSDs.
Sustainability, innovation and partnership series - Episode 2

Join industry experts to discuss how technology partners like Kingston support their business growth and sustainability.
The NVMe promise: Squeeze more out of existing CPUs

NVMe over Fabric helps CPUs to run more efficiently with lower latency and higher throughput.
Sustainability, innovation and partnership series - Episode 1

Industry experts discuss topics like the key pillars of Tech relationships, sustainability and IT optimisation.
Webinar: How is NVMe revolutionising storage?

Watch this webinar to discover the benefits of NVMe SSDs.
NVMe: Redundancy and RAID

The switch to NVMe requires a full-stack review from IT architects to ensure redundancy exists on every layer of the stack.
Using AI to turn today’s challenges into tomorrow’s opportunities

In this eBook, we talk to industry experts as we explore the benefits of Artificial Intelligence, how it’s fuelling data consumption and how you can prepare your organisation for the opportunities it presents.
Driving NVMe into the future

Here are seven of the predictions of what will drive NVMe adoption for 2021
How to test an enterprise SSD part 2: Know which metrics to test and use the right software

Test SSDs to know the real endurance, changes in latency and IOPS in sequential and random read or write scenarios.
Lockdowns, upgrades and industry challenges in cloud and data centers

MSP industry expert Rob May’s insight into how memory/storage upgrades helps companies with remote workers.
Top 4 SSD buying mistakes

Don’t pick the wrong type of SSD for your server. A wrong choice means a higher cost of ownership. Learn to pick the right SSDs.
Influencers Tech insights for 2021

What will 2021 bring in Tech and trends? What do our KingstonCognate members and industry experts predicting for the future?
Kingston SSDs are the best hardware choice for Software Defined Storage solutions

Learn why the future of business depends on SSD-enabled SDS, and how SSD fits into a Software Defined Storage Solutions.
Case Study: Helping rapid on-premises application growth with Kingston Enterprise products and services

Learn how Hosteur supported their rapid growth & SLAs with Kingston Enterprise products & services.
Rip and Replace vs Predictability: Why SSDs with Predictable Latency Matters

Data centres should be using server SSDs. There are many benefits over client drives and costs have come down.
The benefits of NVMe in enterprise

NVMe is now the standard protocol for SSDs to empower data centres and enterprise environments.
Four things data centre managers can learn from the fastest supercomputers

Cloud and on-premise data centre managers can learn a lot from supercomputing.
Is Now the Time for SDS (Software Defined Storage)?

SDS hasn’t lived up to its hype but now that NVMe is more affordable, the commodity hardware is ready to deliver.
The Right Solid-State Drive (SSD) Matters

Choosing the right SSD for your server is important since server SSDs are optimized to perform at a predictable latency level while client (desktop/laptop) SSDs are not. These difference result in better uptime and less lag for critical apps and services.
Why does 5G need Edge Computing in a Micro Data Center?

Industry Expert, Simon Besteman provide insight on why 5G demands edge computing in micro data centers.
The Demand on Data Centers in the Time of Coronavirus

What are the demands of the Data Centers in these unprecedented times? Read this article from Industry Expert, Dr Sally Eaves & she will provide you with an insight on the demands.
Kingston Memory & Enterprise SSDs Give Managed Hosting Provider i3D.net a Competitive Advantage

Kingston delivered compatible memory that met the performance goals of i3D.net's servers, extending the service life of their existing hardware.
The Future of Data Centers - 5G & Edge Computing

Why is Edge Computing Data Centers important for 5G? Download and read Kingston’s eBook on Edge Servers and the 5G rollout.
Quality of Service (QoS)

Data Center 500 Series SSDs (DC500R / DC500M) – Consistency, predictability of Latency (response time) and IOPS (I/Os Per Second) performance.
Aruba case study - Supporting leading web services

Thanks to the service levels, quality, scalability and flexibility of Kingston’s cost- effective solutions, Aruba have seen an increase in the quality of service to their clients.
SSD Over-provisioning (OP)

A percentage of space on an SSD is reserved for OP in firmware. OP can improve performance.
FAQs for SATA and M.2 SSDs

Frequently asked questions around SSD technologies and terms like SATA, M.2, NAND, RAID, NVMe, PCIe, SAS, and keying.
Kingston’s garbage collection methods allows greater SSD performance

Kingston uses LSI^® SandForce^®-based controllers in some SSDs that use proprietary tech for Garbage Collection.
SSDs for Software-Defined Storage Arrays

SDS provides a policy-based control of data tiers, independent of the underlying storage hardware.
SSDs for Online Transaction Processing (OLTP)

Kingston datacenter SSDs provide excellent resiliency to protect sensitive data in OLTP workloads.
SSDs for High-Performance Computing (HPC)

HPC can require massive amounts of data. SSDs consume a fraction of the power of their spinning disk.
ECC and Spare Blocks help to keep Kingston SSD data protected from errors

End-to-End Data Protection protects customer’s data as soon as it is transferred by the host system to the SSD, and then from the SSD to the host computer. All Kingston SSDs incorporate this protection.
SSDs for Virtual Desktop Infrastructure

Storage can be the most challenging component for VDI performance.
Solid-State Drive Testing 101

Testing is a cornerstone of our commitment to deliver the most reliable products on the market. We perform rigorous tests on all of our products during each stage of production. These tests ensure quality control throughout the entire manufacturing process.
What is DDR4 Memory? Higher Performance

Learn how DDR4 delivers faster speeds, reduced power consumption and increased capacity over DDR3.

Improve SQL Server Performance and Lower Costs with Kingston Enterprise Solid-State Drives.

Save Time and Money

Why is this important?

What this whitepaper will detail.

Related Products

Related Articles