Re: Moving tempdb

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

  • Lost Permissions after Rebooting Server
    ... databases including tempdb. ... But is happens to non tempdb databases. ... Recently the server was rebuilt from 2K to 8K pages. ... Seems like every sucessive reboot, ...
    (comp.databases.sybase)
  • Re: How can I shrink my TempDB Databse?
    ... > importing data into one of my databases in same server. ... > How can I shrink my TempDB Databse? ...
    (comp.databases.ms-sqlserver)
  • How can I shrink my TempDB Databse?
    ... importing data into one of my databases in same server. ... How can I shrink my TempDB Databse? ...
    (comp.databases.ms-sqlserver)
  • Re: RAID Setup (RAID 1 with RAID 10)
    ... faster DATA array for SQL. ... Depending on how much your tempdb is being used, you could also gain some performance by putting this on it's own array. ... If you backup your databases to a disk on the server, it's also highly recommended to have this on a separate array. ...
    (microsoft.public.sqlserver.setup)
  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)