Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

All Flash

By Steve Jones,

I was reading a piece recently that was titled: Switch Your Databases to Flash Storage Now or You're Doing It Wrong. It's a provocative piece, one that has lots of strong comments about the author's style and claims. It's from the CTO of Aerospike, a NoSQL database, and it tries to compare the bottleneck of disks to memory to the network, with the conclusion that your money is better spent on faster SSD drives than tons of RAM.

I don't know if that's true for NoSQL databases, many of which want to run in memory, but I do think there's something here for SQL Server installations. Many of us do have smaller databases, which are much smaller than 1TB. At those sizes, it does make sense these days to look at an SSD solution for your database. At least for tempdb, now that the MTBF of many SSD vendors is large enough to handle the load. Even if you had to replace a tempdb SSD every year, I'd think the performance improvement would make the investment worthwhile.

Technology is changing for data professionals, especially for SQL Server administrators and developers. We are seeing the platform grown and expand, and the changes in what SQL Server allows us to do, and the changes in cost, mean that we should re-evaluate how we approach our systems. Hardware constantly improves, and some of these changes can be a better short term investment than spending a tremendous amount of development and testing time to improve things.

In the long run learning to write better code, and choosing better indexes are great solutions, but they'll work well with faster storage, which might buy you the time to improve your skills.

Steve Jones


The Voice of the DBA Podcasts

No podcast today due to the holiday schedule, but they will resume tomorrow.

Total article views: 130 | Views in the last 30 days: 2
 
Related Articles
FORUM

Better security for SQL Server - how to protect your database

How to protect databases better?

FORUM

Improvising Database to better perfomances

Optimizing Query for a better performance of the database

ARTICLE

Targeted Index Performance Improvements

This article identifies which indexes are used when T-SQL code runs, and proposes ways of improving ...

FORUM

help me in improving my server performance

how can i improve my server performance

ARTICLE

Security Outside the Database

Database security needs to improve, and while SQL Server continues to get better, there is more work...

Tags
editorial    
storage    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones