SQL server Installation












3















I have received a new server. The server has the following specification.
It has 500 gig 7.2K RPM disk,
SSD
NVME
1.2 TB 10K RPM disk.



All 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?










share|improve this question
















bumped to the homepage by Community 24 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.











  • 1





    How much RAM does the server have and will you rely upon swap files?

    – Sir Swears-a-lot
    Jan 10 '17 at 8:35











  • 128 GB RAM, I am planning to move SWAP file to other drive.

    – G.T.
    Jan 10 '17 at 9:08
















3















I have received a new server. The server has the following specification.
It has 500 gig 7.2K RPM disk,
SSD
NVME
1.2 TB 10K RPM disk.



All 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?










share|improve this question
















bumped to the homepage by Community 24 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.











  • 1





    How much RAM does the server have and will you rely upon swap files?

    – Sir Swears-a-lot
    Jan 10 '17 at 8:35











  • 128 GB RAM, I am planning to move SWAP file to other drive.

    – G.T.
    Jan 10 '17 at 9:08














3












3








3








I have received a new server. The server has the following specification.
It has 500 gig 7.2K RPM disk,
SSD
NVME
1.2 TB 10K RPM disk.



All 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?










share|improve this question
















I have received a new server. The server has the following specification.
It has 500 gig 7.2K RPM disk,
SSD
NVME
1.2 TB 10K RPM disk.



All 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?







sql-server performance ssd






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 10 '17 at 8:37









James Anderson

5,03021839




5,03021839










asked Jan 10 '17 at 7:50









G.T.G.T.

162




162





bumped to the homepage by Community 24 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







bumped to the homepage by Community 24 mins ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.










  • 1





    How much RAM does the server have and will you rely upon swap files?

    – Sir Swears-a-lot
    Jan 10 '17 at 8:35











  • 128 GB RAM, I am planning to move SWAP file to other drive.

    – G.T.
    Jan 10 '17 at 9:08














  • 1





    How much RAM does the server have and will you rely upon swap files?

    – Sir Swears-a-lot
    Jan 10 '17 at 8:35











  • 128 GB RAM, I am planning to move SWAP file to other drive.

    – G.T.
    Jan 10 '17 at 9:08








1




1





How much RAM does the server have and will you rely upon swap files?

– Sir Swears-a-lot
Jan 10 '17 at 8:35





How much RAM does the server have and will you rely upon swap files?

– Sir Swears-a-lot
Jan 10 '17 at 8:35













128 GB RAM, I am planning to move SWAP file to other drive.

– G.T.
Jan 10 '17 at 9:08





128 GB RAM, I am planning to move SWAP file to other drive.

– G.T.
Jan 10 '17 at 9:08










1 Answer
1






active

oldest

votes


















0














In short, put the OSes on slow storage and all the data/log & backup files on fast storage.



I know that my environment is different that yours, but I think similar principles apply. We have a SAN and the storage pools range in different speeds, 7.2k, 10k, 15k.



We install the OSes on the slower drive pools and have all backup files and data/log files stored on the 15k drives. There was a time when we accidentally put everything on the 15k drives and we didn't notice a performance difference. It was brought to our attention by our SAN admin after an audit that the OS was stored on the faster drives.



We monitor SQL Server performance with perfmon and Dell Spotlight. For grins, we went and looked at the historical metrics that mattered, and saw nothing to note.






share|improve this answer























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "182"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f160513%2fsql-server-installation%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    In short, put the OSes on slow storage and all the data/log & backup files on fast storage.



    I know that my environment is different that yours, but I think similar principles apply. We have a SAN and the storage pools range in different speeds, 7.2k, 10k, 15k.



    We install the OSes on the slower drive pools and have all backup files and data/log files stored on the 15k drives. There was a time when we accidentally put everything on the 15k drives and we didn't notice a performance difference. It was brought to our attention by our SAN admin after an audit that the OS was stored on the faster drives.



    We monitor SQL Server performance with perfmon and Dell Spotlight. For grins, we went and looked at the historical metrics that mattered, and saw nothing to note.






    share|improve this answer




























      0














      In short, put the OSes on slow storage and all the data/log & backup files on fast storage.



      I know that my environment is different that yours, but I think similar principles apply. We have a SAN and the storage pools range in different speeds, 7.2k, 10k, 15k.



      We install the OSes on the slower drive pools and have all backup files and data/log files stored on the 15k drives. There was a time when we accidentally put everything on the 15k drives and we didn't notice a performance difference. It was brought to our attention by our SAN admin after an audit that the OS was stored on the faster drives.



      We monitor SQL Server performance with perfmon and Dell Spotlight. For grins, we went and looked at the historical metrics that mattered, and saw nothing to note.






      share|improve this answer


























        0












        0








        0







        In short, put the OSes on slow storage and all the data/log & backup files on fast storage.



        I know that my environment is different that yours, but I think similar principles apply. We have a SAN and the storage pools range in different speeds, 7.2k, 10k, 15k.



        We install the OSes on the slower drive pools and have all backup files and data/log files stored on the 15k drives. There was a time when we accidentally put everything on the 15k drives and we didn't notice a performance difference. It was brought to our attention by our SAN admin after an audit that the OS was stored on the faster drives.



        We monitor SQL Server performance with perfmon and Dell Spotlight. For grins, we went and looked at the historical metrics that mattered, and saw nothing to note.






        share|improve this answer













        In short, put the OSes on slow storage and all the data/log & backup files on fast storage.



        I know that my environment is different that yours, but I think similar principles apply. We have a SAN and the storage pools range in different speeds, 7.2k, 10k, 15k.



        We install the OSes on the slower drive pools and have all backup files and data/log files stored on the 15k drives. There was a time when we accidentally put everything on the 15k drives and we didn't notice a performance difference. It was brought to our attention by our SAN admin after an audit that the OS was stored on the faster drives.



        We monitor SQL Server performance with perfmon and Dell Spotlight. For grins, we went and looked at the historical metrics that mattered, and saw nothing to note.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jan 12 '17 at 16:40









        Sean PerkinsSean Perkins

        70821532




        70821532






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Database Administrators Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f160513%2fsql-server-installation%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Liste der Baudenkmale in Friedland (Mecklenburg)

            Single-Malt-Whisky

            Czorneboh