Re: Moving tempdb

Also what RAID level should I give the LUN? I assume RAID 1 would be better
than RAID 5. Should I also create another LUN for the tempdb logs? Or can I
keep the data & log files on the same drive?

"AJ" wrote:

there are two databases on the server that are being used. Once is about
11GB and the other is about 25GB.

I also have another server running a database about 16GB in size.

Your suggestions are greatly appreciated.

thx.

"Kevin3NF" wrote:

There's no magic formula, since your code may change how, and how much
tempdb is used. I would go at least 10gb for any LUN, regardless of purpose
unless you know for a fact that there is an upper bound.

How much data do you have in your user databases?

--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.



"AJ" <AJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:26BE098D-2ACB-4B5D-99C1-C19C9AC85EB0@xxxxxxxxxxxxxxxx
Hello,

I'm planning on moving our tempdb to it's own LUN but I'm not sure what
size
the LUN needs to be. Currently the tempdb is just over 1GB in size. I
was
planning on creating a LUN with a size of 5GB. Is this too small? Or
should
I increase the size?
How exactly would you determine what size your tempdb might grow to?

thx.

-Albert-



.

Relevant Pages

  • Re: Moving tempdb
    ... Anything but Raid 5 or a single ... SQL Server dude ... Should I also create another LUN for the tempdb logs? ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving tempdb
    ... I would go at least 10gb for any LUN, regardless of purpose ... I'm planning on moving our tempdb to it's own LUN but I'm not sure what ...
    (microsoft.public.sqlserver.setup)
  • Moving tempdb
    ... I'm planning on moving our tempdb to it's own LUN but I'm not sure what size ... the LUN needs to be. ... Currently the tempdb is just over 1GB in size. ...
    (microsoft.public.sqlserver.setup)
  • Re: Max recommened SAN disk size
    ... will be an issue then you'll want to factor in your raid mode Raid 10 vs Raid ... There is much more to consider than just LUN size. ... volume with 10,000,000 files & dirs is going to take much, ... and with restores, small files are the ultimate bandwidth ...
    (microsoft.public.windows.file_system)
  • Re: kernel recognizing large (> 2.1 TB) block devices ?
    ... When I configure the RAID as a full 4.8TB LUN, the kernel ... You can try a LSI controller and see what happens or you can create ...
    (Fedora)
Loading