Hello!
Shouldn't the tempdb log and tempdb data be on the same device?
If tempdb log is on a seperate device from the data, how do I get tempdb log
& data on the same device?
Thanks,
by William Fe » Sun, 30 May 1999 04:00:00
Shouldn't the tempdb log and tempdb data be on the same device?
If tempdb log is on a seperate device from the data, how do I get tempdb log
& data on the same device?
Thanks,
by Tibor Karasz » Tue, 01 Jun 1999 04:00:00
Yes, tempdb data and log are generally on same device(s). Not for 7, though.
Up with tempdb in ram (sp_configure), and down on disk. You'll get a tempdb
with 2 MB on default device. Take it from there. I believe that there might
be a KB article with exact details.
--
Tibor Karaszi
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.
>Shouldn't the tempdb log and tempdb data be on the same device?
>If tempdb log is on a seperate device from the data, how do I get tempdb
log
>& data on the same device?
>Thanks,
1. 6.5 Log/Tempdb device placement on RAID question...
Hello,
Concerning tempdb and log file placement....
Scenario:
WinNT OS is on its own mirrored array, and I have a RAID 5 disk array for
data, plus a mirrored array for the log file. All drives are sufficiently
large so placement of the sql server devices is not an issue.
My question is this - I know that I should separate out the tempdb file to
the mirrored disk for sequential reads, etc. etc. However, would I be
better off placing the tempdb AND database log devices on the mirrored
disk, or JUST placing tempdb on that disk?
If anyone has any info on this, or articles they could point me to I would
greatly appreciate it.
Thank you,
&J
2. interesting observation of sql 6.0 comments?
3. 6.5 log/tempdb device placement on RAID question...
4. US-IL-APPLICATION LEAD - CRM
5. changing tempdb device to log & data
6. AS Security
7. Linking a MS SQL 6.5 Log device to an existing database
8. OLEDB-SQL7 connection over the Internet
9. SQL Server 6.5 Transaction Log device space 100% used
10. TempDB & SQL 6.5
11. (TempDB) How do I remove a database from a log and or device
12. Moving tempdb log on to seperate device?????
13. Should Tempdb have a seperate log device?