SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Estimated Execution Plan - interpreting the results

  Hi all, Having used SQ server daily for many years, I have finally found the need/time to use execu…

  david_h_edmonds

  0 replies

  5 years, 11 months ago

  By: david_h_edmonds

• Deadlock issue

  Hi All,I am going through a strange issue. We have a very simple file processing system with users …

  sqlenthu 89358

  5 replies

  6 years ago

  By: mig28mx

• Very erratic performance in last few days.

  I apologize for such a general question, and there is not enough info for a detailed answer, but AN…

  jay-h

  6 replies

  6 years, 4 months ago

  By: mig28mx

• Set Maxdop = 8 and cost threshold for paralelism = 15

  Hi all,I recently changed CTFP=15 on my producion server. Why I use that number and not the 50 rule…

  mig28mx

  3 replies

  6 years, 4 months ago

  By: Sue_H

• Index Checker and Fragmentation - Duplicate INDEX name

  Hello: How is it possible to get the SAME index name for the SAME table but the Index ID is differe…

  dtran1127

  2 replies

  6 years, 5 months ago

  By: Lynn Pettis

• Weird performance issue.

  Hi all,I don´t know if the subject it is correctly named, because all performance issue it is weir…

  mig28mx

  2 replies

  6 years, 6 months ago

  By: mig28mx

• Is auto update statistics good For OLTP

  Hi, I wanted to know if setting Auto Update Statitics to TRUE will be good for OLTP environment. Mi…

  saum70

  2 replies

  6 years, 6 months ago

  By: saum70

• Non Clustered Index on Phone column

  Dear All,I have a Lead table with below fields.LeadId int (Not a primary key)Telephone......Table&n…

  sunilkmr284

  23 replies

  6 years, 7 months ago

  By: drew.allen

• Help improving performance of a query

  The following query takes somewhere between 30 to 35 seconds to complete.  Can something be do…

  Lisa Cherney

  7 replies

  6 years, 8 months ago

  By: Chris Harshman

• Query taking more time

  Dear All, I have a table and it just have 34K rows in it. I have a non clustered index on a date co…

  haichells

  9 replies

  6 years, 10 months ago

  By: Jeff Moden

• Execution plan missing.

  Hi all.Recently I have found with the help of one of the Bent Ozar, scritps. One called spBlitzCach…

  mig28mx

  5 replies

  6 years, 11 months ago

  By: Gail Shaw

• Column alias in order by working in sql server 2008R2 but intermittently

  Dear Folks My below query was working fine before 2 days at my prod environment (SQL Server 2008 R2…

  anujkumar.mca

  2 replies

  6 years, 11 months ago

  By: Emperor100

• Replica of Store Procedure taking more time

  Hi All,I have optimized one store procedure. Original is taking 35 seconds to take data and new SP …

  anoop.mehra

  1 replies

  6 years, 12 months ago

  By: Eirikur Eiriksson

• Extremely slow SQL server

  HI allI am not much of a DBA but find myself in a situation where I need to learn really fast. We h…

  troys

  15 replies

  7 years ago

  By: Sergiy

• Transaction Log backu job sometimes fails with erooror: There is insufficient system memory in resource pool 'internal' to run this query.

  Hi We run SQL Server 20008R on Windows Server 2008R on HyperVWindows Machine is dedicated to run S…

  Svetlana Mikhalevskaya

  6 replies

  7 years, 1 month ago

  By: Sue_H