Can SQL Server performance be improved by defragmenting?

jlister

Is it possible to speed up the performance of our SQL queries by defragging our database server's RAID?

Topic: Storage
Answer this Question

Answers

1 total
JOiseau
Vote Up (24)

Possibly, but it's more likely that performance is negatively affected by the database structure, the amount of data that has to be searched, and the server's cpu load (which is in turn affected by the number of users, the amount of RAM, and the number and type of processors in the server).

Ask a question

Join Now or Sign In to ask a question.
EMC's TwinStrata acquisition announced on Tuesday is just part of a bigger move to keep its venerable VMax storage platform up to date with large enterprises as they enter the cloud era.
Storage vendor EMC has scooped up cloud storage management company TwinStrata, the companies announced Tuesday.
For purely personal reasons I've chosen to abandon Dropbox. Thankfully, Dropbox, though popular, isn't the only game in town.
Users of Dropbox for Business will now be able to share folders with colleagues without necessarily giving them rights to edit their content.
Samsung claims to have raised the reliability and capacity of solid state drives with the new 1TB models in its 850 Pro line, made using the company's latest memory technology.
Both Microsoft and Google have recently beefed up their storage options. Here's how to decide which on is right for you.
Google today answered Microsoft's boost of cloud storage space by announcing it would give Google Apps for Business customers an unlimited amount of storage for an additional $5 a month per user.
Under pressure from Microsoft's Office 365, Google has launched a premium edition of Apps with unlimited cloud storage and extra IT controls, and has also improved the Docs office productivity suite.
But will the free 1TB boost subscriptions?
Facebook engineer Chris Mason is unequivocal about the primacy of Linux in Facebook's storage infrastructure.
Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

randomness