SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Query maxing out 24 CPUs

  Hello SQL Performance Experts, I could really use some assistance troubleshooting a long running qu…

  M_E_K

  34 replies

  13 years, 11 months ago

  By: Gail Shaw

• Statistics and

  Got a complain from user that the "drop box" on website takes about 10 seconds, but it only takes …

  awu

  3 replies

  13 years, 12 months ago

  By: spaghettidba

• High CPU/IO

  Hi, I have a third party app Virutal Center which is on a consolidated server. I ran sp_who2 and i…

  TST1

  7 replies

  13 years, 12 months ago

  By: Grant Fritchey

• Reorganize Index - faster when less fragmented?

  I am planning index maintenance on a SQL Server 2005 Enterprise Edition system with some large data…

  April Clough

  8 replies

  14 years ago

  By: SQLBuddy123

• Latch Timeout

  Hi, I'm getting the following error messages due to latch timeouts and need some assistance please:…

  MostInterestingMan

  2 replies

  14 years ago

  By: SQLDBA346

• Perfmon Counters For Poor Performing Data Warehouse

  I'm looking for some expert DBA guidance for tracking down some performance issues (slow running qu…

  davas

  25 replies

  14 years ago

  By: Ninja's_RGR'us

• "Partitioning" a full-text index

  I've run into a situation whereby my full-text index is much slower than a simple LIKE query agains…

  jeffkretz

  2 replies

  14 years ago

  By: jeffkretz

• Index Spool output bigger than input?

  I'm a little confused. I'm using SQL Sentry Plan Explorer and I can't understand how an Index Spool…

  Gary Hines

  3 replies

  14 years ago

  By: Gary Hines

• Performance issue by Checkpoint ?

  Hello All, I was checking the performance of one big query in two alike environments. While in one …

  sqlnaive

  2 replies

  14 years ago

  By: LutzM

• Query degradation

  In our site, we use Business Objects XIR3 to generate reports from an SS2K5 database. Business Obj…

  glenn.coello

  1 replies

  14 years ago

  By: Grant Fritchey

• Index over multiuple columns question

  Hi there, I have a select stateent which goes like this: SELECT TOP 1 * FROM table1 WITH (READUNCOM…

  FreeHansje

  10 replies

  14 years ago

  By: Gail Shaw

• 50 Gb msdb ate disk

  Hello, Our SQL guru is out of town. He was at our office last week helping with the same problem bu…

  juan08

  30 replies

  14 years ago

  By: Johan Bijnens

• deadlock-why select hold an updlock?

  <resource-list> <keylock id="lock8ec3440" associatedObjectId="72057594059882496" mode=…

  fby001_wangdui

  3 replies

  14 years ago

  By: fby001_wangdui

• Need information regarding Indexes

  Hi i have a table A with 4 million records which doesn't have any keys (heap) and when i write a se…

  sam-1083699

  17 replies

  14 years ago

  By: tfifield

• if there is a composite index on three fields, but a query only uses one is the index used?

  lets say there is a composite index on firstname, lastname, and companyid but i have a query that j…

  xgcmcbain

  2 replies

  14 years ago

  By: Gail Shaw