|
Home > Archive > MS SQL Server > October 2006 > Temp object appear and are locked down by system processes data/lo
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Temp object appear and are locked down by system processes data/lo
|
|
| thejamie 2006-10-31, 7:13 pm |
| We restarted the service instead of rebooting the server. Temp1, Temp2, ...
Temp10 appeared in the log folder file and in the data folder file -
identical names, bigger in the data folder. We can't see what is in them -
they are locked down by the system. Anyone know what it might be? Symptoms
are - system sluggish - lots of timeouts - occasional deadlocks that require
a server reboot to resolve. Symptoms reappear after about 3 hours.
--
Regards,
Jamie
| |
| Aaron Bertrand [SQL Server MVP] 2006-10-31, 7:13 pm |
| 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...
> We restarted the service instead of rebooting the server. Temp1, Temp2,
> ...
> Temp10 appeared in the log folder file and in the data folder file -
> identical names, bigger in the data folder. We can't see what is in
> them -
> they are locked down by the system. Anyone know what it might be?
> Symptoms
> are - system sluggish - lots of timeouts - occasional deadlocks that
> require
> a server reboot to resolve. Symptoms reappear after about 3 hours.
> --
> Regards,
> Jamie
|
|
|
|
|