.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Question for DBAs: Trying to achieve parallel disk IO with a single disk array controller

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server


I am thinking to consider this disk array controller: (http://bit.ly/a0egr2) for my SQL Server 2008 database server (http://bit.ly/dcphU7). The server is going to have 12 physical hard disks and my plan is to configure the controller to have four drives on my windows 2008 server:

·        C: (RAID 1, two HDDs)


View Complete Post

More Related Resource Links

Avg. Disk Sec/Read question


Hi guys,

My disk consits 16 disks for RAID10, the Avg. Disk Sec/Read is 19 ms, is it ok?

Here is MS recommendation:

Less than 10 ms - very good
Between 10 - 20 ms - okay
Between 20 - 50 ms - slow, needs attention
Greater than 50 ms – Serious I/O bottleneck

Not sure if I can use the value directly to evaluate the performance of RAID disk without calculating the number of disks and RAID mode.

Less than 20 ms is ok for any kind of RAID consists any amount disks?

Any suggestion would be appreciated.


?dba????(???),???? stswordman#hotmail.com

Restore database from single disk to multiple disks?


We have expanded our drive layout on a particular server from 1 huge disk (10TB) to 8 (1.2TB) disks. 


My question is how do you restore a database and have the data spread across the 8 disks? We have about 10 DB's to restore so it could be quite a challenge.




disk alignment question!


Brand new sql cluster installation, setting up the disks.

Windows 2008 R2

SQL 2008 Enterprise

Dell 610 x2 (active/passive cluster)

Dell Powervault SAN - 8x450GB 15k SAS - RAID5

OLTP system with pretty even read/write ops

How do these number below look?

128KB stripe size

64KB cluster size

1024KB offset

Are my alignments correct? Should my stripe size be bigger since 8 disks? I am new to this and still don't quite understand the formulas.


file upload in chunks or not buffering in memory before writing to disk?


What are the options for handling file uploads to reduce the memory footprint?  Is there a way to upload in chunks?  Is there a way to stream upload directly to disk instead of loading entire file in server memory?


Windows With C++: The Virtual Disk API In Windows 7


This month we look inside the Windows 7 beta to examine the Virtual Disk API and the Microsoft Virtual Hard Disk (VHD) format.

Kenny Kerr

MSDN Magazine April 2009

System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create th

I received the following error...*****System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'C:\' to create the database. The database requires 2739929088 additional free bytes, while only 801185792 bytes are available. (Microsoft.SqlServer.Smo)*****I have looked at the solution recommended on this forum http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79848 but I am still baffled as to why it says that I don't have enough disk space?  I ran the RESTORE FILELISTONLY command and it told me that the "size" was 1.4 GB and I've got 60GB left. I am starting to resolve that my .BAK is corrupt.  Are there any other reasons as to why I am unable to restore my backup?Thanks for any help in advance!

MDW Disk Usage for Database Report Error - A data source has not been supplied for the data source D

Hello, On the MDW Disk Usage Collection Set report, I get the following error when I click on a database hyperlink. A data source has not been supplied for the data source DS_TraceEvents SQL profiler shows the following SQL statements are executed (I've replaced the database name with databaseX) 1. exec sp_executesql N'SELECT dtb.name AS [Name] FROM master.sys.databases AS dtb WHERE (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'databaseX' this returns zero rows as databaseX does not exist on my MDW central server, but is a database on a target server (i.e. one that is being monitored and uploaded into the MDW central server). 2. USE [datatbaseX] this produces the following error: Msg 911, Level 16, State 1, Line 1 Database 'databaseX' does not exist. Make sure that the name is entered correctly. why is the report looking for the database on my server? thanks Jag Environment: MDW (Management Data Warehouse) on SQL 2008 R2  

Confused about Disk Alignment/ Partition Offset

I am all confused by disk alignment, partiton offset.Why do we need to calcualte offset which most of the articles talk about, This is from White Paper  Disk Partition Alignment Best Practices for SQL Server where its stressed that Partition_Offset ÷ Stripe_Unit_Size-- should be an integer 'The performance question here is usually not one of correlation per the formula, but whether the cluster size is the NTFS default of 4,096 bytes or has been explicitly defined at 64 KB, which is a best practice for SQL Server.' Also how do we calculate Stripe Unit Size for SAN. Thanks all for your replies !!  

How large do you make your MSDTC Physical Disk Resource?

MSDTC requires a physical disk resource for the 4mb log it uses.  How large do you typically make the disk used as the MSDTC Physical Disk resource?  I don't know if there is a need to go beyond 4MB.  I'm guessing 100MB is a safe number.  Do you agree? Thanks,    Dave

Disk Stripe Width

Since SQL Server uses 64K pages, isn't it MORE advantageous to use a larger stripe width, say, 1MB?  This would allow for multi-page reads. Doc  

reading excel file without saving to disk first

Having an issue.  I need to be able to read an excel file from a file upload control but I can not save the file to disk first, it must be done in memory.string excelConnectionstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="; excelConnectionstring += filePath.Replace("/", "\\"); excelConnectionstring += ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'"; OleDbConnection con = new OleDbConnection(excelConnectionstring); OleDbDataAdapter da = new OleDbDataAdapter();Above is my code for reading the data file if it IS saved to disk, but again, I have to be able to do this without saving the file to disk, it must be done in memory.  I have not been able to find any sample code anywhere on how to do this from memory, everything seems to force the file be uploaded, saved to disk, and then read in the connection string, which again I can not do.Any advise would be great, thanks in advance.  I'm really in a bind here.

Hard disk

My laptop is Lenovo T400, 320G without partition and installed Window Vista. Recently, the hard disk space around 100G missed and can't display by using the Lenovo thinkVantage toolbox which only classified as no scaned. May I find the missing and release to normal use? Since it only remain 4x G. for further use.

Dependency of IP , n/w , Disk in MSDTC.

have installed sql server 2005 cluster but never 2008 ,now I have got this chance but I am not understanding how to create dependency of IP , n/w , Disk in MSDTC. What are the domain user rights ?Actually my previous site was given the writes of domain admin to the sqluser now it is giving me problem.??"SQLSERVER DBA" "INDIA"

General Controller to View logic question

Hello, I am currently learning the MVC2 Framework and I have a brief question in terms of my logic and if their are any flaws in it. I created a basic example in a couple of minutes that demonstrates the way I think about it. public ViewResult Index() { return View(); } public ViewResult Cookies() { return View(new Cookie()); } public ViewResult CookiesInput(Cookie cookie) { return View(cookie); }<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <h2>I really like cookies</h2> Would you like a cookie? <% using (Html.BeginForm("Cookies", "Example")) { %> <p><input type="submit" value="Yes" /></p> <% } %> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <h2>Cookies</h2> <% using (Html.BeginForm("CookiesInput", "Example")) { %> <%= Html.EditorForModel() %> <p><input type="submit" value="Gimme" /></p> <% } %> </asp:Content><asp:Content ID="Content2" ContentPlaceHolderID="MainConten

find and replace linebreaks in file read from disk

I have a css file which I want to read from disk and in that content I want to find and replace all linebreaks (do I look for vbCrlf or ...?)   Public Shared Function GetFileContents(ByVal FullFilename As String) As String        Dim filecontents As String = ""        If File.Exists(FullFilename) Then            Dim objStreamReader As StreamReader            objStreamReader = File.OpenText(FullFilename)            filecontents = objStreamReader.ReadToEnd()            objStreamReader.Close()        End If       Return filecontents    End FunctionSo in the returned variable "filecontents" I want to find and replace any linebreaks.        FILE: style.css#progress{color:#000;width:500px;height:30px;padding:0px;clear:both;}#progress ul{list-style:none;padding:0px;margin: auto;display:block;}#progress ul li{list-style:none;display:inline;float:left;width:auto;height:30px;padding:0px;line-height:30px; font-family:Arial, Helvetica, sans-serif; font-size:13px;}

copy the image from table to disk drive

i have 2000  image he saved in the table "Employee" and i want to copy this pictures from table to diskdrive and save file name by the ID

Recommended disk setup

Hi All - I have a brand new server that will be running Windows 2008 STD and SQL 2005 Std.  I have 2 160 GB disks and 2 x 500 GB.  I am planning on mirroring the equal sized disks so I will have 160 GB and 500GB. I am looking for recommendations on how to best split up the OS, DBs and logs.  I am not constrained on space as I have numerous small DBs that will be migrated from an ancient server. Thanks in advance.   Mark
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend