Re: Temp object appear and are locked down by system processes dat

Aaron,
Result of the query you have given me:
-------------------------------
tempdev  xx:\Program Files\Microsoft SQL  Server\MSSQL\data\te
mpdb.mdf
templog xx:\Program Files\Microsoft SQL  Server\MSSQL\data\te
mplog.ldf
tempdb_1_Data  xx:\Data\Temp2

tempdb_2_Data xx:\Data\Temp3

tempdb_3_Data  xx:\Data\Temp4

tempdb_4_Data
xx:\Data\Temp5

tempdb_5_Data
xx:\Data\Temp6

tempdb_6_Data
xx:\Data\Temp7

tempdb_7_Data
xx:\Data\Temp8

tempdb_9_Data
xx:\Data\Temp9

tempdb_10_Data
xx:\Data\Temp10

tempdb_1_Log
x:\Logs\Temp2

tempdb_2_Log
x:\Logs\Temp3

tempdb_3_Log
x:\Logs\Temp4

tempdb_4_Log
x:\Logs\Temp5

tempdb_5_Log
x:\Logs\Temp6

tempdb_6_Log
x:\Logs\Temp7

tempdb_7_Log     x:\Logs\Temp8

tempdb_8_Log
x:\Logs\Temp9

tempdb_9_Log x:\Logs\Temp1-
ReportServerTempDB   xx:\Data\\ReportServ
erTempDB.mdf
 ReportServerTempDB_l
og  x:\Logs\\ReportServe
rTempDB_log.LDF
--
Regards,
Jamie


"Aaron Bertrand [SQL Server MVP]" wrote:

> Anything correlated to these files from:
>
> SELECT [name], [filename]
> FROM master..sysaltfiles
> WHERE filename LIKE '%temp%';
>
>
>
>
>
>
> "thejamie" < thejamie@discussions
.microsoft.com> wrote in message
> news:242A9684-FEC4-4922-9AFB- CBC6EFDC0C2C@microso
ft.com... 
>
>
>

So, you are creating these additional filesfor tempdb because you added the
files using ALTER DATABASE (or through the GUI).  They are meant to be there
as far as the system is concerned, but why, I'm not sure.  Anyway, I doubt
this specifically is causing any performance issues unless all the files are
really, really small.




"thejamie" < thejamie@discussions
.microsoft.com> wrote in message
news:2169BF13-671A-4E23-8770- 4E312DF223AA@microso
ft.com...
> Aaron,
> Result of the query you have given me:
> -------------------------------
> tempdev  xx:\Program Files\Microsoft SQL  Server\MSSQL\data\te
mpdb.mdf
> templog xx:\Program Files\Microsoft SQL  Server\MSSQL\data\te
mplog.ldf
> tempdb_1_Data  xx:\Data\Temp2
>
> tempdb_2_Data xx:\Data\Temp3
>
> tempdb_3_Data  xx:\Data\Temp4
>
> tempdb_4_Data
>                                  xx:\Data\Temp5
>
> tempdb_5_Data
>                                  xx:\Data\Temp6
>
> tempdb_6_Data
>                                  xx:\Data\Temp7
>
> tempdb_7_Data
>                                  xx:\Data\Temp8
>
> tempdb_9_Data
>                                  xx:\Data\Temp9
>
> tempdb_10_Data
>                                 xx:\Data\Temp10
>
> tempdb_1_Log
>                                  x:\Logs\Temp2
>
> tempdb_2_Log
>                                  x:\Logs\Temp3
>
> tempdb_3_Log
>                                  x:\Logs\Temp4
>
> tempdb_4_Log
>                                  x:\Logs\Temp5
>
> tempdb_5_Log
>                                 x:\Logs\Temp6
>
> tempdb_6_Log
>                                  x:\Logs\Temp7
>
> tempdb_7_Log     x:\Logs\Temp8
>
> tempdb_8_Log
>                                  x:\Logs\Temp9
>
> tempdb_9_Log x:\Logs\Temp1-
> ReportServerTempDB   xx:\Data\\ReportServ
erTempDB.mdf
>  ReportServerTempDB_l
og  x:\Logs\\ReportServe
rTempDB_log.LDF
> --
> Regards,
> Jamie
>
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
> 

Not sure how I managed to create these additional files.  Was there somethin
g
I physically did to cause them to appear?
--
Regards,
Jamie


"Aaron Bertrand [SQL Server MVP]" wrote:

> So, you are creating these additional filesfor tempdb because you added th
e
> files using ALTER DATABASE (or through the GUI).  They are meant to be the
re
> as far as the system is concerned, but why, I'm not sure.  Anyway, I doubt
> this specifically is causing any performance issues unless all the files a
re
> really, really small.
>
>
>
>
> "thejamie" < thejamie@discussions
.microsoft.com> wrote in message
> news:2169BF13-671A-4E23-8770- 4E312DF223AA@microso
ft.com... 
>
>
>

thnks - we had a portal server dying...  just coincidental that these files
appeared...
--
Regards,
Jamie


"thejamie" wrote:

> Not sure how I managed to create these additional files.  Was there someth
ing
> I physically did to cause them to appear?
> --
> Regards,
> Jamie
>
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>