SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• big query

  Hi all, Today, we got one query for performance tuning, which is like, selecting 460 columns from 6…

  pmadhavapeddi22

  3 replies

  11 years, 3 months ago

  By: Luis Cazares

• wait types-miscellaneous

  We are seeing high miscellaneous wait types on our server. What exactly are these wait types?

  deep_kkumar

  6 replies

  11 years, 3 months ago

  By: deep_kkumar

• Help on testing a use case to understand sql server memory

  Hi, This is a question which came out of curiosity to know of how sql server handles memory. Assume…

  Oracle_91

  9 replies

  11 years, 3 months ago

  By: Oracle_91

• Large Execution Time of Report on dedicated proper IBM Server Machine as compare to Desktop Base Server Machine

  Dear All, I have a VB based desktop application with back end MS SQL server 2000 database with serv…

  mianirfan786 81909

  1 replies

  11 years, 4 months ago

  By: Eirikur Eiriksson

• Stored procedure runs slow when executed by more than 40 users

  We are using a stored procedure, which inserts into a temp table and uses spatial index for search…

  smarinova

  2 replies

  11 years, 4 months ago

  By: smarinova

• Clustred scan to seek

  Hi Experts, I was Tuning a query which is running for a long time of more than 30 min.When i look a…

  Gangadhara MS

  8 replies

  11 years, 4 months ago

  By: Gangadhara MS

• Is there any way to improve statistics on a table like this?

  Hi there! After seeing a great session on statistics by Grant at SQL Saturday, I've been eagerly ex…

  Andrew Kernodle

  9 replies

  11 years, 4 months ago

  By: Jeff Moden

• high CXPACKET and LATCH_EX

  Users claims the slow performance on the database. I collected top waits for the server as below. H…

  Grace09

  4 replies

  11 years, 4 months ago

  By: Lempster

• Table scan paranoia

  I have a stored procedure hitting a 761969 row table and doing several table scans on it. It is ind…

  sqldriver

  13 replies

  11 years, 4 months ago

  By: sqldriver

• How am I getting Network_IO wait

  If I am doing a select * from <local table>, then how am I getting a wait type of "Async_Netw…

  dwilliscp

  4 replies

  11 years, 4 months ago

  By: Gail Shaw

• Werid Behaviour of TSQL

  I have complex view and try to fetch data from it. In following code query 2 takes 1 sec to execute…

  psingla

  3 replies

  11 years, 4 months ago

  By: Jeff Moden

• Queries for per database performance

  I'm trying to get a handle per-database performance on my servers (SQL 2005 and 2008 R2) to determi…

  dave.sql

  2 replies

  11 years, 4 months ago

  By: Bouke Bruinsma

• writelog wait_type sys.dm_os_wait_stats reasonable number

  I found a simple query on the web to evaluate my waitstats for log writes. SELECT wait_time_ms FROM…

  dweil

  1 replies

  11 years, 4 months ago

  By: Jack Corbett

• Odd Results from an Indexed JOIN Column

  Hello there! Starting off with some DDL... CREATE TABLE #AgentSession( [sessionId] [int] IDENTIT…

  Andrew Kernodle

  8 replies

  11 years, 4 months ago

  By: Ed Pollack

• find out which queries are causing the deadlock

  Hi, I occasionally get the following message on our production sql server box. Transaction (Process…

  Sridhar-137443

  2 replies

  11 years, 4 months ago

  By: Sridhar-137443