SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• SQL2005 32bit Standard AWE switch?

  I have a W2003 Standard server w/SQL2005 standard on it. The server has 8gb of ram but when I was …

  ashevis

  6 replies

  14 years, 5 months ago

  By: ashevis

• Create Cluster Index utilizing single processor

  I have a load process that creates a cluster index over a 10gb table with 160m rows. The create i…

  Ed Klein-385786

  13 replies

  14 years, 5 months ago

  By: george sibbald

• Best approach - XQuery Vs sp_xml_preparedocument

  Hi I work in a company that provides an online service for the purchase of materials trough the int…

  rui.f.lourenco

  4 replies

  14 years, 5 months ago

  By: m.talha86

• What are ther steps need to take when we need to tune the stored procedure

  Hi All, What are ther steps need to take when we need to tune the stored procedure. Ex : need to ch…

  deepak.a

  10 replies

  14 years, 5 months ago

  By: deepak.a

• SQL Server 2005 indexed view for non-unique column

  I have a view inner joined 3 tables with no aggregate in it. The view is used for search by lastnam…

  chung_y1

  6 replies

  14 years, 5 months ago

  By: Gail Shaw

• I need to get the values from a Parameterized Query

  Good Morning, I'm looking to do some performance tuning on the query listed below. My issue is that…

  Dale Cunningham

  4 replies

  14 years, 5 months ago

  By: Dale Cunningham

• Measuring CPU and Memory usage

  Hi, wondered if I could get some advice on measuring and interpreting cpu and memory usage? I've b…

  YaHozna

  2 replies

  14 years, 5 months ago

  By: YaHozna

• querying a table with xml deadlock graphs

  Hi there! I have a table of a few months worth of xml deadlock graphs. Would anyone know if it's p…

  MissPukeyCow

  4 replies

  14 years, 5 months ago

  By: MissPukeyCow

• Page Faults

  Seeing high level of page faults/sec with little or no pages/sec. Page faults averaging @ 2000/sec…

  sqlagentman

  4 replies

  14 years, 5 months ago

  By: MyDoggieJessie

• When is a execution plan recreated and are the multiple plans?

  When a stored procedure is altered, does the execution for the stored procedure become invalid and …

  LeeFAR

  12 replies

  14 years, 5 months ago

  By: TheSQLGuru

• Query times out from application

  I run a stored procedure from SSMS and it takes only 10ms to complete. The same procedure when call…

  Sanz

  5 replies

  14 years, 5 months ago

  By: Sanz

• SQL server 2008 SP1 performance slow in Windows server 2008 r2

  Hi All, We have recently upgraded the OS from windows sever 2008 to windows sever 2008 R2. The appl…

  rkarmarkar

  2 replies

  14 years, 5 months ago

  By: Erik Quist-331296

• Are Heaps Fragmented by Default

  Hello, i've done some research in BOL and other websites, but no where can I find an answer to my q…

  nawillia

  24 replies

  14 years, 5 months ago

  By: SQLRNNR

• Reorg 1 Particular Index in a table

  Hi Is it possible to reorganise 1 particular index in a table, or is it a all or nothing situation.…

  Bobby Glover

  3 replies

  14 years, 5 months ago

  By: Bobby Glover

• Long running query causing disconnections and long waiting time

  Hi everyone, i hope this is the correct forums that i am posting in. Currently, i have a stored pro…

  Conray

  4 replies

  14 years, 5 months ago

  By: TheSQLGuru