SQL Server Performance

Search Results

Search Again
  1. MrTim

    Memory Leak on SP4

    Thread by: MrTim, Aug 2, 2006, 8 replies, in forum: General DBA Questions
    We have SQL Sever 2000 SP4 (32bit) running on and AMD 64bit server, and around every 2 weeks the server begins to fail and has to be rebooted. We...
  2. MrTim

    Tempdb Table Sizes

    Thread by: MrTim, Jul 27, 2006, 10 replies, in forum: General Developer Questions
    Is is possible to get the sizes and/or number of rows of tables in the tempdb? I can see them in sysobjects, but sp_spaceused returns error 15009...
  3. MrTim

    Deadlocks outside transactions?

    Thread by: MrTim, Aug 15, 2005, 14 replies, in forum: General Developer Questions
    Is it possible to get a deadlock outside transaction? We're occasionally getting them on UPDATEs & DELETEs. I've checked out loads of articles on...
  4. MrTim

    2 identical apps running is more than 5x slower

    Thread by: MrTim, Jul 4, 2005, 3 replies, in forum: Non-Transact SQL Developer Performance Tuning
    We use a 4GL language with SQL 2000 SP3/ODBC. As an example we have a report program which uses a FOREACH cursor to process records and output them...
  5. MrTim

    Database Time-outs

    Thread by: MrTim, Apr 1, 2004, 5 replies, in forum: T-SQL Performance Tuning for Developers
    We're getting problems with our applications hanging and connections to databases timing out. Seems to be locks and in some case we can identify a...
Showing results 1 to 5 of 5
Search Again