Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesWe 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
Post Follow-up to this messageAnything 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
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread