SQL setup

Posted on 2012-08-19
Last Modified: 2012-08-21
Hi All,

Is it possible to advise have best to setup a SQL environment giving thought to:

How do you calculate the processing power requirements, IOP's for storage, physical memory requirements. Surely there must be some kind of formula to work these things out rather than 'guessing and seeing what happens'?
Question by:colgil
    LVL 12

    Assisted Solution

    Dell has a web based  sql server sizing advisor at

    HP offers a number of similar tools at

    Although these identify vendor solutions, they offer a good starting point for either reverse engineering your own solution or simply going with a similarly sized setup from the vendor of your choice.
    LVL 21

    Assisted Solution

    If you'll be setting up SQL on a virtual server, here is a good sizing tool
    LVL 4

    Assisted Solution

    Hi colgil

    try this

    Good luck & hopefully can help u ^^
    LVL 10

    Accepted Solution

    Unless you are replacing one environment with another, there's always going to be a bit of guesswork involved. With a current environment, you can use tools to baseline the performance of the server as it interacts with users and the application(s). If this is net-new, you can get performance requirements from the vendor of the application, but these will be ballpark estimates, even if the application is very well categorized: the way your organization will use the app will likely vary from "typical" in one or more crucial ways that make you deviate from norms--in either direction--that are used to suggest the environment.
    But that's where you need to start: vendor recommendations.
    If the app vendor tells you to go with 8 CPUs, 250GB RAM, 15000 IOPs and 5TB storage, you need to find out if that's after 4 years of transactions flowing through the system, or after 4 months.
    And if you're doing this all yourself--database design, application build--you've got to load-test your setup. Many times, I've been told to increase the capability of the SQL server in order to get a given process to run faster, only to discover that the bottleneck query was written with cursors; rewrite the code to be set-based, and the need for "more power" went away.
    So yes, the ultimate answer is still "it depends" and a lot of testing.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now