System Setup And RAID Stripe Size
May 4, 2006
Dear All,
I've been asked to build a 64bit Windows 2003 server which will SQL Server Enterprise 2000 64bit edition on it. This is my first foray into the world of 64 Server OSs, so hoping to get some advise from the wise. This will be used as a back end to a web application. This server has been purchased with 5 disks (all 146GB disks) in it. Currently this has been setup from the manufacturer as RAID 1+1 with 1 disk not allocated.
I was going to reconfigure the logical drives to have RAID 1 (2 drives) which has OS and swapfile on it, and RAID 5 (3 drives) with all SQL data (the main DB I am estimating to be 20-30GB) on it.
Reading through a couple of forums and google results regarding determining stripe size, it seems some people are recommending putting the tempdb and logs on a seperate drive to the rest of the SQL data, as well as trying to get the optinum strip size.
Can you let me know your opinions on if my proposed logical drive setup seems OK (or just keep one logical drive as either RAID5 or 6), and if tempdb and logs should be on the OS, or should stay on the RAID 5 array? Also, for the stripe size, should I think the same as a 32bit OS, and just use 128/64 or 64/64?
Geoff
edit: SQL Server type corrected.
View 4 Replies
ADVERTISEMENT
Mar 6, 2008
I was informed (by Microsoft) that for all SQL Servers prior 2008 recommended (or must) stripe size is 64k
Does anyone knows full set of settings that must be applied when
setting up raid 5 for sql server box
Thanks
View 4 Replies
View Related
Jun 14, 2001
HI There,
Generally speaking, is it better to use a large or small stripe size for a Raid 5 array (4 drives) ? I would appreciate any specifics also.
Thanks in advance.
Charlie
View 1 Replies
View Related
Aug 20, 2004
Folks
What stripe size is recommended for Win2K Server which will be running a ~10 Gb database with normal read write ? I was thing 32K ..
View 1 Replies
View Related
Jun 11, 2008
HI All,
I'm going to buy 1 IBM DS3400 SAN. I got 2 x SQL Servers
one for our ERP System other for Web
Physical Server are like this ATM
SQL1 (ERP) ( 3 RAID arrays)
-----
OS: 36GB (RAID 1)
DATA: 120GB (RAID 5)
Log : 15GB (RAID 5)
Backup:270GB (RAID 5)
SQL 2 (WEB) ( 2 RAID Arrays)
-----
OS: 120GB (RAID1)
Data/log/bak 569GB (RAID10) disk like this
DATA: 218gb
LOG:15gb
Backup: rest
So how do i raid the SAN and what sort of HDD i should buy?
View 2 Replies
View Related
May 18, 2006
I have a database that is around 2 to 4 GB.If I were to estimate some numbers like 4x growth oreven 10x, the database size could reach 40GB.The new server will be running SQL Server 2005.I am not sure which configuration option to take.I've gathered some information from different places:Configuration #1:OS - Raid1 2x36GBLogs - Raid1 2x36GBData - Raid 5 4x73GBConfiguration #2:OS - Raid1 2x36GBLogs - Raid5 (not sure how many drives)Data - Raid5 (not sure how many drives)Now if I am using a separate RAID array disksfor the database's transaction log, should I also put theTempDB in this RAID also?Here's the configuration I am thinking of right now.Please give me your comments:OS - Raid1 2x36GBLogs & TempDB - Raid5 3x36GB = 2x36GB usable spaceData - Raid5 3x73GB = 2x73GB usable spaceIf you have other configurations you recommend please letme know.Thank you
View 1 Replies
View Related
Oct 7, 1998
can anyone help me? I just installed WinNT 4 SP3 and now trying to install SQL 6.5 on an IBM Netfinity 5500 with RAID 5. There is one 500mb partition for the system and then one 12 gig partition and SQL only seems to see ~117mb of the 12 gig partition. Is this a known prob? Thanks for any input
Josh
View 1 Replies
View Related
Jun 27, 2015
I am wondering what would be the best disk/RAID setup for a Windows server 2008 R2 OS and SQL Server 2012 database that has heavy read/write. I have the following disks I can use:
4x 15k 146GB
2x 10k 600GB
According to the server build requirements for the application, I need 100GB for the OS and 290GB for the drive containing the SQL mdf there are no stated requirements for the ldf, but would like to know if it should be allocated elsewhere?I should do RAID 10 for the 15k drives for SQL and RAID 1 for the OS on the 10k.
View 6 Replies
View Related
Jan 5, 2006
I have XP Pro SP2 with MDAC 2.8.1022. It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error.
I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP. There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs.
There's some other strange things, so I wonder if they are related.
1) I have Paul set up as an administrator account. Some folders like MSSQL show that account with no permissions. I grant all the permissions to Paul for that folder. I come back later and the permissions are gone.
2) I deleted 20 files in Explorer, but 7 of them did not go away. I deleted those 7 again and they instatnly reappeared. I deleted those 7 again and then they finally went away.
3) I get a slow reaction time for things like Windows Explorer and opening and closing programs. This is suprising since it has 2 gig of RAM and 2.3 Gig processor. Could it be a memory handling problem that's causing OS problems. Probably, the memory didn't handle the OS installation well and the whole system is compromised now.
View 12 Replies
View Related
Apr 4, 2007
I am configuring a new database server, without SAN access, and want to know what is the best practice for SCSI RAID configuration. Do most folks prefer RAID 5 or RAID 10 configurations where their databases will reside?
View 8 Replies
View Related
Dec 14, 2007
Same issue in VS 2005. Using a setup project (or ClickOnce) there seems to be a limit to how large a content file can be. I'm cross-posting in setup and ClickOnce, but thought that other SQL CE developers may have had this issue.
---------------------------------------------------------
I cannot find a reference to this in the online help, and find no answer here. I have some SQL CE databases that are marked as 'content' in a project. One is less than a mb, the other is over 600mb. The larger one will always break the setup build if I leave it marked as content. Also will break a 'clickOnce publish' build.
How does one use the MS Visual Studio tools for setup when a file size is too big?
What is the max file size limitation?
I need to deploy with ClickOnce, but find it difficult to determine the directory that my large file will need to be copied to afterwards since a ClickOnce install uses such a confusing path to install to. So, if the workaround is to fire a script post install, it would be a problem to discover the path for that file to be copied to.-----------------------------------------------------------------
View 1 Replies
View Related
Mar 27, 2008
I've always heard that RAID 5 (or better, RAID 10) is preferred for the actual database (mdf), but RAID 1 for logging.
If I have a dedicated physical volume for each, what's the performance hit for selecting RAID 1 for the MDF files? 3%, 20%, 200%?
Doing so (all RAID1) will allow me to have a separate physical volume for the TEMP database - that is heavily used by my app.
View 1 Replies
View Related
May 1, 2006
RAID 5 beats RAID 10Can I get some feedback on these results? We were having some seriousIO issues according to PerfMon so I really pushed for RAID 10. Theresults are not what I expected.I have 2 identical servers.Hardware:PowerEdge 28502 dual core dual core Xeon 2800 MHz4GB RAMController Cards: Perc4/DC (2 arrays), Perc4e/Di (1 array)PowerVault 220SEach Array consisted of 6-300 GB drives.Server 1 = Raid 103, 6-disk arraysServer 2 = Raid 5 (~838 GB each)3, 6-disk arrays (~1360 GB each)TestWinner% FasterSQL Server - UpdateRAID 513Heavy ETLRAID 516SQLIO - Rand WriteRAID 1040SQLIO - Rand ReadRAID 1030SQLIO - Seq WriteRAID 515SQLIO - Seq ReadRAID 5MixedDisktt - Seq WriteRAID 518Disktt - Seq ReadRAID 52000Disktt - Rand ReadRAID 562Pass Mark - mixedRAID 10VariesPass Mark -Simulate SQL ServerRAID 51%I have much more detail than this if anyone is interested.
View 13 Replies
View Related
Sep 25, 2007
Greetings all,
Please allow me to describe my setup briefly and then I will jump into my problem/questions. I am trying to setup a shared hosting/DB type environment in a secure manner. I have two Windows Server 2003 boxes where Machine 1 is the DB server (MS SQL Server 2005) and Machine 2 is the web server (IIS 6.0). The web server may ultimately have 5-6 different customers (web applications/domains) on it.
In order to keep an exploit/poor code in one customer's application from accessing the files of another, the server is being setup so each website instance runs with a different low-privileged domain account (in Domain Guests). For example, for Website 1, the Directory Security will be setup so it runs with DOMAINIUSR_website1 and for Website 2, the Directory Security will be setup so it runs as DOMAINIUSR_website2. Both of these accounts are in the Domain Guests group and no other groups. This was chosen so that the DB used by each websites on the SQL Server could have read/write permissions granted to the appropriate user. On the web server the SYSTEM DSN is setup to access each database. This way if there is a DB setup with permissions for IUSR_website1 and it gets called by IUSR_website2, access will be denied. If I ran each website instance as the same user, they could in theory still called this DSN and access someone else's database.
Now here is the problem I get. First, the website access works just fine with it setup as the Domain Guest user account. However, when I go to the called the System DSN for DB access I get this error:
---------
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][SQL Native Client][SQL Server]Login failed for user ''. The user is not associated with a trusted SQL Server connection.
/login.asp, line 7
--------
Line 7 of login.asp is as follows:
objConn.Open "DSN=DSN_CTO_SQL"
--------
So it appears there is something that is failing here. For troubleshooting purposes I have taken that IUSR_website1 account and placed them into the Domain Users group instead of Domain Guests. This fixes the problem. However, it's not the most secure setup to run the web/SQL stuff as a Domain User. Any ideas on why it works fine if the account is in Domain Users but not with Domain Guests? I even went to the registry key for HKLMSoftwareODBC and gave DOMAINIUSER_website1 specific read permissions. This did not fix the problem.
Can anyone make a suggestion or know what the issue is? How are people running secure IIS 6.0 + SQL Server setups for shared environments?
Thanks
Steven
View 6 Replies
View Related
Jun 3, 2015
I am using windows 8 and I have only one user in laptop. While installing SQL 2014, I am getting an error (Missing System Administrator). Under SQL Server Agent and SQL Server Database I have select the system user and gave the password but still I am getting the error.
View 8 Replies
View Related
Jan 3, 2008
Help please...
We have developed a system for a medium size company in NYC using SQL Server 2000.
We are about to go live and thought it may be a good idea to upgrade first from SQL Server 2000 to 2005.
I believe standard edition would be sufficient but I am not 100% sure... There isn't a whole lot of data but high availability is crucial. I was thinking of a 2-node fail over cluster setup and/or mirroring.
We need only one instance of SQL Server with about 30 client machines accessing the same databases.
Any thoughts/comments as far as:
Standard or Enterprise?
What type of licensing? Support agreement?
What about the best setup for highest availability? (fail over cluster vs. mirroring vs. replication)
Thanks,
Toshu.
View 1 Replies
View Related
May 22, 2013
When I install SQL 2012 on MS Server 2008 R2, I get this error..The following error has occurred: The system cannot open the device or file specified. Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
The file in question is Install_VSShell_CPu32_Action. when I retry, the error is..The following error has occurred:SQL Server Setup has encountered an error when running a Windows Installer file.Windows Installer error message: This update package could not be opened. Verify that the update package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer update package. Windows Installer file:
Windows Installer log file: C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20130522_143111VSShell_Cpu32_1.logClick 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.
View 7 Replies
View Related
Apr 24, 2006
Hi,
I'm running W2K3 SP1. The MDAC Configuration Checker reports MDAC 2.8 SP2. The only discrepancy is MSADCO.DLL, where the expected version is 2.82.1830.0 and my actual version is 2.82.2651.0 (svr03_sp1_gdr.060301-1546).
The error message I'm getting when I use the ODBC Administrator dialog to set up a new entry is: "The setup routines for the SQL Server ODBC driver could not be found. Please reinstall the driver."
This is followed by a dialog titled: "Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed." The body text of the dialog is "Component not found in the registry."
Does anyone have any idea how I can repair this?
Thanks,
View 13 Replies
View Related
Sep 22, 2007
I am getting following error when trying to install SQL express 2005 on XPSP2.
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342
I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.
Do i need IIS installed? Its not installed on this box...
please suggest something... i am stuck...
Thanks,
View 3 Replies
View Related
Sep 4, 2007
I am trying to resize a database initial log file from 500M to 2M. I€™m using€?
ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "
And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.
Any help with this process?
View 1 Replies
View Related
May 29, 2001
My SQL 7 is on RAID 5. Sometimes on non-peak hours, on RAID disks first
two lights ( from left ) are constantly on for hours. NT Task manager, nothing
unusual, SQL current activity - no running user processes. Isn't second light
on RAID comes on if any disk activity ( Read/Write ).
Suggestions are appreciated.
Thanks,
Ivan
View 2 Replies
View Related
Sep 28, 1998
I`ve tried implementing NT Software Raid / Stripping with Parity
and am unable to stripe disc that are more than 2g and
use SQL. I have not found any info in technet. Any ideas! Thanks.
View 2 Replies
View Related
Dec 20, 1998
Should one install RAID 5 for SQL Server or just use separate hard drives, one for the data and one for the transaction log?
View 4 Replies
View Related
Apr 15, 2008
could any one tell me about the difference between RAID and SHARED DISK ARRAY
View 3 Replies
View Related
Jul 20, 2005
Hi,I was going to buy a server with Raid 1 as I thought that it meant that ifone of the two mirrored drives fail, you simply take it out and put a newone in. At which point presumably the hardware takes over and copies theother drive over to mirror it again.However, my sql server admin book, says raid 1 is bad, as it means you havelots of downtime, when recovering from a broken drive.Can anyone give me some advice on this? What is the best Raid to use whenyou are running SQL server on the server.ThanksJJ
View 1 Replies
View Related
Aug 21, 2006
I have created a windows library control that accesses a local sql database
I tried the following strings for connecting
Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Trusted_Connection = true"
Dim connectionString As String = "Data Source=localhostSQLEXPRESS;Initial Catalog=TimeSheet;Integrated Security=SSPI"
I am not running the webpage in a virtual directory but in
C:Inetpubwwwrootusercontrol
and I have a simple index.html that tries to read from an sql db but throws
the error
System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,
etc etc
The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.SqlClient.SqlClientPermission
The Zone of the assembly that failed was:
Trusted
I looked into the .net config utility but it says unrestricted and I tried adding it to the trusted internet zones in ie options security
I think that a windows form connecting to a sql database running in a webpage should be simple
to configure what am I missing?
View 28 Replies
View Related
Sep 13, 2001
Im setting up a hardware raid 5 solution for one of our db servers. The data files will reside on the stripe. We dont realy want to raid more drives for the Transaction log if its not nessesary. If the drive with the log crashes is the data file for the database useless ?
View 1 Replies
View Related
Nov 29, 2005
Hi guys,
On a new server with 4 disks, what level of raid is best to apply. In terms of what's important, I'd say speed is at the top of the list.
BJ
View 1 Replies
View Related
Mar 17, 2004
Hello,
I run a small homw office. I am planning to purchase a dell powerdge 1750 server to install SQL server on that.
I am confused here about which RAID should I install on this server RAID 1 or RAID 5.
The dell customer rep could not tell me the advantages of installing only RAID 1 or only RAID 5 or installing both RAID 1 and RAID 5
View 7 Replies
View Related
Mar 18, 2006
I am recommending that we change our Raid Configuration on some of ourServers from Raid 5 to Raid 0+1; we are experiencing severe IObottlenecks.Our hardware guys are pushing back a bit. They claim that Dell has aweird implementation of 0+1 and told me something about one drivefilling up before it begins to write to the next. They claimed thatthis gets rid of most of the benefits of 0+1.I know that 0+1 is not as good as 10 for availability, fault tolerance,and rebuilding, but shouldn't the write throughput be about the same?Setup:Poweredge 2850Powervault 220SPerc 4/DC Controller 1Perc 4e/DI Controller 0
View 5 Replies
View Related
Jan 5, 2006
I have always used RAID 5 for my database apps. I am wondering though is this the best solution. I am purchasing a new server and deciding whether to go with RAID 1 or RAID 5. This server will support all our .NET Apps, SQL Server 2005, Reporting Services, and Integration Services.
Any Input?
View 4 Replies
View Related
Jan 4, 2002
Server: Msg 3132, Level 16, State 1, Line 1
The RAID set for database 'xxxxx' is missing member number 2
This happens when I try to run a restore?? is it because my server
is not set up as RAID 5, I had took a dump from one server and try
to apply it to another? Suggestion please.
View 1 Replies
View Related
Apr 28, 2003
I have a server setup with the standard recommended RAIS(10-5-10 setup (10 for the OS, 5 for the data, and 10 for the trans logs). Running out of space on my RAID 5. Have lots of extra space on my RAID 10 where my trans logs are. I currently dump my files to disk and then use tape to back them up. I have been putting these files on my RAID 5 array, but was going to move them to my RAID 10 array. Anyone seen any downside to doing this?
View 2 Replies
View Related
