New answers tagged

1

Space will not be the only factor in where you place the new space. If you are talking about expanding the capacity of the existing drives you should look at what do the underlying volumes have backing them. I.e how many physical drives are assigned to the drive arrays and what the RAID levels are for those arrays. For HDDs the more drives you have in an ...


0

My Data files are always kept in a separate drive from where the SQL install took place. Therefore, databases like master, model, msdb, and tempdb are always on one drive, while my (user) databases are on (one or more) separate drives. This is not so much for performance reasons as it is for Disaster Recovery/Security. it is much easier to restore a SQL ...


2

The 64K block size comes from the fact that SQL Server does its I/O in units called "Extents", which are each 8 pages - and a page is 8K so the basic unit of I/O is 8 X 8K = 64K. Paul Randal explains here.


3

The method is the one used in the article that you linked in your question: test it. You can capture a representative workload for your application/database and replay that workload on servers that have different cluster sizes. What you will find out is that SQL Sever works best with 64KB clusters, because of the way it reads data from disk (read-ahead). ...



Top 50 recent answers are included