|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
16/06/2008, 20h29
|
#1 |
Messages: n/a
Hébergeur: |
SQL Data Drive Cluster Size = 8192
Hi,
My impression is that SQL Server always read/writes disk data in 8K pages. Thus, when I format a hard drive to be used for SQL Server data files, I use 8192 as the cluster size, assuming this will benefit performance. Is this a justified approach, or are there other considerations I am overlooking? -- Thank you, Daniel Jameson SQL Server DBA Children's Oncology Group www.childrensoncologygroup.org |
|
|
16/06/2008, 20h39
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: SQL Data Drive Cluster Size = 8192
Consider 64K cluster size:
http://msdn.microsoft.com/en-us/libr...6(SQL.80).aspx -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Daniel Jameson" <no_djameson_spam@childrensoncologygroup.org> wrote in message news:OVm8a79zIHA.2208@TK2MSFTNGP04.phx.gbl... > Hi, > > My impression is that SQL Server always read/writes disk data in 8K pages. > Thus, when I format a hard drive to be used for SQL Server data files, I use > 8192 as the cluster size, assuming this will benefit performance. Is this a > justified approach, or are there other considerations I am overlooking? > > -- > Thank you, > > Daniel Jameson > SQL Server DBA > Children's Oncology Group > www.childrensoncologygroup.org > > |
|
|
|
16/06/2008, 22h05
|
#3 |
|
Messages: n/a
Hébergeur: |
RE: SQL Data Drive Cluster Size = 8192
> My impression is that SQL Server always read/writes disk data in 8K pages.
That's a wrong impression. SQL Server doesn't always read/write disk data in 8K pages. The SQL Server disk I/O can be as small as 512 byte (e.g. small transaction log writes), and can be as large as 1MB (e.g. writing to a backup file). Linchi "Daniel Jameson" wrote: > Hi, > > My impression is that SQL Server always read/writes disk data in 8K pages. > Thus, when I format a hard drive to be used for SQL Server data files, I use > 8192 as the cluster size, assuming this will benefit performance. Is this a > justified approach, or are there other considerations I am overlooking? > > -- > Thank you, > > Daniel Jameson > SQL Server DBA > Children's Oncology Group > www.childrensoncologygroup.org > > > |
|
|
|
29/07/2008, 19h00
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: SQL Data Drive Cluster Size = 8192
Tom,
Thank you. Do you know where I can find this info for SQL 2005 and SQL 2008? -- Thank you, Daniel Jameson SQL Server DBA Children's Oncology Group www.childrensoncologygroup.org "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message news:u3ER4C%23zIHA.5400@TK2MSFTNGP02.phx.gbl... > Consider 64K cluster size: > > http://msdn.microsoft.com/en-us/libr...6(SQL.80).aspx > > -- > Tom > > ---------------------------------------------------- > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS > SQL Server MVP > Toronto, ON Canada > https://mvp.support.microsoft.com/profile/Tom.Moreau > > "Daniel Jameson" <no_djameson_spam@childrensoncologygroup.org> wrote in > message news:OVm8a79zIHA.2208@TK2MSFTNGP04.phx.gbl... >> Hi, >> >> My impression is that SQL Server always read/writes disk data in 8K >> pages. >> Thus, when I format a hard drive to be used for SQL Server data files, I > use >> 8192 as the cluster size, assuming this will benefit performance. Is >> this > a >> justified approach, or are there other considerations I am overlooking? >> >> -- >> Thank you, >> >> Daniel Jameson >> SQL Server DBA >> Children's Oncology Group >> www.childrensoncologygroup.org >> >> > > |
|
|
|
29/07/2008, 20h41
|
#5 |
|
Messages: n/a
Hébergeur: |
Re: SQL Data Drive Cluster Size = 8192
AFAIK, there was no change going to the later releases.
-- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "Daniel Jameson" <no_djameson_spam@childrensoncologygroup.org> wrote in message news:uhzujyZ8IHA.1196@TK2MSFTNGP05.phx.gbl... Tom, Thank you. Do you know where I can find this info for SQL 2005 and SQL 2008? -- Thank you, Daniel Jameson SQL Server DBA Children's Oncology Group www.childrensoncologygroup.org "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message news:u3ER4C%23zIHA.5400@TK2MSFTNGP02.phx.gbl... > Consider 64K cluster size: > > http://msdn.microsoft.com/en-us/libr...6(SQL.80).aspx > > -- > Tom > > ---------------------------------------------------- > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS > SQL Server MVP > Toronto, ON Canada > https://mvp.support.microsoft.com/profile/Tom.Moreau > > "Daniel Jameson" <no_djameson_spam@childrensoncologygroup.org> wrote in > message news:OVm8a79zIHA.2208@TK2MSFTNGP04.phx.gbl... >> Hi, >> >> My impression is that SQL Server always read/writes disk data in 8K >> pages. >> Thus, when I format a hard drive to be used for SQL Server data files, I > use >> 8192 as the cluster size, assuming this will benefit performance. Is >> this > a >> justified approach, or are there other considerations I am overlooking? >> >> -- >> Thank you, >> >> Daniel Jameson >> SQL Server DBA >> Children's Oncology Group >> www.childrensoncologygroup.org >> >> > > |
|
|
|
| Outils de la discussion | |
|
|
