SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Required help regarding Performance Tuning of Query retrieving data from 30 Million records

  I have written a query which is taking 38 Seconds to execute on a table which has more than 30 Mill…

  asashank82

  9 replies

  14 years, 7 months ago

  By: Dave Ballantyne

• Query performance change after database refresh

  I have a query that runs in SQL 2005 production system that takes about 1 minute to return the resu…

  smushti

  9 replies

  14 years, 7 months ago

  By: Grant Fritchey

• Task manager SQL memory v/s Perfmon counter Total Memory

  I have setup a 2 node active/passive cluster with below details. Windows 2008 serverx64, SQL 2005 E…

  Ananda-292708

  8 replies

  14 years, 7 months ago

  By: Grant Fritchey

• Runnable queue question

  Hi all If a process is in the Runnable queue is this actually eating up resources in terms of CPU a…

  Kwisatz78

  4 replies

  14 years, 7 months ago

  By: Grant Fritchey

• how to optimize jdbc to sqlserver

  we have a application to sqlserver, app write by java. there are some performance issue.   i monito…

  lovelanjunping

  1 replies

  14 years, 7 months ago

  By: TheSQLGuru

• Query with nested subqueries

  I have to rewrite an inherited query that nested subqueries because it used to run but now fails af…

  barb0822

  4 replies

  14 years, 7 months ago

  By: barb0822

• Insert query slowdown

  Hi experts, Please advise on where to sort out the issue I'm having. A few of our users reported th…

  Mr. Holio

  6 replies

  14 years, 7 months ago

  By: Grant Fritchey

• Can this query be written more efficiently ?

  select A.Field1, A.ImportantDate, A.FirstTime from T1 A INNER JOIN (select Field1, max(FirstTime) A…

  sql_butterfly

  5 replies

  14 years, 7 months ago

  By: ChazMan

• Application related

  Diagnose data insert issue into IRIS table in MS SQL server The ETL application is getting data fr…

  Accord1688

  1 replies

  14 years, 7 months ago

  By: Grant Fritchey

• Performance Issues when upgrading from SQL 2000

  I have recently run into an issue when upgrading from SQL 2000 to SQL 2005 (sp3) with performance. …

  ron.richardson

  12 replies

  14 years, 7 months ago

  By: lnoland

• Partitining an existing table

  Hi Guys I have a very huge existing table, called 'Transaction_Summary', with 82 columns!!! contain…

  Hooman Shamsborhan

  46 replies

  14 years, 7 months ago

  By: Mitch Small

• Contention between TRUNCATE/INSERT and SELECT WITH (NOLOCK)?

  I'm having a problem I can't quite understand along the lines of the following: I have a commonly-a…

  BuzzerBeater

  13 replies

  14 years, 7 months ago

  By: Gail Shaw

• 64K Offset

  Does the 64K offset need to be the actual first 64K of a disk, or can it be 128 or 256, or anything…

  rickK_

  4 replies

  14 years, 7 months ago

  By: rickK_

• How to check index usage ?

  Guys, how to check which index is being utilized and to what extent ? I tried analyzing dm_db_index…

  sql_butterfly

  3 replies

  14 years, 7 months ago

  By: sql_butterfly

• Copying Database to Test server

  Hi I am wondering about the accuracy of placing a copy of production into a test environment. If I…

  Kwisatz78

  8 replies

  14 years, 7 months ago

  By: GSquared