Re: SORT_IN_TEMPDB not use tempdb???

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 09:32:39 -0400

No it does not know the difference between a physical drive array and a
logical drive per say. As Derrick mentioned how are you determining that
tempdb is not being used? How much memory do you have? Maybe you have
enough free memory that the physical drive amy not matter as much. 

-- 
Andrew J. Kelly  SQL MVP
"Jéjé" <willgart@BBBhotmailAAA.com> wrote in message 
news:exL1%23GMtEHA.2196@TK2MSFTNGP14.phx.gbl...
> its a command like this:
> create index [IndexName] on Table (col1, col2 ...) with fill_factor=100, 
> SORT_IN_TEMPDB on primary
>
> Does SQL Server test if the tempdb database is on the same hard drive as 
> the target index file?
>
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> a écrit dans le message de 
> news: ekaz86LtEHA.2808@TK2MSFTNGP14.phx.gbl...
>> Are you sure that tempdb is actually on a different set of physical disks 
>> or just a Logical drive?  What is the actual command you used?  This is 
>> only applicable on creating an index not rebuilding one.
>>
>> -- 
>> Andrew J. Kelly  SQL MVP
>>
>>
>> "Jéjé" <willgart@BBBhotmailAAA.com> wrote in message 
>> news:%23ClIQmKtEHA.376@TK2MSFTNGP09.phx.gbl...
>>> Hi,
>>>
>>> I've an index to create around a table with 3millions of rows.
>>> my tempdb database is on a different set of disks, so I use the 
>>> SORT_IN_TEMPDB when I recreate my index, but I don't see any activity 
>>> around the tempdb database and the time to create the index is the same!
>>>
>>> any idea?
>>>
>>> thanks,
>>> Jerome.
>>>
>>>
>>
>>
>
>

Relevant Pages

  • Re: I am getting tempdb full error again
    ... Andrew J. Kelly SQL MVP ... Why don't you just make tempdb larger than you need and forget about this issue. ... exec sp_helpdb tempdb ...
    (microsoft.public.sqlserver.server)
  • Re: use of tempdb by union all
    ... > You are certainly correct about table variables using the tempdb database, ... Andrew J. Kelly SQL MVP "Tenaya" wrote in message ... > You are certainly correct about table variables using the tempdb database,> and not being entirely memory resident ... ...
    (microsoft.public.sqlserver.programming)
  • Re: database space
    ... > Andrew J. Kelly SQL MVP ... I would like to know when my tempdb starts to grow and caused by ... >> it burst. ...
    (microsoft.public.sqlserver.server)
  • Re: SORT_IN_TEMPDB not use tempdb???
    ... Andrew J. Kelly SQL MVP ... > Does SQL Server test if the tempdb database is on the same hard drive as ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Optimal installation/configuration on Win2003
    ... Taras Tim Bredel - Denmark ... Tempdb would depend on how much activity it receives but ... > probably best to also place it on the Raid 1. ... >> Hi Andrew ...
    (microsoft.public.sqlserver.setup)
Quantcast