SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• dm_db_index_usage_stats - Multiple entries for a single index

  I am attempting to gather information about index utilization using dm_db_index_usage_stats, and fe…

  pjdiller

  3 replies

  15 years, 4 months ago

  By: roger.price-1150775

• Data importation from remote SQL server, best performances

  Hi all, I would like to know which is the best method (as performance) to import data from a remote…

  aslorenzo

  2 replies

  15 years, 5 months ago

  By: aslorenzo

• Index ReOrg & fragmentation

  We are looking to fine-tune our ETL process for our Data Warehouse and some of the articles we have…

  aber

  4 replies

  15 years, 5 months ago

  By: aber

• Profiling a stored proc and seeing nothing but SP:Cacheremove

  We have a third party product plugged into one of our sql servers. There is a certain process one o…

  Shark Energy

  7 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Efficient way to fetch data through job

  Hi I'm using sql server 2000. I've to write a job which fetches around 10 lakhs records from a tabl…

  Sree-258588

  5 replies

  15 years, 5 months ago

  By: Bhuvnesh

• Detecting Locking and impact on Server

  Hi all - as the title suggests I am after some guidelines as to how to measure the impact blocking …

  Kwisatz78

  1 replies

  15 years, 5 months ago

  By: Toby White

• Need some expert opinions on whether proposed design to improve performance is a good idea

  So I'm brand new to this company and here is their scenario. The company as a whole gets about 4 t…

  jabo73

  4 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Benchmarking a new Server

  So many times I have found myself in a situation where I am trying to measure the performance of a …

  bobmclaren

  1 replies

  15 years, 5 months ago

  By: Bhuvnesh

• Will view imporve performance

  Hi, We have a report which run 15 store procedures to fetch the data. This report takes 1 hours to …

  sqlwars

  3 replies

  15 years, 5 months ago

  By: SQLRNNR

• Columns that contain both clustered and unclustered

  Hello, I have a question regarding indexing, is it good practice to have a clustered and non-clust…

  Duran

  20 replies

  15 years, 5 months ago

  By: Grant Fritchey

• Overactive use of Temp Tables?

  I have a .NET application I wrote that collects data from machines and updates a database with summ…

  bobmclaren

  21 replies

  15 years, 5 months ago

  By: Jeff Moden

• DTA advises clustered index in NC index

  We have prob over 30 indexes in total on our db where DTA has recommended using clustered index on …

  jabadwy

  8 replies

  15 years, 5 months ago

  By: SQLRNNR

• Faster ETL import process

  I am currently testing out scenario where import log files into a staging table then into a fact ta…

  eseosaoregie

  11 replies

  15 years, 5 months ago

  By: eseosaoregie

• Using DTA - How safe is the usage of Shell database.

  Hi all, I have a requirement to create Clustered Indexes on few tables on a Production server. Befo…

  m--S3qU3L

  1 replies

  15 years, 5 months ago

  By: Grant Fritchey

• SQL Profiler: Caputure query ONLY when there is an exception

  Hi All, I am Leela from India. Nice to see some many Database experts helping fellow members on ou…

  LeelaKrishna

  1 replies

  15 years, 5 months ago

  By: Bhuvnesh