MS SQL Server - Re: Temp object appear and are locked down by system processes dat

Author

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

thejamie

2006-10-31, 7:13 pm

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

Aaron Bertrand [SQL Server MVP]

2006-10-31, 7:13 pm

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...[color=darkred]
> 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:
>

thejamie

2006-10-31, 7:13 pm

Not sure how I managed to create these additional files. Was there something
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 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...
>
>
>

thejamie

2006-10-31, 7:13 pm

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

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

Sponsored Links