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. 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
  2. joechang

    What to do if your SQL Server system is slow

    Sticky
    joechang, Feb 16, 2007
    Replies:
    12
    Views:
    15,613
    Luis Martin
    Jun 26, 2012
  3. 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
  4. Dale L

    [Solved]Trace using a script

    Dale L, Jun 14, 2007
    Replies:
    4
    Views:
    209
    satya
    Jun 19, 2007
  5. Dale L

    [Solved]Automating the "Database tuning Advisor"

    Dale L, Jun 14, 2007
    Replies:
    4
    Views:
    216
    MohammedU
    Jun 15, 2007
  6. jstryk

    [solved?] SQL Profiler: Duration?

    jstryk, Apr 24, 2008
    Replies:
    9
    Views:
    2,126
    jstryk
    Apr 25, 2008
  7. harout

    XML vs Relational

    harout, Dec 14, 2005
    Replies:
    3
    Views:
    418
    FrankKalis
    Dec 17, 2005
  8. shark68

    Writelog waits

    shark68, Oct 11, 2007
    Replies:
    3
    Views:
    460
    Greg Larsen
    Oct 12, 2007
  9. Jack Vamvas

    write intensive architecture

    Jack Vamvas, May 28, 2007
    Replies:
    4
    Views:
    286
    Jack Vamvas
    May 29, 2007
  10. sqlwars

    Will VIEW improve performance

    sqlwars, Apr 20, 2010
    Replies:
    2
    Views:
    882
    satya
    Apr 21, 2010
  11. gavin

    why update one row is so slow?

    gavin, Aug 10, 2007
    Replies:
    13
    Views:
    2,930
    satya
    Aug 29, 2007
  12. EMoscosoCam

    Why the IP address is not displayed on the Activity Monitor?

    EMoscosoCam, Feb 29, 2008
    Replies:
    1
    Views:
    343
    satya
    Mar 3, 2008
  13. waqar

    Why speed is slow with these indexes

    waqar, Jun 22, 2007
    Replies:
    7
    Views:
    269
    Dale L
    Jul 11, 2007
  14. abbi

    Why is it using the Index

    abbi, Mar 2, 2008
    Replies:
    8
    Views:
    257
    ScottPletcher
    Mar 4, 2008
  15. DBADave

    Why does Update Stats with SAMPLE take longer then FULLSCAN?

    DBADave, Jan 8, 2009
    Replies:
    8
    Views:
    1,591
    DBADave
    Jan 12, 2009
  16. ryanwatton

    Why does this SQL slow down or hang?????

    ryanwatton, Jul 26, 2006
    Replies:
    14
    Views:
    608
    ryanwatton
    Aug 1, 2006
  17. DBADave

    Why does DMV report AWE memory allocation when AWE is not enabled - 64bit?

    DBADave, Dec 29, 2008
    Replies:
    6
    Views:
    571
    DBADave
    Jan 9, 2009
  18. fraparty

    Which query or SP is using the most CPU?

    fraparty, May 14, 2007
    Replies:
    3
    Views:
    349
    satya
    May 15, 2007
  19. Mahmoud_H

    which is best replication or log shipping

    Mahmoud_H, Nov 18, 2008
    Replies:
    6
    Views:
    1,527
    Mahmoud_H
    Nov 30, 2008
  20. pvmilreu

    Where clause is decreasing performance

    pvmilreu, Jan 12, 2007
    Replies:
    5
    Views:
    431
    madhuottapalam
    Jan 15, 2007
  21. w84me2say

    Where and when to use userdefined functions (scalar)

    w84me2say, Oct 26, 2007
    Replies:
    1
    Views:
    157
    MohammedU
    Oct 26, 2007
  22. Steph2004

    What's the best way to create à clustered index?

    Steph2004, Aug 20, 2008
    Replies:
    1
    Views:
    211
    preethi
    Aug 20, 2008
  23. stekim

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

    stekim, Aug 6, 2007
    Replies:
    7
    Views:
    1,896
    sqlrunner
    Aug 13, 2007
Showing threads 1 to 20 of 532

Thread Display Options

Loading...
Page 1 of 27