My company's SQL Server is crashing every three days. The DBA is
saying that this is because the TempDB (used internally by the
server) is not being cleaned up due to open queries from my
Delphi/BDE applications. This doesn't make sense to me because I've
worked with client/server systems which have many open queries (both
live and non-live) and do not cause the server to crash.

Can anyone shed some light on this? Could it be the SQL Server is not
configured properly?

TIA,

Douglas

Douglas,

   Without knowing the "crash", I disagree with your DBA.  Do you receive
an error (what is the error)?  Does the server lock up?  Is TempDB in RAM
or on disk?  Is the transaction log large enough to handle your queries?.
If your DBA is correct about TempDB filling up, you may suggest increasing
TempDB and/or placing it on disk.  

Good luck,
krf

Douglas Macnguyen <douglas_macngu...@electrostar.com> wrote in article
<01bd59e8$95e8f940$82da6...@tycoing.electrostar.com>...

  I've had a similar problem- the server never crashed, but it would lock
users out and SQL server had to be stopped and restarted.  Many users
running queries with order by or without covering indexes will need a large
tempdb.  Make sure that your application is not holding queries open that
don't need to be open- ie: if a form is open, but not visible.  Also,  check
that the 'Truncate Log on Checkpoint' option is set (unless you're actually
dumping the transaction log)