Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

Temp object appear and are locked down by system processes data/lo
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

Report this thread to moderator Post Follow-up to this message
Old Post
thejamie
11-01-06 12:13 AM


Re: Temp object appear and are locked down by system processes data/lo
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



Report this thread to moderator Post Follow-up to this message
Old Post
Aaron Bertrand [SQL Server MVP]
11-01-06 12:13 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 09:20 PM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006