Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 SQL 2012 backup? SAN?
 Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

SQLServerDBA_Dan
Aged Yak Warrior

USA
752 Posts

Posted - 08/21/2013 :  12:49:54  Show Profile  Reply with Quote
I'm seeing some strange behavior and need to think this through. I'm testing SQL Litespeed vs the native backup and in my testing I ran into issues with the SAN. It's an AMS2100 with 30 x 15K spindles in a RAID 10 (28 active + 2 hot spare). The server is an HP DL380 with 2 dual core procs and 16 GB or RAM and has Qlogic HBAs.

The backup I'm attempting to do is of a 100GB database and the syntax is as follows:

BACKUP DATABASE blahdb
TO DISK = 'NULL'
WITH FORMAT, COMPRESSION
,BLOCKSIZE = 65536
,BUFFERCOUNT = 1000
,MAXTRANSFERSIZE=2097152


If I run this same command on another server with a 270 GB database the backup will finish in just under 3 minutes and have about 600mb/sec *note that the other server is local disk (10x15k raid 10). On this server I am only able to get about 80mb/sec. Even a vanilla backup seems to throttle the disks. When I look at Hitachi's High Command SAN software, the SAN is basically idle. This would indicate that the IO is stuck somewhere before the SAN. SQLIOSIM seems to be getting up to 500mb/sec from the SAN.

My question is: Does anyone know how the SQL Server backup is structured for reading from the data file? Is it possible that something on the SAN or network could throttle the SQL backup and only the backup?


Thanks!




Daniel, MCITP & half an MCM
SQL Server DBA

Edited by - SQLServerDBA_Dan on 08/21/2013 15:06:15

yelouati
Starting Member

10 Posts

Posted - 08/24/2013 :  00:00:01  Show Profile  Reply with Quote
First things first- Check your wait types during the backup. SQL will generate 1MB blocks and store them on disk. These will fill up you controller/drive throughput whichever is slower. Yes, if sqlio shows 500 MB/s, that makes sense and you should be able to achieve that.

Things to look at first, if using LiteSpeed, how many cpus are you using. That may be the reason. Also, look at the various parameters such as compression level....

Check you SQL log and look for messages such as " # of IO took more than 15 secs" or something like that. Then you know you have a controller/SAN issue.

Check Activity Monitor during backup and look at the I/O latency. Should be < 20 ms. <100 ms at worst.

how many data files does you db have? Only one + 1 log?
Go to Top of Page

porcrim
Starting Member

13 Posts

