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

DC600M Series 2.5” SATA Enterprise SSD
Optimised for mixed-use applications

2.5” form factor

AES 256-bit encryption with DC600ME

480GB, 960GB, 1.92TB, 3.84TB, 7.68TB

Up to 560MB/s read, 530MB/s write
Learn more Buy
DC2000B PCIe 4.0 NVMe M.2 SSD
Optimised server drive

PCIe 4.0 NVMe M.2 2280 SSD

240GB, 480GB, 960GB

Up to 7,000 MB/s read, 1,300 MB/s write
Learn more Buy

Blog Home

The Difference Between Enterprise & Client SSD

The differences between SSD classes lies in two components; the processor and the NAND memory.
The evolution of memory technology – eBook

Explore DRAM technology’s evolution and gain insights into future trends in our eBook.
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.
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.
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.
What are the benefits of next-gen 16Gbit DDR4 DRAM?

Planning a new system? Watch this video to learn about the benefits 16Gbit DRAM next-gen technology.
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.
Case Study: Accelerating virtual machines with Kingston DC500M SSDs

Find out how Hardwareluxx were able to manage the growth of their web traffic using Kingston's DC500M SSD.
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.
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.
A Closer Look At SSD Power Loss Protection

Firmware/hardware PFAIL protection is an highly effective method for preventing data loss in enterprise SSD.
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