--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
Please join me at PASS North America in Denver - the first and only user
conference dedicated to SQL Server.
http://www.sqlpass.org/events/denverjan/index.cfm
Quote:> Every so often (periodicity is about 1 to 2 hours) SQL
> Server 2000 takes all the system resources and seems to
> be doing a lot of work on the drive. The upshot of this
> is we can do nothing on the server for several minutes
> while the server is busy with this unknown task. Has
> anybody got an idea as to what is causing this.
How do the following programs track transactions if a system locks up
Access, VBA, SQL
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
2. Multidimensional query involving ranges
4. Calculation Question: is there a "field contains" function?
5. Version 6.5 lock ups...........
10. Problem with Sybase and PowerBuilder (Lock-ups!)
12. P4W 5.0: Keyboard/Mouse Partial Lock-ups
13. Paradox 4.5 Dos - Multi User Lock ups