SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Queries generated by Lock waits of past time

  The issue occurred last week on 9/9/2013. First email received at 1:20pm EST. Last email received a…

  Sgar...

  2 replies

  11 years, 11 months ago

  By: Sgar...

• Primary Key and Clustered Index: how to set in this example?

  hi there, hope it's the right forum 😉 I have an example where I am not sure about setting my primar…

  WolfgangE

  4 replies

  11 years, 11 months ago

  By: Bhuvnesh

• urgent help with stored procedure performance tuning

  I have a stored procedure to do the performance tuning, so below are the list of questions could so…

  Lucky9

  8 replies

  11 years, 11 months ago

  By: MadAdmin

• Server Side trace for Blockings not working as expected!!

  Hi All, I wanted to check if there has been any blockings on my database and I am using the below s…

  rollercoaster43

  4 replies

  11 years, 11 months ago

  By: Erland Sommarskog

• Work Files / Min Increased almost 10 fold.

  Hello. I was making some minor changes to indexes the other day. The next day I noticed our Work F…

  David Lafayette

  2 replies

  11 years, 11 months ago

  By: Erland Sommarskog

• out to find where is the problem in a stored procedure

  Hi, I'm noticing very low Page Life expectancy <5 mins very frequently when ever a stored proced…

  gary1

  1 replies

  11 years, 12 months ago

  By: Erland Sommarskog

• script to find top queries for physical IO usage

  Can please provide a script to find the top queries for physical IO usage?

  gary1

  1 replies

  11 years, 12 months ago

  By: Gail Shaw

• Rebuild/Reorg Indexes (meaning of index_level in sys.dm_db_index_physical_stats)

  Hello, I have been capturing index fragmentation statistics for one of our databases for few wee…

  guru2007

  2 replies

  11 years, 12 months ago

  By: guru2007

• What is the difference between sp_who2 and sp_whoisactive which one is better

  Hi all, What is the difference between sp_who2 and sp_whoisactive which one is better i have found …

  naga.rohitkumar

  4 replies

  12 years ago

  By: Erland Sommarskog

• Moving to new servers

  We are moving our databases from some virtual servers to physical servers. There are numerous diffe…

  BigSam

  6 replies

  12 years ago

  By: Michael Valentine Jones

• intermittment slow data modification on sql 2008 r2

  Hi Folks, I am working with sql server 2008 r2 standard (build 10.50.4000) Occasionally (not all th…

  djordan 4543

  18 replies

  12 years ago

  By: Erland Sommarskog

• Query tuning performance

  how can we get execution plan of a query executed on two different days so that i come to know that…

  maneeshkrverma

  1 replies

  12 years ago

  By: HanShi

• UPDATE Query gets stuck as a part of the procedure but completes fine when run independently

  One of the update query which updates a column after joining records from seven tables gets stuck i…

  friends.aadi

  2 replies

  12 years ago

  By: Erland Sommarskog

• Cost in Execution Plan summing up more than 100

  Hello All, In rare cases, I saw some strange behaviour in the execution plan. What I believe is tha…

  sqlnaive

  4 replies

  12 years ago

  By: sqlnaive

• Question related to missing index DMV's ?

  This formula is given by microsoft to find out the index performance impact "user_seeks * avg_tota…

  Shadab Shah

  4 replies

  12 years ago

  By: Gail Shaw