SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• NON-Clustered Indexes on table but no Clustered Indexes

  I've been asked to analyse a process that uses alot of temporary tables to identify any potential i…

  Mikey01

  19 replies

  10 years, 3 months ago

  By: robpurrington

• Stored Procedure slower on faster newer machine ?

  Greetings. I'm puzzled. I have written a stored procedure that I am reasonably happy with. It is ru…

  destino

  8 replies

  10 years, 3 months ago

  By: SQLRNNR

• Database Designing Related

  Hi Friends, Please Help me...... I Have the below requirement........ 1. Design the DB for ‘Retai…

  Krishh

  4 replies

  10 years, 3 months ago

  By: MMartin1

• find % CPU from dm_os_performance_counters

  Hi , Iam collecting a baseline report for one of the sql server instance, where i have only instanc…

  Gopi Krishnan-468302

  3 replies

  10 years, 4 months ago

  By: subsonic-abercrombie

• Script to find Foreign Key missing Index?

  Hi, just now I'm working with performance tuning on a SQL Server 2005. I need an script that can fi…

  Semko Redzic

  9 replies

  10 years, 5 months ago

  By: sqlpadawan_1

• SQL Server 2008 Ent R2 64bit will not use all available memory

  SQL Server 2008 Ent R2 64bit on Windows 2008 Ent R2 64bit will not use all available memory. The t…

  richard.moses 47670

  11 replies

  10 years, 5 months ago

  By: Gail Shaw

• Long-running query

  I'm using SQL Server 2005 Service Pack 3. My monitoring tools was SQL Monitor from Red Gate. One of…

  Qira

  1 replies

  10 years, 5 months ago

  By: Andrew Kernodle

• Need to Optimize Update Query

  I am implementing Type 1 SCD - Update changed attributes and disregard older attributes. Load new …

  Chinna

  3 replies

  10 years, 5 months ago

  By: ChrisM@Work

• Performance issue

  I am facing problem with stored procedure. Procedure contains three temporary tables. suddenly givi…

  Ramakrishna-148487

  6 replies

  10 years, 6 months ago

  By: MMartin1

• How can I check the Long Running Query by using Stats..

  Hi All, Here am Using SQL 2008, How can i check the Long Running Query by using the following Query…

  Chowdary's

  5 replies

  10 years, 7 months ago

  By: doug.brown

• automate the process of database uploading from local system to dbsever

  I have a local system and I have a DB server.From local system to DBserver only port 1433 is open.F…

  forsqlserver

  2 replies

  10 years, 7 months ago

  By: SQLFan888

• Increase in CPU per Execution when a SP is called in volume

  Hi Guys, I have an interesting problem that I don't know the answer to! That's why i'm posting 🙂…

  Rin Sitah

  4 replies

  10 years, 7 months ago

  By: Rin Sitah

• how to reduce Wait time on server replies ?

  My query shows following statistics: How can i reduce time for Wait time on server replies, i mean …

  Megha P

  1 replies

  10 years, 7 months ago

  By: Megha P

• SQL Memory Usage

  Hi, Is there any script to check or make a per hour report for memory consumed/used by SQL Server 2…

  nikhil.desai1

  1 replies

  10 years, 7 months ago

  By: racharla_sivakumar

• ALLOW_PAGE_LOCKS vs DEADLOCKS vs REBUILD INDEXES

  Hi, I would like to know if there is a link between any of these 3 things. Specifically the followi…

  Casper101

  5 replies

  10 years, 7 months ago

  By: Gail Shaw