<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html lang="en-w1"> <head> <META http-equiv="Content-Type" content="text/html"> <title>HP Transaction Processing Storage Planning Calculator for Microsoft SQL Server</title> <meta http-equiv="Content-type" content="text/html; charset=unicode"> <meta http-equiv="Content-Style-Type" content="text/css"> <meta name="generator" content="SNFplus 596; XSLT 233"> <meta name="hp_design_version" content="hpweb.1.2a"> <meta name="target_country" content="w1"> <meta name="web_section_id" content="R2805"> <meta name="page_content" content="Solutions.Messaging"> <meta name="segment" content="Large.Partners"> <meta name="user_type" content="Business_manager.IT_professional"> <!-- <meta name="product_service_name" content="ENTER_PRODUCT_SPECIFICATION"> --> <meta name="lifecycle" content="Catalog"> <meta name="description" content="This document provide guidelines for the use of Recovery Server Option (RSO) in Microsoft SQL Server environment. RSO enables the use of low-cost failover in an active-passive configuration. It is an entry-level solution with fully-automated server recovery in the event of primary server failure."> <meta name="keywords" content=""> <meta name="ReversableHTMLId" content=""> <meta name="PublishURI" content=""> <meta name="FilePath" content=""> <meta name="templateVersion" content="1.1"> <meta name="updated" content="7/14/2003"> <meta name="Previous_Secure_Directory" content=""> <meta name="Secure_Directory" content=""> <meta name="Rating" content="General"> <meta name="new" content="9/23/2002 4:25:00 PM"> <meta name="format" content="html"> <meta name="Expires" content="7/31/2004"> <meta name="Generator" content="Aquarius 6.13"><SCRIPT language="JavaScript" SRC="../include/clhook.js"></SCRIPT> <!-- Enter theme color in the variable below. Please select from the following colors: --> <!-- For use with white text: #990000,#CC0066,#336666,#003366,#000000,#666666,#336633,#EB5F01,#0066FF,#4FAF00 --> <!-- For use with black text: #FFCC00 --> <script type="text/javascript" language="JavaScript"><!-- var theme = '#336666'; //--></script> <script language="JavaScript" type="text/javascript"> var idx = -1; var category_name = new Array(3); var segment_name = new Array(3); var domain_name = ""; var solution_name = ""; var category_name_str = ""; var segment_name_str = ""; var s_pageName=""; var s_prop1 = ""; var s_prop2 = ""; var s_prop3 = ""; var s_prop4 = ""; var s_prop5 = ""; var s_prop6 = ""; var s_prop7 = ""; var s_prop8 =""; var s_prop9 =""; var s_prop10 =""; var s_prop13 = ""; var s_prop18 = ""; var s_prop19 = ""; var s_prop20 = ""; var s_prop21 = ""; var s_prop22 =""; var s_account = ""; var partner_name = ""; category_name[0] = ""; category_name[1] = ""; segment_name[0] = ""; segment_name[1] = ""; var country_code = "w1"; var language_code = "en"; s_prop7 = country_code; s_prop8 = language_code; s_prop9 ="Large.Partners"; s_account = "hphqglobal,hphqenterprisesolutions"; if (category_name[1].indexOf("Partners") != -1) partner_name = segment_name[idx]; catarray = category_name[0].split("|"); segarray = segment_name[0].split("|"); domarray = domain_name.split("|"); if (catarray[0].toLowerCase() == "section_name") { section_header = catarray[1]; if (segarray.length > 1) section_name = segarray[0]; else section_name = segment_name[0]; s_pageName = section_header + "|" + country_code + "|en|" + partner_name + "|HP Transaction Processing Storage Planning Calculator for Microsoft SQL Server"; s_prop18 = "ENT: AA"; s_prop19 = "ENT: AA|" + section_name; } else { if (catarray.length > 1) category_name_str = catarray[0]; if (segarray.length > 1) segment_name_str = segarray[0]; if (domarray.length > 1) domain_name = domarray[0]; s_pageName = "AA|" + segment_name_str + "|" + country_code + "|en|" + partner_name + "|HP Transaction Processing Storage Planning Calculator for Microsoft SQL Server"; s_prop18 = "ENT: AA"; s_prop19 = "ENT: AA|"+ category_name_str + "|"+ segment_name_str + "|"+ domain_name + "|" + solution_name; } s_prop6 = ""; s_prop10 = s_prop7 + "|" + s_prop8 + "|" + s_prop9; s_prop13 = s_account; </script><script language="JavaScript" type="text/javascript" src="/render/include/printable_version.js"> </script> <script type="text/javascript" language="JavaScript" src="http://welcome.hp-ww.com/country/us/en/js/hpweb_utilities.js"></script> <link rel="shortcut icon" href="http://welcome.hp-ww.com/img/favicon.ico"> </head> <body class="colorFFFFFFbg" text="#000000" link="#003366" alink="#003366" vlink="#660066" marginheight="0" marginwidth="0" leftmargin="0" topmargin="0"> <!--stopindex--> <!-- Begin Top Navigation Area --> <table border="0" cellpadding="0" cellspacing="0" width="740"> <tr class="decoration"> <td width="10"><a href="#jumptocontent"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="1" alt="Jump to content" border="0"></a><noscript><a href="http://welcome.hp.com/country/us/en/noscript.htm">summary of site-wide JavaScript functionality</a> </noscript></td> <td nowrap="" align="left" width="40%" class="smallbold" id="WelcomeLogin"><!-- Welcome, 123456789012345678901234567890... --></td> <td><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="24" alt="" border="0"></td> <td nowrap="" align="right" width="35%" class="color003366"><!-- &raquo;&nbsp;<a href="Insert_Link_Here" class="small">Sign-out</a>&nbsp;<span class="color666666">|</span>&nbsp;&raquo;&nbsp;<a href="Insert_Link_Here" class="small">Edit your profile</a> --></td> <td align="right" class="countryInd">WorldWide-English</td> <td><img src="http://welcome.hp-ww.com/img/s.gif" width="20" height="1" alt=""></td> </tr> </table> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td align="left" valign="top" bgcolor="#666666"> <table border="0" cellpadding="0" cellspacing="0" width="720"> <tr class="decoration"> <td><a href="http://welcome.hp.com/country/us/en/welcome.html"><img src="http://welcome.hp-ww.com/country/us/en/img/top/hpweb_1-2_topnav_home.gif" width="100" height="24" border="0" alt="HP.com Home"></a></td> <td class="colorE7E7E7bg"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="1" alt=""></td> <td><a href="http://welcome.hp.com/country/us/en/prodserv.html"><img src="http://welcome.hp-ww.com/country/us/en/img/top/hpweb_1-2_topnav_prdsrv.gif" width="166" height="24" border="0" alt="Products and Services"></a></td> <td class="colorE7E7E7bg"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="1" alt=""></td> <td><a href="http://welcome.hp.com/country/us/en/support.html"><img src="http://welcome.hp-ww.com/country/us/en/img/top/hpweb_1-2_topnav_supprt.gif" width="163" height="24" border="0" alt="Support and Drivers"></a></td> <td class="colorE7E7E7bg"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="1" alt=""></td> <td><a href="http://welcome.hp.com/country/us/en/solutions.html"><img src="http://welcome.hp-ww.com/country/us/en/img/top/hpweb_1-2_topnav_slutns.gif" width="143" height="24" border="0" alt="Solutions"></a></td> <td class="colorE7E7E7bg"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="1" alt=""></td> <td><a href="http://welcome.hp.com/country/us/en/howtobuy.html"><img src="http://welcome.hp-ww.com/country/us/en/img/top/hpweb_1-2_topnav_buy.gif" width="143" height="24" border="0" alt="How to Buy"></a></td> <td class="colorE7E7E7bg"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="1" alt=""></td> </tr> </table> </td> </tr> </table> <!-- End Top Navigation Area --> <!-- Begin Search Area --> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td align="left" valign="top" bgcolor="#E7E7E7"> <table border="0" cellpadding="0" cellspacing="0"> <tr> <td width="20" valign="top"><img src="http://welcome.hp-ww.com/img/s.gif" width="20" height="48" alt="" class="decoration"></td> <td width="120" align="left" valign="middle" class="color003366bld">&raquo;&nbsp;<!-- Activate Contact Link Here --><a href="http://welcome.hp.com/country/us/en/contact.htm" class="smallbld">Contact HP</a><!-- End Activate Contact Link Here --></td><td width="175" style="font-size: 90%; font-weight: normal;"></td> <td width="470" align="right"><form method="get" action="http://www.hp.com/search/"> <!-- COPY AND PASTE CONTEXTUAL SEARCH CODE FROM SEARCH BUILDER HERE to implement your search, see build guide section 3.6: http://www.hp.com/hpweb/buildguide/search.htm --> <input type="hidden" name="charset" value=""><input type="hidden" name="cc" value="w1"><input type="hidden" name="lang" value="en"><input type="hidden" name="hps" value="ActiveAnswers"><input type="hidden" name="hpn" value="Return to ActiveAnswers Site"><input type="hidden" name="qp" value="+url:h71019.www7.hp.com/ActiveAnswers"><input type="hidden" name="hpr" value="+url:h71019.www7.hp.com/ActiveAnswers"><input type="hidden" name="hpa" value="http://h71019.www7.hp.com/ActiveAnswers/Cache/71112-0-0-225-121.aspx"><input type="hidden" name="hpo" value="hphqglobal,hphqenterprisesolutions"><table border="0" cellpadding="0" cellspacing="0" align="right"> <tr class="decoration"> <td colspan="4"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="2" alt="" border="0"></td> </tr> <tr><td></td><td></td><td align="left" valign="top"></td><td></td></tr> <tr> <td align="left" class="bold"><label for="textboxIDABCOQ0">Search:</label></td> <td valign="top"><img src="http://welcome.hp-ww.com/img/s.gif" width="4" height="1" alt="" class="decoration"></td> <td nowrap="" align="left" valign="top"><input type="text" name="qt" size="30" maxlength="100" id="textboxIDABCOQ0" alt="Enter search criteria here" value=""><img src="http://welcome.hp-ww.com/img/s.gif" width="4" height="1" alt=""><a id="country" onmouseover="status='search using the specified criteria';return true;" onmouseout="status='';return true;" onFocus="status='search using the specified criteria';return true;" onBlur="status='';return true;"><input type="Image" name="submit" onClick="" src="http://welcome.hp-ww.com/img/hpweb_1-2_arrw_sbmt.gif" border="0" alt="Begin your search"></a><!-- <img src="http://welcome.hp-ww.com/img/s.gif" width="13" height="1" alt="" border="0"><a href="ENTER HERE" class="udrlinesmall">More options</a> --></td> <td align="left"><img src="http://welcome.hp-ww.com/img/s.gif" width="20" height="1" alt="" class="decoration"></td> </tr> <tr> <td></td> <td align="left" colspan="3" class="small"><div><!--BEGIN SEARCH HPL TAG --><input type="radio" name="hpl" value="1" id="sectionRadio" class="srchradbtn" checked=""><label for="sectionRadio"><span class="bold">ActiveAnswers</span></label><input type="radio" name="hpl" value="0" id="countryRadio" class="srchradbtn"><label for="countryRadio">All of HP US</label><!-- END SEARCH HPL TAG --></div></td> </tr> </table></form> </td> </tr> </table> </td> </tr> </table> <!-- End Search Area --> <!--startindex--> <!-- Begin Page Title Area --> <table border="0" cellpadding="0" cellspacing="0" width="740"> <tr> <td width="170" align="center" valign="middle"><a href="http://welcome.hp.com/country/us/en/welcome.html"><img src="http://welcome.hp-ww.com/img/hpweb_1-2_topnav_hp_logo.gif" width="64" height="55" alt="HP.com home" border="0"></a><br></td> <td width="10"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="93" alt=""></td> <td width="560" align="left" valign="top"><a href="/ActiveAnswers/cache/70729-0-0-0-121.html" class="udrlinesmall">Microsoft SQL Server</a><br><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="6" alt=""><h1>HP Transaction Processing Storage Planning Calculator for Microsoft SQL Server</h1> </td> <!--stopindex--> </tr> </table> <!-- End Page Title Area --> <!-- Begin Left Navigation and Content Area. To increase width of content area, modify width of table below. --> <table border="0" cellpadding="0" cellspacing="0" width="740"> <tr> <!-- Start Left Navigation --> <td width="170" align="left" valign="top" bgcolor="#F0F0F0"> <table border="0" cellpadding="0" cellspacing="0" width="170" background="http://welcome.hp-ww.com/img/s.gif"> <tr class="colorDCDCDCbg"> <td align="left" width="10"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="1" alt=""></td> <td align="left" valign="top" width="10" class="color003366bld">&raquo;&nbsp;</td> <td align="left" valign="middle"><h2><a href="/ActiveAnswers/cache/71108-0-0-0-121.html" class="bold">ActiveAnswers</a></h2></td> </tr> </table> <table border="0" cellpadding="0" cellspacing="0" width="170" background="http://welcome.hp-ww.com/img/s.gif"> <tr><td align="left" valign="top" width="10"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="1" alt=""></td> <td align="left" valign="top" width="150"> <table border="0" cellpadding="0" cellspacing="0" width="150" background="http://welcome.hp-ww.com/img/s.gif"> <tr class="decoration"> <td align="left" width="10"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="10" alt=""></td> <td align="left" width="10"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="10" alt=""></td> <td align="left" width="10"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="10" alt=""></td> <td align="left" width="120"><img src="http://welcome.hp-ww.com/img/s.gif" width="120" height="10" alt=""></td> </tr> <tr> <td align="left" width="10"></td> <td align="left" valign="top" width="10" class="color003366">&raquo;</td> <td align="left" width="130" colspan="2"><a href="/ActiveAnswers/cache/71108-0-0-0-121.html">Home </a></td> </tr> <tr> <td align="left" width="10"></td> <td align="left" valign="top" width="10" class="color003366">&raquo;</td> <td align="left" width="130" colspan="2"><a href="/ActiveAnswers/cache/75809-0-0-0-121.aspx">Solutions</a></td> </tr> <tr> <td align="left" width="10"></td> <td align="left" valign="top" width="10" class="color003366">&raquo;</td> <td align="left" width="130" colspan="2"><a href="/ActiveAnswers/cache/71114-0-0-0-121.html">Tools </a></td> </tr> <tr class="decoration"> <td align="left" width="150" colspan="4"><img src="http://welcome.hp-ww.com/img/s.gif" width="150" height="10" alt=""></td> </tr> <tr class="decoration"> <td align="left" width="10"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="1" alt=""></td> <td align="left" valign="top" width="140" class="colorCCCCCCbg" colspan="3"><img src="http://welcome.hp-ww.com/img/s.gif" width="140" height="1" alt=""></td> </tr> <tr class="decoration"> <td align="left" width="150" colspan="4"><img src="http://welcome.hp-ww.com/img/s.gif" width="150" height="10" alt=""></td> </tr> <tr> <td align="left" width="150" colspan="4"><h3>Member services</h3></td> </tr> <tr> <td align="left" width="10"></td> <td align="left" valign="top" width="10" class="color003366">&raquo;</td> <td align="left" width="130" colspan="2"><a href="https://h41183.www4.hp.com/?Country=WW&amp;Language=GB&amp;ms=9500">Subscribe eNews</a></td> </tr> <tr class="decoration"> <td align="left" width="150" colspan="4"><img src="http://welcome.hp-ww.com/img/s.gif" width="150" height="10" alt=""></td> </tr> </table> </td> <td align="left" valign="top" width="10"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="1" alt=""></td> </tr> <tr class="decoration"><td colspan="3" class="colorCCCCCCbg"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="2" alt="" border="0"></td></tr> </table> </td> <!-- End Left Navigation --> <!-- Begin Gutter Cell 10px Wide --> <td valign="top" width="10"><a name="jumptocontent"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="1" alt="Content starts here"></a></td> <!-- End Gutter Cell 10px Wide --> <!--startindex--> <!-- Start Content Area. To increase width of content area, modify width of table cell below. --> <td width="560" align="left" valign="top"> <table border="0" psctab="" cellspacing="0" cellpadding="0" width="560"> <tr class="decoration"><td class="colorCCCCCCbg"><img height="1" alt="" src="http://welcome.hp-ww.com/img/s.gif" width="1"></td></tr> <tr class="decoration"><td><img height="10" alt="" src="http://welcome.hp-ww.com/img/s.gif" width="1"></td></tr></table> <table width="560" psctab="" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" width="560" valign="top"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="10" alt=""><br><table border="0" cellspacing="0" cellpadding="0"><tr> <td width="560" valign="top" align="left"><p>The HP Transaction Processing Storage Planning Calculator for Microsoft SQL Server addresses one of the most critical areas of Microsoft SQL Server server sizing: I/O and storage capacity planning for the storage subsystem.&#160; The tool will help you determine the appropriate storage solution for your Microsoft SQL Server deployment.&#160; Using algorithms provided by HP&#8217;s SQL Server performance engineers, combined with your inputs and HP recommended values, this tool will calculate the number spindles, cabinets, and controllers required for multiple RAID levels, to meet your capacity and performance needs.</p> <p>Version 1.5 of this tool has been updated to include: </p> <ul style="padding:0; margin-top:0px; margin-bottom:0px; margin-right:0px; margin-left:26px;"><li>HP StorageWorks EVA 4000\6000\8000 </li> <li>HP Smart Array P800 and additional SAS drive capacities </li> <li>HP All-in-One Storage Systems 600 and 1200 </li> <li>This tool takes advantage of the power of the Microsoft .NET framework </li> <li>Automatic Deployment feature is supported by XML and automatically checks for new components to download such as new hardware components or new versions of the tool </li> </ul> </td> </tr> </table><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="10" alt=""><br><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="10" alt=""><br><table border="0" cellpadding="0" cellspacing="0" width="560"> <tr class="theme"> <td align="left" width="10"><img src="http://welcome.hp-ww.com/img/s.gif" width="10" height="1" alt=""></td> <td align="left" valign="top" width="550"><h2 class="themeheader">Downloads</h2></td></tr> </table><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="10" alt=""><br><table cellpadding="0" cellspacing="0" border="0" width="560"> <tr> <td align="left" width="540" valign="top" bgColor="#ffffff"><span class="bold">Transaction Processing Storage Planning Calculator for Microsoft SQL Server</span><br><br></td> <td align="left" width="540" valign="top" bgColor="#ffffff">Updated: 2007-07-10<br>Reviewed: 2007-07-10<br></td> </tr> </table><img src="http://h71019.www7.hp.com/aa_images/zip-sm.gif" width="20" height="18" alt="Transaction Processing Storage Planning Calculator for Microsoft SQL Server" border="0"><br><table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="0" align="left"><img src="http://welcome.hp-ww.com/img/s.gif" width="0" height="1" alt=""></td> <td valign="top" align="left" class="color003366" width="10"><span class="color003366">&raquo;&nbsp;</span></td> <td valign="top" align="left"><a href="http://h71019.www7.hp.com/ActiveAnswers/downloads/HP_SPC_for_SQL_Server.zip">(1,378 KB)</a><br></td> </tr> </table> <table cellpadding="0" cellspacing="0" border="0" width="540"> <tr><td align="right" valign="top" width="540"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td valign="top" width="0" align="left"><img src="http://welcome.hp-ww.com/img/s.gif" width="0" height="1" alt=""></td> <td valign="top" align="left" class="color003366" width="10"><span class="color003366">&raquo;&nbsp;</span></td> <td valign="top" align="left"><a href="/ActiveAnswers/cache/70128-0-0-0-121.html">Download help</a><br></td> </tr> </table> </td></tr></table> </td> </tr> </table> </td> <!-- End Content Area --> <!--stopindex--> </tr> </table> <!-- End Left Navigation and Content Area --> <!-- Begin Printable Version --> <table border="0" cellpadding="0" cellspacing="0" width="740"> <tr> <td align="center" valign="bottom" width="170" bgcolor="#F0F0F0"><img src="" width="" height="" alt="" border="0"><a href="" class="udrlinebold"></a></td> <td width="10"></td> <td width="560"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="60" alt="" border="0"></td> </tr> <tr> <td align="center" valign="bottom" width="170" bgcolor="#F0F0F0"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="1" alt="" border="0"></td> <td width="10"></td> <td width="560"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="20" alt="" border="0"></td> </tr> </table> <!-- End Printable Version --> <!-- Begin Footer Area --> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr class="decoration"> <td class="color666666bg"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="4" alt="" border="0"></td> </tr> <tr> <td align="left" valign="top"> <table border="0" cellpadding="0" cellspacing="0" width="740"> <tr class="decoration"> <td colspan="4"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="4" alt="" border="0"></td> </tr> <tr> <td width="33%" align="center"><a href="http://welcome.hp.com/country/us/en/privacy.html" class="udrlinesmall">Privacy statement</a></td> <td width="33%" align="center"><a href="http://welcome.hp.com/country/us/en/termsofuse.html" class="udrlinesmall">Using this site means you accept its terms</a></td> <td width="33%" align="center"><!-- Activate Feedback Link Here --><a href="http://www.hp.com/ghp/assist/web_feedback.htm" class="udrlinesmall">Feedback to webmaster</a><!-- End Activate Feedback Link Here --></td> </tr> <tr class="decoration"> <td colspan="4"><img src="http://welcome.hp-ww.com/img/s.gif" width="1" height="4" alt=""></td> </tr> <tr> <td align="center" colspan="4" class="small">&#169; 2008 Hewlett-Packard Development Company, L.P.</td> </tr> </table> </td> </tr> </table> <!-- End Footer Area --> <!-- Begin METRICS Javascript --> <script type="text/javascript" language="JavaScript" src="/ActiveAnswers/include/metricsActiveAnswers.js"></script> <!-- End METRICS Javascript --> </body> </html>