Posted - 04/22/2018 :  03:26:14  Show Profile  Reply with Quote
[b][url=http://watchlove.emichaelkorssale.cn/]swiss replica watches aaa+[/url][/b][b][url=http://watchlove.emichaelkorssale.cn/]swiss replica watches[/url][/b]<strong><a href="http://watchlove.emichaelkorssale.cn/">watches</a></strong><br><strong><a href="http://watchlove.emichaelkorssale.cn/">watches</a></strong><br><strong><a href="http://watchlove.emichaelkorssale.cn/">swiss Mechanical movement replica watches</a></strong><br><br><title>Replica Omega watch PRESTIGE CO-AXIAL 32,7 MM 424.20.33.20.58.001 [fb11] - $227.00 : Professional replica watches stores, watchlove.emichaelkorssale.cn</title><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><meta name="keywords" content="Replica Omega watch PRESTIGE CO-AXIAL 32,7 MM 424.20.33.20.58.001 [fb11] Replica Audemars Piguet Replica Breitling Replica Brequet Replica Rolex Replica TagHuer Replica Omega cheap replica watches online sales" /><meta name="description" content="Professional replica watches stores Replica Omega watch PRESTIGE CO-AXIAL 32,7 MM 424.20.33.20.58.001 [fb11] - Omega Constellation wristwatches are one of the world is most popular watches. Cindy Crawford chose Constellation watches more than 10 years ago and since that time many other celebrities and ordinary watch connoisseurs have followed her example. The new luxurious Constellation collection was released in honor of the 160 year " /><meta http-equiv="imagetoolbar" content="no" /><link rel="canonical" href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-coaxial-327-mm-42420332058001-p-884.html" /><link rel="stylesheet" type="text/css" href="http://watchlove.emichaelkorssale.cn/includes/templates/polo/css/style_imagehover.css" /><link rel="stylesheet" type="text/css" href="http://watchlove.emichaelkorssale.cn/includes/templates/polo/css/stylesheet.css" /><link rel="stylesheet" type="text/css" href="http://watchlove.emichaelkorssale.cn/includes/templates/polo/css/stylesheet_css_buttons.css" /><link rel="stylesheet" type="text/css" media="print" href="http://watchlove.emichaelkorssale.cn/includes/templates/polo/css/print_stylesheet.css" /><select name="currency" onchange="this.form.submit();"> <option value="USD" selected="selected">US Dollar</option> <option value="EUR">Euro</option> <option value="GBP">GB Pound</option> <option value="CAD">Canadian Dollar</option> <option value="AUD">Australian Dollar</option> <option value="JPY">Jappen Yen</option> <option value="NOK">Norske Krone</option> <option value="SEK">Swedish Krone</option> <option value="DKK">Danish Krone</option> <option value="CNY">CNY</option></select><input type="hidden" name="main_page" value="product_info" /><input type="hidden" name="products_id" value="884" /></form></div></div><div class="leftBoxContainer" id="categories" style="width: 220px"><div class="sidebox-header-left main-sidebox-header-left"><h3 class="leftBoxHeading main-sidebox-header-right" id="categoriesHeading">Categories</h3></div><div id="categoriesContent" class="sideBoxContent"><div class="categories-top-list no-dots"><a class="category-top" href="http://watchlove.emichaelkorssale.cn/replica-breitling-c-8.html">Replica Breitling</a></div><div class="categories-top-list "><a class="category-top" href="http://watchlove.emichaelkorssale.cn/replica-omega-c-72.html"><span class="category-subs-parent">Replica Omega</span></a></div><div class="subcategory"><a class="category-products" href="http://watchlove.emichaelkorssale.cn/replica-omega-omega-constellation-watches-c-72_73.html">Omega CONSTELLATION Watches</a></div><div class="subcategory"><a class="category-products" href="http://watchlove.emichaelkorssale.cn/replica-omega-omega-de-ville-watches-c-72_74.html"><span class="category-subs-selected">Omega DE VILLE Watches</span></a></div><div class="subcategory"><a class="category-products" href="http://watchlove.emichaelkorssale.cn/replica-omega-omega-seamaster-watches-c-72_75.html">Omega Seamaster Watches</a></div><div class="subcategory"><a class="category-products" href="http://watchlove.emichaelkorssale.cn/replica-omega-omega-specialities-watches-c-72_76.html">Omega specialities Watches</a></div><div class="subcategory"><a class="category-products" href="http://watchlove.emichaelkorssale.cn/replica-omega-omega-speedmaster-watches-c-72_77.html">Omega Speedmaster Watches</a></div><div class="categories-top-list "><a class="category-top" href="http://watchlove.emichaelkorssale.cn/replica-audemars-piguet-c-1.html">Replica Audemars Piguet</a></div><div class="categories-top-list "><a class="category-top" href="http://watchlove.emichaelkorssale.cn/replica-brequet-c-27.html">Replica Brequet</a></div><div class="categories-top-list "><a class="category-top" href="http://watchlove.emichaelkorssale.cn/replica-rolex-c-32.html">Replica Rolex</a></div><div class="categories-top-list "><a class="category-top" href="http://watchlove.emichaelkorssale.cn/replica-taghuer-c-55.html">Replica TagHuer</a></div></div></div><div class="leftBoxContainer" id="featured" style="width: 220px"><div class="sidebox-header-left "><h3 class="leftBoxHeading " id="featuredHeading">Featured - <a href="http://watchlove.emichaelkorssale.cn/featured_products.html">  [more]</a></h3></div><div class="sideBoxContent centeredContent"><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-coaxial-r%C3%89serve-de-marche-395-mm-42413402101001-p-961.html"><img src="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-R-SERVE-DE.jpg" alt="Replica Omega watch PRESTIGE CO-AXIAL RÉSERVE DE MARCHE 39,5 MM 424.13.40.21.01.001 [fb4f]" title=" Replica Omega watch PRESTIGE CO-AXIAL RÉSERVE DE MARCHE 39,5 MM 424.13.40.21.01.001 [fb4f] " width="130" height="197" /></a><a class="sidebox-products" href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-coaxial-r%C3%89serve-de-marche-395-mm-42413402101001-p-961.html">Replica Omega watch PRESTIGE CO-AXIAL RÉSERVE DE MARCHE 39,5 MM 424.13.40.21.01.001 [fb4f]</a><div>$229.00</div></div><div class="sideBoxContent centeredContent"><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-coaxial-petite-seconde-39-mm-p-960.html"><img src="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-PETITE-16.jpg" alt="Replica Omega watch PRESTIGE CO-AXIAL PETITE SECONDE 39 MM [90ca]" title=" Replica Omega watch PRESTIGE CO-AXIAL PETITE SECONDE 39 MM [90ca] " width="130" height="159" /></a><a class="sidebox-products" href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-coaxial-petite-seconde-39-mm-p-960.html">Replica Omega watch PRESTIGE CO-AXIAL PETITE SECONDE 39 MM [90ca]</a><div>$225.00</div></div><div class="sideBoxContent centeredContent"><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-coaxial-petite-seconde-39-mm-48135001-p-959.html"><img src="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-PETITE-14.jpg" alt="Replica Omega watch PRESTIGE CO-AXIAL PETITE SECONDE 39 MM 4813.50.01 [df1b]" title=" Replica Omega watch PRESTIGE CO-AXIAL PETITE SECONDE 39 MM 4813.50.01 [df1b] " width="130" height="183" /></a><a class="sidebox-products" href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-coaxial-petite-seconde-39-mm-48135001-p-959.html">Replica Omega watch PRESTIGE CO-AXIAL PETITE SECONDE 39 MM 4813.50.01 [df1b]</a><div>$226.00</div></div></div></div></td> <td id="columnCenter" valign="top"> <div id="navBreadCrumb"> <a href="http://watchlove.emichaelkorssale.cn/">Home</a> ::  <a href="http://watchlove.emichaelkorssale.cn/replica-omega-c-72.html">Replica Omega</a> ::  <a href="http://watchlove.emichaelkorssale.cn/replica-omega-omega-de-ville-watches-c-72_74.html">Omega DE VILLE Watches</a> :: Replica Omega watch PRESTIGE CO-AXIAL 32,7 MM 424.20.33.20.58.001 [fb11]</div><div class="centerColumn" id="productGeneral"><form name="cart_quantity" action="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-coaxial-327-mm-42420332058001-p-884.html?action=add_product" method="post" enctype="multipart/form-data"><div style="float:left; width:350px;"><link rel="stylesheet" href="http://watchlove.emichaelkorssale.cn/style/jqzoom.css" type="text/css" media="screen" /><link rel="stylesheet" href="http://watchlove.emichaelkorssale.cn/style/jqzoomimages.css" type="text/css" media="screen" /><style type="text/css">.jqzoom{float:left;position:relative;padding:0px;cursor:pointer;width:301px;height:612px;}</style><div id="productMainImage" class="centeredContent back"><div class="jqzoom" > <a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-coaxial-327-mm-42420332058001-p-884.html" ><img src="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-32-7-MM-424-10.jpg" alt="Replica Omega watch PRESTIGE CO-AXIAL 32,7 MM 424.20.33.20.58.001 [fb11]" jqimg="images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-32-7-MM-424-10.jpg" id="jqzoomimg"></a></div><div style="clear:both;"></div><div id='jqzoomimages' class="smallimages"></div></div></div><div style="width:260px; float:left; margin-left:30px; margin-top:15px;" id='pb-left-column'><div style="font-weight:bold; padding-bottom:10px; font-size:14px;">Replica Omega watch PRESTIGE CO-AXIAL 32,7 MM 424.20.33.20.58.001 [fb11]</div><span id="productPrices" class="productGeneral">$227.00</span> <div id="cartAdd"> Add to Cart: <input type="text" name="cart_quantity" value="1" maxlength="6" size="4" /><br /><br /><input type="hidden" name="products_id" value="884" /><input type="image" src="http://watchlove.emichaelkorssale.cn/includes/templates/polo/buttons/english/button_in_cart.gif" alt="Add to Cart" title=" Add to Cart " /> </div> <br class="clearBoth" /></div><br class="clearBoth" /> <div id="productDescription" class="productGeneral biggerText"><div class="tabTitles"><ul> <li> <h4 tid="t1" class="cur"><strong class=""><span>Description</span></strong></h4> </li></ul></div><p>Omega Constellation wristwatches are one of the world is most popular watches. Cindy Crawford chose Constellation watches more than 10 years ago and since that time many other celebrities and ordinary watch connoisseurs have followed her example. The new luxurious Constellation collection was released in honor of the 160 year anniversary of the legendary series. you can get full series of Omega watches: replica Omega DeVille, Double Eagle, Speedmaster Legend, Constellation My Choice, Speedmaster Broad Arrow, Constellation Double Eagle, Constellation Quadra,  Speedmaster Day, DeVille Prestige, Seamaster Aqua Terra, Speedmaster Reduced, Seamaster Planet Ocean watches.</p><ul id="productdetailslist" class="floatingbox back"> <li>Model: 424.20.33.20.58.001</li> <li>Manufactured by: Omega</li> <li>Series :Omega DE VILLE Watches</li> <li>Short_description : Here Sale Replica luxury and Cheap Price Watches Online Shopping,Replica Omega watch PRESTIGE CO-AXIAL 32,7 MM 424.20.33.20.58.001 is the best price finest watch.If you like it, you can buy it.We will send to you quickly. </li> <p id="availability_statut"><span id="availability_label">Movement:Asia</span></p><P>If you want to buy the swiss luxury movement, please contact us, we can ask our shipping department to check it. The swiss movement cost is $500-$1000.</P></ul></div><br class="clearBoth" /><div id="img_bg" align="center"><p style='text-align:center;'><a target="_blank" href="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-32-7-MM-424-10.jpg"><img itemprop="image" src="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-32-7-MM-424-10.jpg" width=700px alt="/watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-32-7-MM-424-10.jpg"/></a></p><p style='text-align:center;'><a target="_blank" href="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-32-7-MM-424-11.jpg"><img itemprop="image" src="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-32-7-MM-424-11.jpg" width=700px alt="/watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-CO-AXIAL-32-7-MM-424-11.jpg"/></a></p></div><div class="centerBoxWrapper" id="similar_product"><h2 class="centerBoxHeading">Related Products</h2><table><tr><td style="display:block;float:left;width:24.5%;"><div style="width:160px;height:200px;"><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-chronoscope-coaxial-rattrapante-48484031-p-752.html"><img src="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-CHRONOSCOPE-CO-AXIAL-12.jpg" alt="Replica Omega watch CHRONOSCOPE CO-AXIAL RATTRAPANTE 4848.40.31 [9f17]" title=" Replica Omega watch CHRONOSCOPE CO-AXIAL RATTRAPANTE 4848.40.31 [9f17] " width="133" height="200" /></a></div><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-chronoscope-coaxial-rattrapante-48484031-p-752.html">Replica Omega watch CHRONOSCOPE CO-AXIAL RATTRAPANTE 4848.40.31 [9f17]</a></td><td style="display:block;float:left;width:24.5%;"><div style="width:160px;height:200px;"><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-quartz-344-mm-45105200-p-1040.html"><img src="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-PRESTIGE-QUARTZ-34-4-MM-4510-2.jpg" alt="Replica Omega watch PRESTIGE QUARTZ 34,4 MM 4510.52.00 [5660]" title=" Replica Omega watch PRESTIGE QUARTZ 34,4 MM 4510.52.00 [5660] " width="128" height="200" /></a></div><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-quartz-344-mm-45105200-p-1040.html">Replica Omega watch PRESTIGE QUARTZ 34,4 MM 4510.52.00 [5660]</a></td><td style="display:block;float:left;width:24.5%;"><div style="width:160px;height:200px;"><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-ladymatic-coaxial-34-mm-42568342055004-p-876.html"><img src="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-LADYMATIC-CO-AXIAL-34-MM-425-132.jpg" alt="Replica Omega watch LADYMATIC CO-AXIAL 34 MM 425.68.34.20.55.004 [0cf3]" title=" Replica Omega watch LADYMATIC CO-AXIAL 34 MM 425.68.34.20.55.004 [0cf3] " width="105" height="200" /></a></div><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-ladymatic-coaxial-34-mm-42568342055004-p-876.html">Replica Omega watch LADYMATIC CO-AXIAL 34 MM 425.68.34.20.55.004 [0cf3]</a></td><td style="display:block;float:left;width:24.5%;"><div style="width:160px;height:200px;"><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-ladymatic-coaxial-34-mm-42538342055001-p-845.html"><img src="http://watchlove.emichaelkorssale.cn/images//watches_27/Omega-DE-VILLE/Replica-Omega-watch-LADYMATIC-CO-AXIAL-34-MM-425-70.jpg" alt="Replica Omega watch LADYMATIC CO-AXIAL 34 MM 425.38.34.20.55.001 [0dd3]" title=" Replica Omega watch LADYMATIC CO-AXIAL 34 MM 425.38.34.20.55.001 [0dd3] " width="100" height="200" /></a></div><a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-ladymatic-coaxial-34-mm-42538342055001-p-845.html">Replica Omega watch LADYMATIC CO-AXIAL 34 MM 425.38.34.20.55.001 [0dd3]</a></td></table></div> <div id="productReviewLink" class="buttonRow back"><a href="http://watchlove.emichaelkorssale.cn/index.php?main_page=product_reviews_write&products_id=884"><img src="http://watchlove.emichaelkorssale.cn/includes/templates/polo/buttons/english/button_write_review.gif" alt="Write Review" title=" Write Review " width="98" height="19" /></a></div><br class="clearBoth" /></form></div></td> </tr></table></div><style>.articles{width:900px; margin:0 auto;}.articles ul{width:900px; }.articles li{width:450px; float:left;}</style><br style="clear:both;"/><div id="navSuppWrapper"><br class="clearBoth" /> <div id="navSupp" style=" margin-bottom:10px; margin-top:8px; width:100%; text-align:center;"> <ul> <li class="is-here"><a href="http://watchlove.emichaelkorssale.cn/index.php">Home</a></li> <li class="menu-mitop" ><a href="http://watchlove.emichaelkorssale.cn/index.php?main_page=shippinginfo" target="_blank">Shipping</a></li> <li class="menu-mitop" ><a href="http://watchlove.emichaelkorssale.cn/index.php?main_page=Payment_Methods" target="_blank">Wholesale</a></li> <li class="menu-mitop" ><a href="http://watchlove.emichaelkorssale.cn/index.php?main_page=shippinginfo" target="_blank">Order Tracking</a></li> <li class="menu-mitop" ><a href="http://watchlove.emichaelkorssale.cn/index.php?main_page=Coupons" target="_blank">Coupons</a></li> <li class="menu-mitop" ><a href="http://watchlove.emichaelkorssale.cn/index.php?main_page=Payment_Methods" target="_blank">Payment Methods</a></li> <li class="menu-mitop" ><a href="http://watchlove.emichaelkorssale.cn/index.php?main_page=contact_us" target="_blank">Contact Us</a></li> </ul></div><div class ="foot-tg" style=" margin-bottom:10px; margin-top:10px; width:100%; text-align:center;"> <ul> <li class="menu-mitop" ><a href="http://www.watchwish.com/" target="_blank">REPLICA OMEGA</a></li> <li class="menu-mitop" ><a href="http://www.watchwish.com/" target="_blank">REPLICA PATEK PHILIPPE</a></li> <li class="menu-mitop" ><a href="http://www.watchwish.com/" target="_blank">REPLICA ROLEX</a></li> <li class="menu-mitop" ><a href="http://www.watchwish.com/" target="_blank">REPLICA WATCHES</a></li> <li class="menu-mitop" ><a href="http://www.watchwish.com/" target="_blank">FAKE WATCHES</a></li> <li class="menu-mitop" ><a href="http://www.watchwish.com/" target="_blank">REPLICA BREITLING</a></li> </ul></div><DIV align="center"> <a href="http://watchlove.emichaelkorssale.cn/replica-omega-watch-prestige-coaxial-327-mm-42420332058001-p-884.html" ><IMG src="http://watchlove.emichaelkorssale.cn/includes/templates/polo/images/payment.png"></a> </DIV><div align="center" style="color:#000;">Copyright © 2012-2016 All Rights Reserved. </div></div></div><strong><a href="http://watchlove.emichaelkorssale.cn/">swiss replica watches aaa+</a></strong><br><strong><a href="http://watchlove.emichaelkorssale.cn/">swiss replica watches</a></strong><br>
Go to Top of Page
   Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000