question

sql server avatar image
sql server asked

Installatiuon of sql server 2005 in SAN disk

Hi All, I was asked to install sql server 2005 on san disks but am new to this dba side any one gide me how to insatall sql server 2005. In brief san in the sence local disk or not whether i t will available r not as a local drive only. How to allocate data in to san disk pls help me regarding this as soon as posible it's very urgent... Thanks, Balaji
sql-server-2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tim avatar image
Tim answered
Installing SQL Server is very straight forward. As far as putting the databases on a SAN disk it is very simple. You can specify the location of the databases during installation. A question I have before giving you detailed instructions is how is your SAN configured? Are you going to have multiple luns for data, transaction logs, tempdb and backups or will you just have one single lun? If you do a search on Google or BING you will find tremendous resources on installing SQL Server 2005. Some folks have even blogged with screenshots of how to accomplish what you are asking for.
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image Tim commented ·
You have a couple of options. You could specify the location during the installation of SQL 2005 on where you want the databases stored. You can change the path from c:\program files\... Another option is to install SQL to the default path and then move your system databases and update the default path for any new databases. An article published by [Microsoft on how to change the location of the system databases]( http://msdn.microsoft.com/en-us/library/ms345408(v=sql.90).aspx) Is this the first installation of SQL Server in your shop utilizing the SAN? There are lots of best practices and a single physical LUN isn't one of them. What type of load is this SQL Server instance going to be under? Typically you would want different RAID groups for your data, logs, tempdb, and your backups. The backup lun is usually slower disk than your data, logs, and tempdb. Do you know what speed disks, RAID format, and the number of spindles you have? Is the LUN on a shared RAID Group? Depending on those factors you may be worse off than using local storage.
0 Likes 0 ·
Tim avatar image Tim commented ·
Here is an installation demo by Andy Leonard [Click Here]( http://sqlblog.com/blogs/andy_leonard/archive/2008/07/15/installing-sql-server-2008-rc0.aspx) This was done for SQL 2008 but you will get the jist of how to install it. The screens are similar enough between the two versions.
0 Likes 0 ·
sql server avatar image sql server commented ·
This is the first time installation of sql server 2005 in SAN drive.Data is loaded in memory only.Coming to RAID levels for data,logs,tempdb and backups.i don't know speed of SAN disk.
0 Likes 0 ·
Tim avatar image Tim commented ·
The questions I raised above should be questions you are asking if you are expected to support this server in a production environment. Spend a few minutes to read this [blog post]( http://www.brentozar.com/consulting-services/san-implementation-tuning/) by Brent Ozar about some of the issues. This blog addresses is it a SAN problem, is it a database problem, is it a hardware problem, is it a virtualization problem. Once you put your data on a SAN not knowing how it is configured and how to troubleshoot issues that could be cause because of a poor performing SAN can waste very valuable time of yours. You could spend days troubleshooting a slow running database looking at nicely optimized queries that are running slow only to find out it is your disk subsystem. Spend the time up front to make sure things are configured properly and for SQL before you go into production. You will be very grateful later on.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.