SQL2K - New Install... - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL2K - New Install...

Author

Topic

Steve@3717
Starting Member

7 Posts

Posted - 2005-04-05 : 15:01:42

... 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

38200 Posts

Posted - 2005-04-05 : 17:34:35

When you say log files, do you mean transaction log files? If so, then those should be on the SAN as well.

Tara

Steve@3717
Starting Member

7 Posts

Posted - 2005-04-05 : 17:41:33

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...

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-04-05 : 20:09:32

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.

Steve@3717
Starting Member

7 Posts

Posted - 2005-04-06 : 09:13:57

Hey Derrick... Thank you very much for the follow-up. Looks like I'm going to need more drives.

Steve.

bakerjon
Posting Yak Master

145 Posts

Posted - 2005-04-06 : 09:42:41

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?

Steve@3717
Starting Member

7 Posts

Posted - 2005-04-06 : 10:21:44

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. . ..

bakerjon
Posting Yak Master

145 Posts

Posted - 2005-04-06 : 10:58:33

Looks good to me. Also be sure to check out http://support.microsoft.com/default.aspx?scid=kb;en-us;328551

Jon

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-04-06 : 12:59:00

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

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-04-06 : 13:59:07

Yak, yak, yak

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

bakerjon
Posting Yak Master

145 Posts

Posted - 2005-04-06 : 14:03:51

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

X002548
Not Just a Number

15586 Posts

Posted - 2005-04-13 : 16:16:26

You may even want to buy a [url=http://www.cafepress.com/sqlteam.328099?zoom=yes#zoom]shirt[/url]

Brett

8-)

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-04-13 : 16:25:43

Still have mine.
Great Conversation starter.
Starting to get a little faded.
Maybee I will have to get another.

Jim
Users <> Logic

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources