SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Which query should use for performence prospects.

  Case 1. ----------- selectConvert(bigint,RecordID) as RecordId,TRANSACTION_ID,PROPERTY_ID,GeoSourc…

  nitin.varshney

  1 replies

  13 years, 1 month ago

  By: Grant Fritchey

• Rebuild Partitioned Indexes

  When you have to rebuild an index that has partitions do you have to specify the partitions within …

  Shawn Pierre

  3 replies

  13 years, 1 month ago

  By: cadarsh88

• how to know whether a replication is complete

  how to check whether all the objects have finished replicating,, am using RMO programming in C# any…

  apu5star

  1 replies

  13 years, 1 month ago

  By: shotman

• SQL Server 2005 - anything similar to Oracle AWR Report?

  Hi Guys, With Oracle Automatic Workload Repository feature, we can see the top few resource intensi…

  chewychewy

  1 replies

  13 years, 2 months ago

  By: Orlando Colamatteo

• Alternative to CROSS JOIN?

  I have 2 tables like so: PRODUCT [SKU varchar(10); SHORT_DESCRIPTION varchar(255)] - (Approx record…

  sammyIT

  5 replies

  13 years, 2 months ago

  By: sammyIT

• Query parses fine; DTA reports syntax error

  The query parses fine under Query Editor but generates an error when run under the Database Tu…

  Barkingdog

  14 replies

  13 years, 2 months ago

  By: shokeen.amit

• sub-view performance issue

  All, I have a view (vw_detail) which is called from Crystal report. This view in turn calls another…

  onkarnath

  5 replies

  13 years, 2 months ago

  By: Grant Fritchey

• Maximum memory per db

  Hi everyone, I have SQL Server 2005 32bit running on Server 2008 R2 64bit with 30GB memory installe…

  j_virk

  6 replies

  13 years, 2 months ago

  By: j_virk

• more cpu usage..

  I have seen more cpu usages when i ran select * from sys.sysprocesses... Can any one please tell, i…

  mohan.bndr

  1 replies

  13 years, 2 months ago

  By: Gail Shaw

• Duplicate indexes and indexes with differect included columns

  Hi, I am working on SQL server 2005. I am trying to improve the performance of the DB by removing t…

  ashokeie

  2 replies

  13 years, 2 months ago

  By: Gail Shaw

• total_worker_time in sys.dm_exec_query_stats

  Quick question, Is total worker time dependent on the # of CPU's? Like if I have 8 CPU's, and I ass…

  Gabriel P

  3 replies

  13 years, 2 months ago

  By: Gullimeel

• Read locks and write locks

  how does sql server prioritize while having both read locks and write locks together...Does it allo…

  PradeepVallabh

  5 replies

  13 years, 2 months ago

  By: Evil Kraig F

• how much space does index creation use

  I created an index on a table which has around 50 million records....but looks like index creation …

  Sandy2704

  1 replies

  13 years, 2 months ago

  By: george sibbald

• Does DTA makes any changes to data while Profiler trace has INSERT/UPDATE statements

  I have created log files using SQL Profiler tuning template to use as Workload for DTA. My trace lo…

  microsoftee

  2 replies

  13 years, 2 months ago

  By: Grant Fritchey

• Recompilation required for adequate performance?

  Environment: SQL Server 2005, SP4 on a 2 node, active/passive cluster DB Size: 335 GB and growing…

  Mick Opalak

  1 replies

  13 years, 2 months ago

  By: Grant Fritchey