January 11, 2017 at 1:05 am
I have received a new server. The server has the following specification. It has 500 gig 7.2K RPM disk, SSD, NVME and 1.2 TB 10K RPM disk.
RAM is 128 GB.
I plan to set the page file on 10K drive.
All disks are in RAID 1.
I am planning to install Windows Sever on the 7.2K RPM disks. I want to install SQL Server on the OS drive( i.e. 7.2K RPM drive). I am planning to keep log and data files on SSD and NVME. The 10k RPM drive will be used for backups. NVME drive is faster than SSD. My Windows team recommend that I should install Windows Server on the SSD or 10K drives for performance. But all I care is about SQL Server performance. I don't think that Windows Server will perform badly on the 7.2k drive.
Does anyone see a reason to install Windows Server on any drive other than the 7.2K RPM drives?
Thanks in advance!
January 11, 2017 at 6:54 am
Gaurang-Patel (1/11/2017)
I have received a new server. The server has the following specification. It has 500 gig 7.2K RPM disk, SSD, NVME and 1.2 TB 10K RPM disk.RAM is 128 GB.
I plan to set the page file on 10K drive.
All disks are in RAID 1.
I am planning to install Windows Sever on the 7.2K RPM disks. I want to install SQL Server on the OS drive( i.e. 7.2K RPM drive). I am planning to keep log and data files on SSD and NVME. The 10k RPM drive will be used for backups. NVME drive is faster than SSD. My Windows team recommend that I should install Windows Server on the SSD or 10K drives for performance. But all I care is about SQL Server performance. I don't think that Windows Server will perform badly on the 7.2k drive.
Does anyone see a reason to install Windows Server on any drive other than the 7.2K RPM drives?
Thanks in advance!
Just wondering if there's any particular reason not to install both the OS as well as SQL Server on the SSD ? You didn't mention what the size of the SSD is. I also have to wonder why anyone would have an SSD in the box and then have traditional hard drives that do NOT have any sizable amount of storage (e.g. 4 TB or more). I was under the impression that for a decent server, there's no particular reason to skimp on a decent SSD size, say 500GB or even 1TB, and then if your data storage needs for the database are sizable, add traditional hard drives with large capacities (4,6, or even 8 TB). In the overall scheme of things, storage is cheap. Try comparing the cost of an additional 128 GB of RAM to the cost of the slightly larger SSD and you'll see what I mean.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply