Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Orlando, FL
    Provided Answers: 1

    Question Unanswered: SQL Server Hardware Verification Scripts?

    I'm new to SQL and the project I am on requires a 2014 Std. installation. I requested generous specs from the virtualization team & expressed in great detail this was to be a production sql database w/ high intensive disk I/O. My question is before I go pointing our application at the box in UAT, how can I make sure there are no hardware snafu's that surface when we start taking live traffic / heavy load?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    An awful lot depends on what kind of snafus you expect and/or want to avoid. These range from huge problems (insufficient RAM, storage, bandwidth, or CPU), to minor problems (such as failing to page align data files on LUNs), to subtle but critical things (such as improper NUMA or bus configuration of the VM host).

    If you are looking for ideas, read about David Klee at and or get the course from

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts