SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL2K - New Install...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Steve@3717
Starting Member

USA
7 Posts

Posted - 04/05/2005 :  15:01:42  Show Profile  Reply with Quote
... in a clustered environment.
Regarding the locations of log files, TempDB & data.., we're currently planning on breaking it down like this...

Put the log files on the server.

Then on the SAN...
1st Array (2-disk RAID1) - TempDB (w/quorum and other Sys DB's)
2nd Array (5-disk RAID5 ADG) - all for data...

Or... would it make better sense to put the TempDB on the faster internal drives along with the log files?

Any recommendations are greatly appreciated.
Thanks for your help...

BTW - This is a decated SQL server.

tkizer
Almighty SQL Goddess

USA
37446 Posts

Posted - 04/05/2005 :  17:34:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
When you say log files, do you mean transaction log files? If so, then those should be on the SAN as well.

Tara
Go to Top of Page

Steve@3717
Starting Member

USA
7 Posts

Posted - 04/05/2005 :  17:41:33  Show Profile  Reply with Quote
Hi Tara.

Yes Ma'am.., transaction log files. That being the case, any problem with putting them on the same spindle (the 2-disk, RAID1 array) as TempDB?

Thank you...
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts

Posted - 04/05/2005 :  20:09:32  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message  Reply with Quote
Yes. Don't. Create a seperate RAID 1 or RAID 10 array for the transaction logs. Putting them on the same spindles as tempdb is just asking for it.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

Steve@3717
Starting Member

USA
7 Posts

Posted - 04/06/2005 :  09:13:57  Show Profile  Reply with Quote
Hey Derrick... Thank you very much for the follow-up. Looks like I'm going to need more drives.

Steve.
Go to Top of Page

bakerjon
Posting Yak Master

USA
145 Posts

Posted - 04/06/2005 :  09:42:41  Show Profile  Visit bakerjon's Homepage  Reply with Quote
Just to be clear, all of your database files need to be on the SAN drives. They cannot be local in a clustered environment


What's with the yak thing?
Go to Top of Page

Steve@3717
Starting Member

USA
7 Posts

Posted - 04/06/2005 :  10:21:44  Show Profile  Reply with Quote
Thank you Jon... It looks like the best thing to do then, is to throw two more drives at it (all on the SAN)...
2-disk RAID1 array for trans log files
2-disk RAID1 array for TempDB files (separate spindle)
5-disk RAID5 ADG array for userDB files..

Does that sound about right???

I was hoping to be able to take advanage of the faster internal drives for quicker writes and better paging performance. Instead, I'll look at using multiple TempDB files to help boost performance. The box will be running a huge number of DTS jobs during the dark hours.

You all have been a big help. Thanks again.
Steve. . ..
Go to Top of Page

bakerjon
Posting Yak Master

USA
145 Posts

Posted - 04/06/2005 :  10:58:33  Show Profile  Visit bakerjon's Homepage  Reply with Quote
Looks good to me. Also be sure to check out http://support.microsoft.com/default.aspx?scid=kb;en-us;328551

Jon

Go to Top of Page

JimL
SQL Slinging Yak Ranger

USA
1537 Posts

Posted - 04/06/2005 :  12:59:00  Show Profile  Visit JimL's Homepage  Reply with Quote
quote:
What's with the yak thing?


Us we are s and if you behave yourself you can be one too!

LOL



Jim
Users <> Logic
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts

Posted - 04/06/2005 :  13:59:07  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message  Reply with Quote
Yak, yak, yak



MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

bakerjon
Posting Yak Master

USA
145 Posts

Posted - 04/06/2005 :  14:03:51  Show Profile  Visit bakerjon's Homepage  Reply with Quote
Thanks for answering the question. It's been bugging me for awhile! :)

Now I know, and knowing is half the battle!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48013

Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 04/13/2005 :  16:16:26  Show Profile  Reply with Quote
You may even want to buy a [url=http://www.cafepress.com/sqlteam.328099?zoom=yes#zoom]shirt[/url]



Brett

8-)

Edited by - X002548 on 04/13/2005 16:18:15
Go to Top of Page

JimL
SQL Slinging Yak Ranger

USA
1537 Posts

Posted - 04/13/2005 :  16:25:43  Show Profile  Visit JimL's Homepage  Reply with Quote
Still have mine.
Great Conversation starter.
Starting to get a little faded.
Maybee I will have to get another.

Jim
Users <> Logic
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000