Home    Bloggers    Messages    Polls    Resources    Newsletter Signup   
Tw  |  Fb  |  In  |  Rss
John W. Verity

SQL Server Gains Speed With SSD

John W. Verity
Page 1 / 2   >   >>
JohnVerity
JohnVerity
5/14/2013 11:01:09 PM
User Rank
Blogger
SSD rules
SSD will surely help DBMS go faster, though I can that the speedup will be greater in read-intensive workloads than those that involve much writing.

50%
50%
JohnVerity
JohnVerity
5/13/2013 1:19:30 AM
User Rank
Blogger
Re: SQL Server Gains Speed with SSD
True enough, high-speed HDDs are helpful with DBMS, but I think that a good deal of that capacity will be shifting to SSD now. Segate is even planning to stop making its 15K RPM drives. Lots of change in the market right now.

50%
50%
aditshar
aditshar
5/11/2013 1:49:48 PM
User Rank
Peta
Re: SQL Server Gains Speed with SSD
This sounds simple and logical, As a DB, it is a software product whose primary function is to store and retrieve data as requested by network and SSD being fast, efficient storage can add energy to it.

50%
50%
smasood
smasood
5/11/2013 5:30:17 AM
User Rank
Kilo
Re: SQL Server Gains Speed with SSD
I guess those non-production DB's are not that common in the enterprises. They may only be used for data backups. 

50%
50%
Wisco
Wisco
5/10/2013 12:50:32 PM
User Rank
Peta
Re: SQL Server Gains Speed with SSD
I am happy to hear Chang's remarks about an integrated approach to SSD/HDD that actually discusses backup and restore.

 

More thought leadership should go into cooperative processing between SSD and HDD that covers end to end storage responsibilities--instead of pitting one against the  other in endless raw performance races.

50%
50%
RaviN
RaviN
5/9/2013 5:44:06 PM
User Rank
Mega
Re: SQL Server Gains Speed with SSD
@smasood, In non-production DB servers where high performance is not critical, SSDs can be replaced by HDDs. Most servers have high performance HDD's. which may not match SSDs, but are still very fast.

50%
50%
smasood
smasood
5/9/2013 2:27:12 AM
User Rank
Kilo
Re: SQL Server Gains Speed with SSD
RaviN, HDD are being used still by many organizations. What would make sense would be to shift to SSD's for primary data and HDD for backup purposes. This way the existing HDD setup would be utilized and they will only have to pay for the upgrade to SSD. 

50%
50%
smasood
smasood
5/9/2013 2:22:39 AM
User Rank
Kilo
Re: SQL Server Gains Speed with SSD
John, it is indeed a very good read. I do use SQL Sever from time to time not as a primary function of my job role but for support purposes. The idea of using HDD for backup is not new to me. We have been doing it for a while probably because that is the only medium being used in this part of the world. 

50%
50%
RaviN
RaviN
5/8/2013 7:00:02 PM
User Rank
Mega
Re: SQL Server Gains Speed with SSD
@John, thanks for point out. Well written article from Joe Change and excellent analysis of the use of storage in DBMS. HDD's can be used as a cheaper alternative  for areas where performance is not of paramount importance.

50%
50%
JohnVerity
JohnVerity
5/7/2013 12:17:43 PM
User Rank
Blogger
Re: SQL Server Gains Speed with SSD
Yeah, I think if one is a user of SQL Server, this blog I found is a good one to read. It is super technical and therefore, for the right person, a very helpful one. I wish I understood more of it myself, but I am no expert on SQL Server, not by a long shot.

50%
50%
Page 1 / 2   >   >>
More Blogs from John W. Verity
A Twitter engineer has explained much of the company's approach to performance and triggered a fascinating debate about infrastructure as well.
Cloud-based computing offers major advantages that are increasingly difficult to ignore.
The chip colossus is slated soon to unveil a new design for server racks to be used in large-scale datacenters.
Companies running their own compute clouds are opting for the platform-as-a-service model as a way to make IT as a whole more agile and effective.
Serious questions are being raised about how, and if, society can cope as automation eliminates many well-paying jobs, as seems inevitable.
flash poll
follow us on twitter
like us on facebook
Datacenter Acceleration
About Us     Contact Us     Help     Register     Twitter     Facebook     RSS