Re: Sql2k, Performance and Junction Points

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tim (Tim_at_NoSpam)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 15:50:52 +1300

David,

Hi,

If you do this, will your system be:
Better performing?
More Secure?
Meet business needs better?
More robust?
More manageable?

Answers: Yes, No, or Unaffected.

If you answer No to any of the above questions then you should not do this.
If you do not answer Yes to at least one of the above, then you should not
do this.

IMHO, you should not do this.

- Tim

"David Ashe" <davida@telephia.com> wrote in message
news:%23GhtR7e8EHA.1260@TK2MSFTNGP12.phx.gbl...
> Hi All.
> We have been configuring our Larger SQL Servers with the following disk
> layout:
> c:\ OS
> d:\ SQL Server Executables
> e:\ Database Files, tempdb.
> f:\ Database Logs.
>
> I would like to adjust this a bit by using junction points to link folders
> on E and F back to the D:\...\MSSql, then place the database files in
> these folders. The files will still be on different disks, however, as
> far as SQL Server is concerned, the files will be stored in
> D:\...\mssql\TDATA an D:\...\mssql\TLog. This will alow us to standardize
> our configurations better - we can move files to a SAN, or other DAS, but
> the SQL Server configurations are the same.
>
> A developer in our group claims that without the files explicitly being on
> a different drive ("E:/F:") SQL Server will not paralellize the queries,
> and we will lose performance. I am hoping that this is incorrect, can
> anyone confirm?
>
> Dave
>

Relevant Pages

  • Sql2k, Performance and Junction Points
    ... We have been configuring our Larger SQL Servers with the following disk ... e:\ Database Files, tempdb. ... This will alow us to standardize our configurations ... better - we can move files to a SAN, or other DAS, but the SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Performance difference between SQL Server 2005 and 2008
    ... I understand that configurations and versions are ... My understanding is that when data pages are loaded in memory, ... We in the process if migrating our SQL Server 2005 database ... Did anyone has similar experience when stored procedure ran slower ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL Server 2005 SP1 install fails on Windows 2003 EE R2, need DB mirroring
    ... You encountered the error when you installed the SQL Server 2005 SP1. ... This issue seems most likely caused by the master database files locating ... You can use a tool, such as Sysinternals Process Explorer, to ... determine the location of the master and Resource database files that are ...
    (microsoft.public.sqlserver.setup)
  • Re: Maintenance Plan
    ... SQL Server doesn't grow the database files by itself. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Sql2k, Performance and Junction Points
    ... I have the answer to all but the "Better Performing" question which is what ... I did find a reference to configuring Siebel with Sql Server on a SAN, ... >> We have been configuring our Larger SQL Servers with the following disk ...
    (microsoft.public.sqlserver.setup)