Unix Technical Forum

TempDB Disk placement with Log files?

This is a discussion on TempDB Disk placement with Log files? within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello, I've a couple of questions on setting up my lovely new server... I've decided on R1 (2*36GB) for ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-29-2008, 03:56 AM
Rob
 
Posts: n/a
Default TempDB Disk placement with Log files?

Hello,

I've a couple of questions on setting up my lovely new server... I've
decided on R1 (2*36GB) for the OS, R1 (2*73GB) primarily for the Log
Files and R5 (5*73GB) for the Data files.
I was wondering if I could increase performance by partitioning off/
creating a new volume on my log array and placing on there the tempdb
and possibly another volume for the indexes.ndf.

Any ideas on whether its OK to have other volumes use the same pysical
disks as the log array?

And, is it best to have as many data files for each database as there
are on your disk array, so 5 in my case (or is it 4 as it's R5 , i.e.
1-n disks).

Setup Ideas welcomed!
Rob
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:24 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com