SQL Server Performance

SQL Server 2005 Performance Tuning for DBAs

SQL Server 2005 DBA-related performance tuning questions.

Search this forum
Advanced search...
Page 2 of 27
Sort by:
Title Start Date
Replies Views ↓
Last Message
  1. catchvaas

    SQL server free memory Issue

    catchvaas, Dec 4, 2010
    Replies:
    10
    Views:
    2,170
    Luis Martin
    Dec 10, 2010
  2. jbates99

    How to Know If TEMPDB is Cause Of Slow Performance

    jbates99, Sep 13, 2008
    Replies:
    10
    Views:
    2,164
    madhuottapalam
    Oct 20, 2008
  3. Panik77

    Transaction log file growth during index de-fragmentation

    Panik77, Mar 8, 2009
    Replies:
    4
    Views:
    2,159
    Panik77
    Mar 29, 2009
  4. jstryk

    [solved?] SQL Profiler: Duration?

    jstryk, Apr 24, 2008
    Replies:
    9
    Views:
    2,137
    jstryk
    Apr 25, 2008
  5. sagartathode

    SQL Query taking too long time to execute.

    sagartathode, Oct 26, 2007
    Replies:
    3
    Views:
    2,099
    dineshasanka
    Oct 30, 2007
  6. ashish.johri2007

    transaction rollback in progress

    ashish.johri2007, Mar 15, 2007
    Replies:
    3
    Views:
    1,995
    MohammedU
    Mar 15, 2007
  7. biged1234567

    Error 701-There is insufficient system memory to run this query

    biged1234567, Sep 30, 2008
    Replies:
    5
    Views:
    1,932
    Saurabh Srivastava
    Oct 20, 2008
  8. NewDBA

    How to find out which query blocking other

    NewDBA, Jan 26, 2007
    Replies:
    9
    Views:
    1,931
    MohammedU
    Jan 26, 2007
  9. stekim

    what do you do with slow select sum() queries to speed them up?

    stekim, Aug 6, 2007
    Replies:
    7
    Views:
    1,922
    sqlrunner
    Aug 13, 2007
  10. jr81

    SQL Server restarting itself and closing connections;

    jr81, Apr 9, 2008
    Replies:
    11
    Views:
    1,848
    jr81
    Apr 14, 2008
  11. sqldbarocks

    monitoring cpu,memory,I/O usage with profiler

    sqldbarocks, Jan 17, 2011
    Replies:
    4
    Views:
    1,788
    satya
    Jan 19, 2011
  12. gujsa01

    Wait_type of SLEEP_TASK and SUSPENDED Status

    gujsa01, Jun 10, 2008
    Replies:
    2
    Views:
    1,713
    gujsa01
    Jun 11, 2008
  13. Ankit shah

    Clustered Index Scan Cost 98%...how to reduce ?

    Ankit shah, May 2, 2012
    Replies:
    2
    Views:
    1,686
    FrankKalis
    May 2, 2012
  14. vanirame

    SQL Server 2000 vs 2005 load test

    vanirame, Mar 19, 2007 ... 2
    Replies:
    33
    Views:
    1,657
    mmarovic
    Mar 24, 2007
  15. masqazi

    Sql server 2005 db slow down suddenly - URGENt

    masqazi, Dec 21, 2006
    Replies:
    13
    Views:
    1,610
    joechang
    Dec 26, 2006
  16. DBADave

    Why does Update Stats with SAMPLE take longer then FULLSCAN?

    DBADave, Jan 8, 2009
    Replies:
    8
    Views:
    1,608
    DBADave
    Jan 12, 2009
  17. Mahmoud_H

    which is best replication or log shipping

    Mahmoud_H, Nov 18, 2008
    Replies:
    6
    Views:
    1,549
    Mahmoud_H
    Nov 30, 2008
  18. visa

    Memory Utilization High in Production Server

    visa, Apr 20, 2012
    Replies:
    0
    Views:
    1,539
    visa
    Apr 20, 2012
  19. saikrishna

    log cache hit ratio is less..help me

    saikrishna, Apr 9, 2007
    Replies:
    17
    Views:
    1,533
    Luis Martin
    Apr 9, 2007
  20. Narine

    Memory usage in SQL Server 2005

    Narine, Oct 5, 2007
    Replies:
    5
    Views:
    1,472
    Raulie
    Oct 15, 2007
Showing threads 21 to 40 of 532

Thread Display Options

Loading...
Page 2 of 27