New Server Setup And RAID Recommendation
May 18, 2006
I have a database that is around 2 to 4 GB.
If I were to estimate some numbers like 4x growth or
even 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 2x36GB
Logs - Raid1 2x36GB
Data - Raid 5 4x73GB
Configuration #2:
OS - Raid1 2x36GB
Logs - Raid5 (not sure how many drives)
Data - Raid5 (not sure how many drives)
Now if I am using a separate RAID array disks
for the database's transaction log, should I also put the
TempDB in this RAID also?
Here's the configuration I am thinking of right now.
Please give me your comments:
OS - Raid1 2x36GB
Logs & TempDB - Raid5 3x36GB = 2x36GB usable space
Data - Raid5 3x73GB = 2x73GB usable space
If you have other configurations you recommend please let
me know.
Thank you
View 1 Replies
ADVERTISEMENT
Nov 20, 2007
We are setting up a SQL 2005 cluster at our ISP and would like some feedback from anyone or DBAs for the pros and cons for the following setups.
Option 1.
http://img3.freeimagehosting.net/image.php?d2e8e7e923.gif
Option 2.
http://img3.freeimagehosting.net/image.php?11742dda91.gif
Basically, we need to know which set up is the preferred method.
View 3 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 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
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
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
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 12, 2000
Need Recommendation on Tool for SQL Server Development
I have inherited a SQL Server 7 database (actually a SQL Server 6.5 database running on SQL 7 in compatibility mode) with 1000s of objects with triggers and stored procedures with zero documentation; i need to make major changes to this database; are there any tools available that will allow me to quickly search through the database objects and code (like stored procedures, etc) for keywords and other useful criteria? Do you recommend any SQL Server specific tools that will help me learn this database in the shortest amount of time?
Thank you!
--llyal
View 1 Replies
View Related
Aug 14, 2006
Our shop is expanding use of SQL Server, both 2000 and 2005. We haveLitespeed on some boxes to handle the backup/recovery jobs. Can I askwhat are considered the best tools for monitoring SQL Server, in termsof things like performance monitoring, tuning and auditing if it ispossible to get all of this functionality in one?What do you use and like?Thanks in advance.Gerry
View 2 Replies
View Related
Jul 20, 2005
Greetings All, I would be much obliged if anyone can point me to agood book on Java/JDBC and SQL Server.Regards, Louis.
View 1 Replies
View Related
Feb 14, 2006
Hello,
I have been working as Sybase DBA for 5+ years, and I would very much like to add MS SQL Server to my resume. Given the common roots of the two RDBMS, it seems that the learning curve would not be as sharp as if I were going to learn Oracle or DB2. Can anyone out there know of any books that are geared toward learning MS SQL Server from a Sybase DBAs perspective?
Thank you,
- Chris Merz
View 3 Replies
View Related
Jan 25, 2008
Hello! I hope that I have posted in the right spot.
We are looking for advise. I know that there is no right or wrong answer. "It depends."
We currently have a server with the OS as Windows Server 2003 SP2 and SQL Server 2000 SP3. This Server has 6 physical drives; only 3 of these physical drives are being used. These 3 physical drives are 1 container with Raid 5. This 1 container is divided into 3 logical drives.
We would like to fill the other 3 physical drive slots and create another container. We were thinking of making this Raid 1.
I should put in my disclaimer that Raid 10 is out of the question and so is SAN.
Is Raid 1 the best choice? This is my first question.
Next is how should we split up the files among the containers.
For example, OS, log and swap file on container 1 with Raid 1 and datafiles on container 2 with Raid 5?
What are most people doing? Is there a standard? Can people provide examples of what they are doing or provide suggestions?
View 11 Replies
View Related
Dec 2, 2006
Is there any benefit in creating seperate file groups for a partitionedtable on a multi-processor server with RAID5 and 1 Logical Drive?
View 8 Replies
View Related
May 26, 2006
Not the server software obviously, but storing the files on their RAID solution? it doesn't seem that bad of a bang for your buck and I read good things about it.
View 3 Replies
View Related
Apr 24, 2015
I am running a number of SQL instances on my PC. Within the network, I have think server with various System Center components. For compatibility reasons, some features of System Center 2012 R2 had to be delegated to different SQL databases. My question is, because there is now more than one IP address on my system, and each instance of SQL is assigned to its own IP, is there a way to setup DNS and SQL so the namespace points to the desired IP address? For Instance:
MSSQL2008 instance is set to run on = 11.12.13.1
MSSQL2012 is set to run on = 11.12.13.2
IN DNS:
A Record: Mike-PC = 11.12.13.1
A Record: Mike-PC = 11.12.13.2
If I want to use MSSQL2008 by specifying Mike-PC as the DNS name, how would I do that with 100% accuracy? If there is another way to get the job done, I am more than willing to approach this differently.
View 3 Replies
View Related
Jun 24, 2004
I was if anyone can recommend a book that specifically focuses on SQL statements such as Queries, Stored Procedures, Triggers, Transcations..etc
View 11 Replies
View Related
Apr 8, 2008
Hello,
I will have to create a table that consists of only of two fields. one: them employeeID and two: the SupervisorID,
my question is what should I define as my primary key. Should it be an aditional field, or could it be the EmployeeID field.
The employeeID is an unique filed. The end user for this application will be updating rearly some of this records, and may be adding or deleting some new records exporadically.
Thanks for suggestions.
View 6 Replies
View Related
Dec 21, 2006
Hi:
Here's the scenario I'm working with:
A SQL 2005 server with around 1K~ databases, capacity at about 1TB~. We would like to be able to have a warm standby with transactions replicated to it. In the event of a failure on the principle, we would want the warm standby to come online automatically and begin serving db requests.
I've looked at the SQL 2005 database mirroring option; however, this has a restriction of around 10 databases per SQL server instance which, unfortunately, I exceed. One method I've been looking at is transaction replication in the classic publisher / subscriber model; however, how would I handle automated fail-over to the subscriber if the publisher were to fail?
Does anyone in the community have any thoughts or recommendations?
Thanks.
-matt
View 1 Replies
View Related
Sep 8, 2004
Can anyone recommend me other "REALLY GOOD" msql server forums?
Thanks
View 1 Replies
View Related
Sep 26, 2004
Hi, folks. I've a production SQL machine with more than 20 users making transactions 24 hrs in 6 days a week. I've only Sunday for maintenance. The server has fixed 2 GB RAM allocation for SQL. Is it good to Restart SQL ( or machine) to clear the Buffer-Cache( or is it good to keep the cache) .... :rolleyes:
Howdy!
View 3 Replies
View Related
Jan 15, 2004
Are there any general recommendations concerning filegroups? My personal point of view is to place large tables in their own filegroups and group smaller, more static, tables in a single filegroup. Is it also good practice to group small and large index in two separate filegroups or should each large index have their own filegroup? Are there any useful links out there concerning filegroups and configuration?
View 1 Replies
View Related
Oct 7, 2007
i need a recommendation for a good database creator & manager software, with a simple user interface (not access :-) ).
thx
View 9 Replies
View Related
Jul 20, 2005
I am in need of some advice. I need to build a SQL machine that willbe adequate for my company. Budget is a very big factor but I need themachine to be reliable and as redundant as possible.This box will be 'vanilla' since I will be building it myself. Ilooked at some larger companies websites and the prices are way out ofcontrol.Here's what my configuration is so far (keeping price in mind):Case: rack-mount 4UMotherboard: Intel 865GLCL (800MHz FSB)Processor: Intel Pentium 4 2.4GHzMemory: 1GB DDRAMHard Drive(s): 3-36GB SATA [10,000 RPM] in RAID 5 configurationCD-ROM: standardFloppy: standardRAID Controller: Promise SATANIC: 3ComMy machine does not come under a very heavy load but it is used often.I'm interested in hearing others comments about their SQL servers so Iknow how to gauge building my machine.
View 4 Replies
View Related
Jul 20, 2005
Can someone please recommend a good book for SQL Server 2000 for aprogrammer(Powerbuilder), not a DBA.
View 1 Replies
View Related
Jul 27, 2006
I have begun to try to break out of using Access db's (97!) and have been trying out SQL Server Express 2005 along with the SQL Management Studio Express. I am a little confused with it as I am trying to use the interface inside of VB.NET 2005 as well as the management studio and sometimes I can connect from one without the other.
Anyway this points to the fact that I have a lot to learn and I was looking for a recommendation for a book that could be a tutorial for using VB.NET 2005 with SQL Server Express. I really need something that starts from square one but hopefully builds fast. Right now it appears I need to understand connection strings (when do I put ".sqlexpress" and when do I use the server name followed by the instance for example?).
I have tried some of the books online for example and ran into a dead end with the simple tutorial (http://msdn2.microsoft.com/en-us/library/ms165732.aspx) when the headers didn't sort, I couldn't select any other pages and the edit button didn't work. I don't have a clue what happened as I followed the instructions.
Anyway if someone could recommend something that teaches using SQL Server Express while building an application with VB2005 that would be perfect.
Dana
View 3 Replies
View Related
May 31, 2007
Please give me some advice. In my application I calculate a list of identifiers (Guids) that are primary keys in my table and I have to retrieve those rows from the database. So my first approach is like
Code SnippetSELECT id, c2 FROM t1 WHERE id IN (@id1, @id2, @id3,....)
where @idn are the calculated identifies as parameters. This approach does not scale well since there is a limit of parameters that can be used. So one possibility might be to use several SELECT statements, each with the maximum number of parameters. I can't believe that this is a good solution. A temporary table may be a better solution - I don't know. Are there any better ways to retrieve performantly - any recommandations?
Thanks a lot
Hans-Peter
View 8 Replies
View Related
Jul 23, 2005
I would like to locate a book that focuses on MSSQL administration fromthe command line. My background is in Informix, and I am used to doingthings from the prompt.Any recommendations?
View 2 Replies
View Related
Jul 20, 2005
I have the Transact-SQL Programming book from O'Reilly. It waspublished in 1999. It states that "SELECT ... INTO" statements end uplocking the entire database of the target table. Since the tempdb isalso involved (in many cases), this creates major deadlocks for theentire database and all users. It suggests using the "INSERT ...SELECT" form instead.Considering that the book is somehow dated, is this recommendationstill valid, especially on target sizes of up to 5 million records?
View 1 Replies
View Related
Oct 20, 2006
I am re-writing an application for Windows CE which was originally written for the Palm OS. The original application was written in VB6 using access databases. I will be re-writing it in VB.Net and was considering using SQL Everywhere as it seems to fit the criteria that i need.
There is also an application written for the desktop that synchronizes with the mobile application. This also is written in VB6 and uses Access Databases.
I found the Sync with access CTP which i thought was exactly what i will need for this project. However i have a few concerns about SQL and Access and would like to ask a few questions before i can continue with this project.
I read that this Sync with access will allow me to synchronize the data between my desktop application and the mobile device application.
What will happen when we re-write the desktop application to use SQL?
Will i be able to sync the data between the 2 applications without using SQL Server? i.e. sync using SQL Everywhere.
If not, is there any way around it without implementing SQL Server.
I thought of having an Access Database in between the 2 applications to utilize the Sync with access component. Does this sound feasible?
Also, is it possible to Remotely sync the data without using SQL Server?
Thanks.
View 6 Replies
View Related
Apr 2, 2007
I would like to have some clarification about index-related recommendation from Database Tuning Advisor.
Let me describe the scenario first:
There is a table with clustered index defined on ID column of type INT and there are other columns of varchar/int types as well. Now when I run tuning advisor I get recommendations related to creating statistics as well as non-clustered indexes. When I view the syntax for recommended non-clustered index, sometime it explicitly add ID column as well which already has clustered index defined on it. e.g
CREATE NONCLUSTERED INDEX idx_TableName_IndexName ON dbo.TableName
(
ColName1 ASC,
ColName2 ASC,
ID ASC
)
My understanding is that for each non-clustered index, clustered index is automatically a part of it and that is how non-clustered index retrieve the actual data. I have seen it more often than not in DTA's recommendation to include clustered index column somewhere among columns for indexing for so many of my tables.
I can understand if the recommendation was to INCLUDE clustered-index column.
I would appreciate if someone out there could help me to understand what I am missing here.
View 3 Replies
View Related
Jul 10, 2007
The DBA is not around and I would like to see if someone had a good recommendation on what the Maximum insert commit size (MICS) should be for an OLE DB Destination where the default of ZERO is not being used.
I want to use Fast Load and I want to use Redirect Row to catch the errors. I just performed a test where the OLE DB Destination was NOT set to Fast Load - it took FOREVER and I cannot have this kind of performance.
I know that this may be totally dependent on what is being inserted, but is there any problem with just setting this value to say 800,000? -.
The destination SQL database's recovery mode is set to SIMPLE as it is not a transactional database.
Suggestions?? Thx
View 4 Replies
View Related
Apr 30, 2007
We are getting prepared to move from SQL Server 2000 to 2005. We have a lot of DTS's that will need to be converted to SSIS. Can you recommend a really good reference book or text book on SSIS that will help us out both with DTS conversions as well as SSIS development in general.
thanks
View 1 Replies
View Related
