SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Fragementation Still Same after reindex

  HI, I Had reindexed the db's all the db's using the script below but still i seen some non clustere…

  santoshkal

  4 replies

  10 years, 11 months ago

  By: Gail Shaw

• CPU speed, cache size, latency of caches

  For installing SQL Server 2008 on a physical server, how should server administrator budget for CPU…

  Maintainer

  5 replies

  10 years, 12 months ago

  By: Jeff Moden

• Frequent Index Fragmentation

  Hi guys, I am facing an issue with index fragmentation.I have a DB in which few of the tables have …

  Jai-SQL DBA

  9 replies

  10 years, 12 months ago

  By: Sean Lange

• How to reduce the Clustered index seek cost

  HI All, can you please provide the possible ways to reduce the clustered index seek cost in executi…

  kbhanu15

  3 replies

  10 years, 12 months ago

  By: tulipvioletproject

• SQL Server Alert on Severity 016

  Some time back I created an alert ... that is suddenly capturing about 3 failures per day on one of…

  dwilliscp

  2 replies

  10 years, 12 months ago

  By: Shawn Melton

• Implicit conversion of input parameter in predicate causing performance issues

  I have an application that is submitting a couple parameterized queries that are causing performanc…

  T Michael Herring

  1 replies

  10 years, 12 months ago

  By: Maintainer

• Parameter Sniffing

  If I run this Query using the procedure-parameters (@From, @To) in the WHERE clause, the execution …

  Louis Hillebrand

  12 replies

  10 years, 12 months ago

  By: milos.radivojevic

• sys.dm_exec_query_stats?

  Hi Expert, For finding the long running query we will use the Syntax "select * from sys.dm_exec_qu…

  Chowdary's

  2 replies

  11 years ago

  By: Chowdary's

• SQL Server 2008 delay in connection

  Hi everyone! I'm running into a weird issue with SQL server that I am unable to explain and/or fix.…

  koxta

  10 replies

  11 years ago

  By: koxta

• SYS.DM_EXEC_REQUESTS gives different information

  Hello, To analyze the performance data I am inserting SYS.DM_EXEC_REQUESTS DMV result into table. U…

  pawana.paul

  1 replies

  11 years ago

  By: sqlsurfing

• Buffer Cache hit ratio

  Hi, We are checking the Buffer cache hit ratio (as % using Buffer cache hit ratio / Buffer cache hi…

  MattF

  2 replies

  11 years ago

  By: i_amhers

• Query execution plan keep changing

  I have an application which one of the query (within stored procedure) execution plan keeps changin…

  Amu

  1 replies

  11 years ago

  By: Eirikur Eiriksson

• Sql server 2008 query execution slow from client windows 7

  i have sql server 2008 SP1 installed on OS( windows server 2008). i've placed my application folder…

  pyarakiku2004

  6 replies

  11 years ago

  By: pyarakiku2004

• Some time Stored Procedure suddenly taking 10 seconds when we called through application.

  Sometime following stored procedure suddenly taking 10 seconds when we called through application.…

  patelchandresh330 80387

  8 replies

  11 years ago

  By: Chris Wooding

• indexing in standard edition

  We have sql 2008 r2 standard. In one of our databases, the indexes get fragmented quickly causing …

  LadyDardar

  8 replies

  11 years ago

  By: LadyDardar