SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Find Locks and Blocking sessions for a time period

  Hi All, I would like to find a way to find all types of locks which are more than 5secs and blockin…

  harikumar.mindi

  2 replies

  11 years, 9 months ago

  By: SQLSACT

• Partition on table with no data and table with data

  Hi, I have a table created and as of now there is no data in the table, I created a partition vie…

  kalyav21

  1 replies

  11 years, 9 months ago

  By: Erland Sommarskog

• Help required for performance tuning a view

  Hello, I've inherited a database from a co-worker and have now got to a stage with it where I'm try…

  MikeRen

  20 replies

  11 years, 9 months ago

  By: MikeRen

• Defining a process for troubleshooting performance issues

  Hello there! The issue of poor database performance is one which presents itself from time to time …

  DBAWaffle

  2 replies

  11 years, 9 months ago

  By: DBAWaffle

• Sessions using high CPU

  Hi I've been trying to determine the simplest way to determine which sessions are using high CPU. I…

  wak_no1

  4 replies

  11 years, 9 months ago

  By: wak_no1

• Log truncation is not happening

  HI all in my production server for one database mdf file size is 300gb land log file size is also s…

  New persopn

  8 replies

  11 years, 9 months ago

  By: Erland Sommarskog

• Is profiler only one toool ..

  Can any one please clarify me here that .. Profiler is the only tool that has the ability to audit …

  mohan.bndr

  4 replies

  11 years, 9 months ago

  By: Erland Sommarskog

• Trace Flag 1222.. duplicate infomation in error log ?

  Hi I wonder if you can help me , looking at the results stored in the error log after an update sta…

  Jack Springheel

  4 replies

  11 years, 9 months ago

  By: Erland Sommarskog

• higher cpu execution time

  I have a very simple query to select all columns from a table if a particular column does not a cha…

  IT researcher

  4 replies

  11 years, 9 months ago

  By: Erland Sommarskog

• ReTrace utility not importing the trace file

  Hi Friends, I am trying to analyze a trace file using ReTrace utility. However, it is not able to i…

  Divine Flame

  1 replies

  11 years, 9 months ago

  By: Sean Smith

• Resource Governor Workload Classification limitations - looking for ideas

  Hi, Many of our processes run as SQL jobs unfortunately. I would like to segment some groups of the…

  digitalox

  1 replies

  11 years, 10 months ago

  By: Jeff Moden

• Indexing & Fragmentation

  First - a little background - I'm a new DBA for my company and am trying to wrap my head around ind…

  speedman_2001

  4 replies

  11 years, 10 months ago

  By: speedman_2001

• Using a View from one database to a second database that returns a large result set

  I have been asked a question today that I am having a hard time providing an answer for and would l…

  DesmoShane

  12 replies

  11 years, 10 months ago

  By: SQLRNNR

• Different cache time for same plan_handle

  Hi I am looking in to sys.dm_exec_procedure_stats, one of the SP cached on 06/20 and the same plan …

  dfine

  6 replies

  11 years, 10 months ago

  By: dfine

• Collation causing very slow query performance

  Good morning all. I am pulling my hair out over a problem I am having with a very slow performing …

  domciccone

  1 replies

  11 years, 10 months ago

  By: Erland Sommarskog