SQL Server Performance

SQL Server 2005 Performance Tuning for DBAs

SQL Server 2005 DBA-related performance tuning questions.

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

    What to do if your SQL Server system is slow

    Sticky
    joechang, Feb 16, 2007
    Replies:
    12
    Views:
    15,594
    Luis Martin
    Jun 26, 2012
  2. joechang

    What to do if a specific query is slow or erratic

    Sticky
    joechang, Feb 16, 2007
    Replies:
    3
    Views:
    858
    joechang
    Feb 20, 2007
  3. admin

    [Forum Closed] - Please Post all Questions in the SQL Server Questions Forum

    Locked Sticky
    admin, Nov 24, 2011
    Replies:
    0
    Views:
    225
    admin
    Nov 24, 2011
  4. Rabani

    Transaction log file space usage check

    Rabani, Mar 8, 2009
    Replies:
    9
    Views:
    9,306
    satya
    May 9, 2011
  5. Eric72

    How to split 400GB database into multiple data files

    Eric72, Mar 7, 2008
    Replies:
    13
    Views:
    8,677
    satya
    Jul 8, 2009
  6. sridevi kodali

    Could not continue scan with nolock Due to data movement

    sridevi kodali, Oct 4, 2011
    Replies:
    2
    Views:
    6,553
    satya
    Oct 17, 2011
  7. Trev256

    CPU Usage high

    Trev256, Jan 14, 2010
    Replies:
    10
    Views:
    6,109
    Jahanzaib
    May 29, 2011
  8. Michael Kansky

    Solved high CPU issue but a little confused

    Michael Kansky, Aug 31, 2011
    Replies:
    5
    Views:
    5,540
    satya
    Sep 28, 2011
  9. Rlaubertsr

    Full Scans/Sec.

    Rlaubertsr, May 14, 2008
    Replies:
    4
    Views:
    4,338
    MichaelB
    May 15, 2008
  10. entela

    Linked Server

    entela, Feb 2, 2007
    Replies:
    15
    Views:
    3,726
    satya
    Jun 25, 2007
  11. DBADave

    Best way to add data files to existing database?

    DBADave, Jan 27, 2009
    Replies:
    4
    Views:
    3,484
    Elisabeth Redei
    Jan 29, 2009
  12. DBADave

    Procedure Cache Hit Ratio is Low - Need Advice

    DBADave, Mar 18, 2008
    Replies:
    7
    Views:
    3,416
    SQLDBcontrol
    Mar 20, 2008
  13. pradepravindran

    DBCC Memory status output.

    pradepravindran, Jun 17, 2008
    Replies:
    6
    Views:
    3,234
    satya
    Jun 18, 2008
  14. kdefilip

    Very slow query with many sp_cursorfetch

    kdefilip, Jun 4, 2007
    Replies:
    8
    Views:
    3,156
    satya
    May 3, 2011
  15. gavin

    why update one row is so slow?

    gavin, Aug 10, 2007
    Replies:
    13
    Views:
    2,926
    satya
    Aug 29, 2007
  16. joerattz

    Insert in large table sometimes takes too long

    joerattz, May 5, 2009
    Replies:
    2
    Views:
    2,740
    joerattz
    May 6, 2009
  17. vanantharaman

    Buffer cache hit ratio

    vanantharaman, Apr 9, 2008
    Replies:
    5
    Views:
    2,684
    satya
    Jul 8, 2008
  18. wkm1925

    Clustered Index Scan vs Clustered Index Seek

    wkm1925, Jan 27, 2010
    Replies:
    3
    Views:
    2,675
    preethi
    Jan 27, 2010
  19. JerrySommerville

    Drop and Recreate all indexes

    JerrySommerville, Oct 20, 2006
    Replies:
    7
    Views:
    2,633
    satya
    Nov 23, 2006
  20. tfeldman

    Page Life Expectancy

    tfeldman, Feb 25, 2009
    Replies:
    2
    Views:
    2,610
    thilina
    Feb 26, 2009
  21. Narine

    Error: 8623, Severity: 16, State: 1 The query processor ran out of internal resources and could not produce a query plan

    Narine, Feb 5, 2008
    Replies:
    8
    Views:
    2,605
    Adriaan
    Dec 3, 2009
  22. suvresh

    problem with sys.dm_db_index_physical_stats

    suvresh, Jan 30, 2008
    Replies:
    8
    Views:
    2,539
    anurag.er@gmail.com
    Oct 23, 2008
  23. pl800

    improve performance of an update query

    pl800, Sep 1, 2011
    Replies:
    6
    Views:
    2,532
    preethi
    Sep 8, 2011
Showing threads 1 to 20 of 532

Thread Display Options

Loading...
Page 1 of 27