SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Improving the performance of a Big table

  I am newbie in Performance tunning. I am trying my hands on PT. If you are given a very large table…

  Shadab Shah

  14 replies

  11 years, 3 months ago

  By: Koen Verbeeck

• Basic about Index statistics

  Just run into 2 contrary articles, where one says the Index Statistics are Updated when the index i…

  Shadab Shah

  2 replies

  11 years, 3 months ago

  By: Shadab Shah

• Slowness on a cluster.

  Good morning all, I am not sure whether this belongs in this forum. Let me preface this by saying I…

  mbricker 81885

  1 replies

  11 years, 3 months ago

  By: Erland Sommarskog

• sys.dm_exec_sessions - High CPU

  Hi I'm trying to work out which sessions are using the highest amount of CPU, this must be via scri…

  wak_no1

  10 replies

  11 years, 3 months ago

  By: Erland Sommarskog

• Join of Function or Join of View, which one is cost effective?

  Hi, I have a table "Table1" on which I want to apply a join. I have two options. Option1: Create a …

  Paresh MD

  4 replies

  11 years, 3 months ago

  By: Paresh MD

• MemoryUtilization - A significant part of sql server process memory has been paged out

  Hi Everyone, I'm sure most of us have seen this message in the SQL Server Logs: "A significant part…

  Andy sql

  7 replies

  11 years, 3 months ago

  By: Andy sql

• Slow performance on a very small SP that updates a very small table

  Hi, I have a strange problem that pops up on a few production sites from time to time and hope I co…

  RandomStream

  9 replies

  11 years, 3 months ago

  By: Jeff Moden

• Performance difference between using a transaction and not using a transaction

  One of our developers was trying to help me troubleshoot a query timeout problem and he ran into a …

  RandomStream

  7 replies

  11 years, 3 months ago

  By: TomThomson

• Query is slow from stored procedure but faster outside the procedure

  I have a query that joins 3-4 tables out of which there are 2 temp tables. It is a simple join quer…

  praveen_vejandla

  7 replies

  11 years, 3 months ago

  By: praveen_vejandla

• Indexing a Geography field and making SQL use the index

  The data set I'm using is UK PBF data from Openstreetmap (http://download.geofabrik.de/europe.html)…

  Wayne Evans-440401

  2 replies

  11 years, 3 months ago

  By: duncanburtenshaw

• PerfMon 'unable to connect to machine'

  I've been trying to follow Brent Ozar's PerfMon tutorial[/url] as recommended on this site, but it …

  Beatrix Kiddo

  4 replies

  11 years, 3 months ago

  By: Beatrix Kiddo

• query is taking long time to run

  Hi all here i am executing the query "select * from tmp_Brad_Product_Configuration_12months" while …

  New persopn

  13 replies

  11 years, 3 months ago

  By: New persopn

• What should be the best approach to identify performance problems in Production environment

  Hello Experts, I need all your opinion to work on identifying performance issues by finding best to…

  vinod.saraswat

  4 replies

  11 years, 3 months ago

  By: Gail Shaw

• Profiler distribution of grouped CPU seems odd

  Greetings, I am trying to chase a high CPU load coming from SQLSERVER and wanted to isolate transac…

  klharless

  1 replies

  11 years, 3 months ago

  By: Erland Sommarskog

• Problems explaining deadlock chain

  Hi, We are currently in a spot of bother, attempting to explain a deadlock chain and would really r…

  Kaushik Majumder

  6 replies

  11 years, 3 months ago

  By: Stefan_G