The options I’m using below will not alter the disks in any way. Google them for lots of info from the Microsoft site – but be careful not to play around with any of the destructive options on productions systems. I thought it would be useful to do a quick blog post showing how to use the diskpart and wmic tools. We’ve been on-site with clients this week and that topic came up again. (Check out our Pluralsight online training course: SQL Server: Improving Storage Subsystem Performance.)Ī while ago I blogged about disk partition alignment, and how the default alignment of 31.5Kb on Windows Server 2003 can lead to enormous I/O performance problems (see Are your disk partition offsets, RAID stripe sizes, and NTFS allocation units set correctly? ).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |