Multiple Tempdb

Hi,
Is it possible to have multiple tempdb on 1 sql server. If
yes please pass on the info.
Thanks in advance.No. But you can relocate TempDB or span it across multiple files on multiple
devices if necessary. This may help with performance or storage management
issues if that is your goal.
Use ALTER DATABASE to add / modify files in TempDB, then restart the server.
--
David Portas
SQL Server MVP
--|||Hi,
What about in Yukon server.
>--Original Message--
>Hi,
>Is it possible to have multiple tempdb on 1 sql server.
If
>yes please pass on the info.
>Thanks in advance.
>.
>|||Not that I'm aware of. Could you explain just what functionality you are
looking for. What could you do with multiple TempDBs that you can't do with
one? How would you want multiple DBs to be used by the server?
--
David Portas
SQL Server MVP
--|||It is possible in Sybase 12.5.1.That's why i wanna know if
it is possible in MS-SQL
>--Original Message--
>Not that I'm aware of. Could you explain just what
functionality you are
>looking for. What could you do with multiple TempDBs that
you can't do with
>one? How would you want multiple DBs to be used by the
server?
>--
>David Portas
>SQL Server MVP
>--
>
>.
>|||> Not that I'm aware of. Could you explain just what functionality you are
> looking for. What could you do with multiple TempDBs that you can't do
with
> one? How would you want multiple DBs to be used by the server?
I think there has been a pretty common request to allow each database to
have its own tempdb. However I don't believe it got any further than the
request stage for SQL Server 2005.
A|||You could install another instance of SQL Server. You would lose though in
available memory as it is likely you would set a maximum for each instance
which would be less than the single instance would have access to.
"Moh" <anonymous@.discussions.microsoft.com> wrote in message
news:408401c4a009$e215b600$a301280a@.phx.gbl...
> Hi,
> Is it possible to have multiple tempdb on 1 sql server. If
> yes please pass on the info.
> Thanks in advance.|||Hi,
Better option will be create the TEMPDB database files which can be spanned
across multiple disk controllers. This will reduce the Disk I/O.
I have written this under the impression that perfomance is the real bottle
neck.
If the performance is the real bottle neck you could:-
1. reduce Order by clause for select statement returns huge results
2. reduce joins and group by
3. reduce usage of temp table
Thanks
Hari
MCDBA
"David Portas" wrote:
> Not that I'm aware of. Could you explain just what functionality you are
> looking for. What could you do with multiple TempDBs that you can't do with
> one? How would you want multiple DBs to be used by the server?
> --
> David Portas
> SQL Server MVP
> --
>
>