SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• SQL Server stops responding

  From time to time... 2min - 15min the SQL server will stop responding... In Management studio this …

  dwilliscp

  8 replies

  11 years, 10 months ago

  By: dwilliscp

• Session with a high CPU (ms) but no waits---does that matter?

  I am using Idera's SQL diagnostic manager. It is throwing an alert saying a session has a high CPU …

  Maxer

  1 replies

  11 years, 10 months ago

  By: Erland Sommarskog

• How to measure physical disk activity ?

  I am setting up a new server (Windows Server 2008 R2) to run a SQL Server (2012) and IIS (7.5) base…

  Alan Spillert

  6 replies

  11 years, 10 months ago

  By: Alexander Suprun

• Deadlock via SELECT INTO query getting a SIU lock

  i'm trying to resolve a deadlock issue between a SELECT INTO query and an UPDATE query. UPDATE tab…

  tom_ciolek 89611

  3 replies

  11 years, 10 months ago

  By: tom_ciolek 89611

• Dead Lock Issue

  Hi All I've been asked to look into a dead lock issue and I don't have access to the server so I wa…

  MartJ

  5 replies

  11 years, 10 months ago

  By: MartJ

• Slow response Query

  In my server there is a specific query which was running 3 sec.Suddenly query was running slow. I c…

  Thamizh

  9 replies

  11 years, 10 months ago

  By: MartJ

• Stored procedure runs very slow or times out

  Hi, Help! I am new to SQL... The SP below times out with certain parm and is very slow at other ti…

  oc_researcher

  3 replies

  11 years, 10 months ago

  By: oc_researcher

• Haistory Data Comparision.

  Question :1 Server : sql server 2008 R2 a) I have "prestaging" table as source table. b) I kept wor…

  anandj 74765

  1 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• NC Index Seek 51% and select cost 0%?

  Hi, what could be issues, select command taking 50 sec for result.. as per actual Exec.plan dispaly…

  SQL Galaxy

  17 replies

  11 years, 11 months ago

  By: Gail Shaw

• Index Fragmentation

  Hi, I am not sure why the index fragmentation for a particular index never decreases, even after re…

  aamod 29500

  4 replies

  11 years, 11 months ago

  By: aamod 29500

• Create Primary key Vs Add primary key (Composite)

  Can anybody explain . why i am getting better Plan when add primary key to table. for 2nd left key…

  Neeraj Prasad Sharma

  5 replies

  11 years, 11 months ago

  By: Gail Shaw

• Stored proc randomly runs really, really slowly

  Hi all, I will keep this as simple as I can despite the complexities. I'm looking for a strategy r…

  webtekkie

  2 replies

  11 years, 11 months ago

  By: Fraggle-805517

• Poor performing query on

  Hi all, been pulling my hair out today. We have a set of HR databases that currently live on 3 diff…

  cunningham

  15 replies

  11 years, 11 months ago

  By: Jeff Moden

• sys.dm_db_missing_index_details

  Hi I ran missing_index_details dmv to find out missing indexes on a db. results shows equality col…

  kkarthik117

  1 replies

  11 years, 11 months ago

  By: Gail Shaw

• Query plan changes over time, query performance severely impacted

  Hi all, I have a query that takes 2 seconds to compile and run (first time round) when the server i…

  cunningham

  11 replies

  11 years, 11 months ago

  By: cunningham