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

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Application files installed on SAN

Author  Topic 

cormac_hogan
Starting Member

3 Posts

Posted - 2008-09-03 : 11:24:31
Hi All,
Faced with using a SQL Server 2005 that is SAN attached however the application files were installed on the SAN Storage.

The performance of the server seems poor and the server it self is high spec.

Is the application files installed on the SAN storage a performance issue?
Is it possible to relocate these files back to a local drive?

Regards and thanks,
Cormac

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-03 : 11:42:18
What do you mean by application files? Are you referring to the database files or the program files?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

cormac_hogan
Starting Member

3 Posts

Posted - 2008-09-04 : 03:55:56
Hi,

I'm referring to the program files. The database files are also installed on the SAN storage, which is what is to be expected. However the whoever did the initial install may have confused which drives were local and which were SAN, so they installed the program files on SAN storage too.

Regards,

Cormac
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-04 : 10:28:48
You'll need to uninstall/reinstall to move them.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

cormac_hogan
Starting Member

3 Posts

Posted - 2008-09-05 : 08:07:32
Figured as much. But is it an issue. I assume it is but can't find any confirmation information that it is an issue.
Go to Top of Page
   

- Advertisement -