Multiple Tempdb

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