SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Slow response from sys.syscomments

  SQL Server 2005 Standard Edition 9.00.3042.00. I work with an application that uses it's own schem…

  jeffwithag

  3 replies

  15 years, 2 months ago

  By: Stefan_G

• How to check if indexing is running?

  I have reporting database, which is refreshed every 3 hour. I usually get a Transaction deadlock er…

  Ajit-297150

  15 replies

  15 years, 2 months ago

  By: Bhuvnesh

• Poor Performing Query at Subscriber

  I have a clustered production server (12 CPU, 28 GB AWE Memory), and a clustered reporting server(1…

  Sumon Basu

  5 replies

  15 years, 2 months ago

  By: Robert Davis

• Performance issue got to be done in few hrs need HELP PLZ

  HI i got 2 servers. Server 1 and Server 2. Server 1 runs with lot of backend applications server 2 …

  sam-1083699

  29 replies

  15 years, 2 months ago

  By: Dave Ballantyne

• DeadLock while adding a record in table if i have one non-clustered index for 100 users concurrent load at a time

  I have following table in a db. If I create non clustered index on any of following columns: Progr…

  Shamshad Ali

  15 replies

  15 years, 2 months ago

  By: Shamshad Ali

• Why 'ALTER INDEX REBUILD' didn't change 'avg_fragmentation_in_percent' returned from sys.dm_db_index_physical_stats?

  I ran 'Rebuild Index Task' in maintenance plan, then used the following the query to check index fr…

  hl6a

  5 replies

  15 years, 2 months ago

  By: weitzera

• Deadlocks

  Greetings, I'll try to explain my problem, We have 3 servers all with the same type service. The ta…

  sqln00b

  1 replies

  15 years, 2 months ago

  By: sqln00b

• FK selection (an nvarchar(30) column or four int columns)

  To make a long story short, I have to add a new table with an FK to an existing table. The existin…

  Eric.Johns

  4 replies

  15 years, 2 months ago

  By: Eric.Johns

• Sql Doubt - 1

  1) Can we generate Trigger for two table and give a example ? 2) Describe performance tuning steps …

  troy2.net

  11 replies

  15 years, 2 months ago

  By: troy2.net

• SQL Server Profiler: Help needed monitoring one specific store procedure

  Hi All, I want to be able to monitor a single stored procedure via SQL Server Profiler, but I do no…

  ttsang

  13 replies

  15 years, 2 months ago

  By: alinnemarie

• Query Performance Issue

  Can u plz refer books on Troubleshooting of Performance issues of sql server 2005 queries

  satishthota

  1 replies

  15 years, 2 months ago

  By: Gail Shaw

• Moving Reporting Services Database Files

  Hi, I have moved all the system database files for a new SQL 2005 Standard Edition server from the …

  Lee-586434

  7 replies

  15 years, 2 months ago

  By: kschwid

• Can I say that 'Clustered index scan' equals to 'table scan'? Or what is the difference?

  I am learning some basics about TSQL performance tuning. Some of the terms are confusing to me. Cou…

  hl6a

  3 replies

  15 years, 2 months ago

  By: hl6a

• Improve Between performance

  I'm trying to find a way to improve the performance of a query that uses a between clause Here's wh…

  cgreathouse

  31 replies

  15 years, 3 months ago

  By: cgreathouse

• SQL2005 SP3 CU9 64 bit min memory is not working

  Hello, I've a SQL2005 SP3 CU9 64 bit installed on a Windows 2003 R2 64 bit Maschine. The Servers ha…

  Oldman@ds9

  14 replies

  15 years, 3 months ago

  By: Greg Edwards-268690