Re: Sql2k, Performance and Junction Points

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: David Ashe (davida_at_telephia.com)
Date: 01/05/05 

Date: Tue, 4 Jan 2005 18:57:23 -0800

I have the answer to all but the "Better Performing" question which is what
I am asking.
I did find a reference to configuring Siebel with Sql Server on a SAN, and
it indicated that using Volume Mount points
causes no performance impact.

D

"Tim" <Tim@NoSpam> wrote in message
news:e6kOeCt8EHA.2452@TK2MSFTNGP14.phx.gbl...
> 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

  • Re: Orphan Indexes?
    ... I have tried performing the DROP as both part of and outside of the stored ... I tried the DROP from Query Analyzer and from the helper ... > Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • RE: Question if someone asked you to develop a portal
    ... You've added an element that wasn't mentioned before, installing SQL Server and configuring the operating system. ... > get into custom designing area or site definitions, ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: SQL Server extremely slow
    ... An Access application using a SQL Server back-end via ODBC linked tables is ... it was performing well anyway, then there isn't much scope to improve it!) ... running any query involves TWO query engines: ... database and shunted across the network so that Access/Jet can execute the ...
    (comp.databases.ms-access)
  • Re: Sql2k, Performance and Junction Points
    ... Better performing? ... > d:\ SQL Server Executables ... > e:\ Database Files, tempdb. ... > the SQL Server configurations are the same. ...
    (microsoft.public.sqlserver.setup)
  • Re: SqlConnection and DB connection failures detection
    ... Now question - after performing insert query I'm closing connection, ... but my process still exists in SQL Server Activity Monitor (even if i ... close my app) with "Sleeping" status. ... Then second question - I'm using SQL Server authentication instead of ...
    (microsoft.public.dotnet.languages.csharp)