SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Determine running occurence of SQL statement

  Hi friends, i have a very troublesome production SQL 2005 box getting many performance cocompliant …

  jack_hc

  2 replies

  10 years, 2 months ago

  By: jack_hc

• Database Data File Physical Fragmentation From Small Auto-Growth Setting

  I've placed this post in the SS2005 Performance Tuning section of the forum because it was totally …

  Gail Wanabee

  14 replies

  10 years, 3 months ago

  By: Henrik Staun Poulsen

• To find any SQL server proc, in a specific database that is returning more than N rows

  Hi, Is there a way, maybe via SQL trace, to identify any procedure that returns more than N rows ba…

  Sainath Kesavan

  3 replies

  10 years, 4 months ago

  By: Sainath Kesavan

• Query fast one day, slow the next day - can indexes go bad

  I have a large database (several tables with hundreds of millions of rows) and I am running a query…

  Tom John-342103

  15 replies

  10 years, 4 months ago

  By: Jacob Wilkins

• High CPU but fail mirrored database over and/or back resolves things

  Trying to get to the bottom of an issue with a load test going through one of our environments. Get…

  rarara

  9 replies

  10 years, 4 months ago

  By: rarara

• Find connects to the linked server on a sql2012 server

  I need find any servers, programs or db that connect to a specific linked server on a sql2012 serv…

  h2.huang

  1 replies

  10 years, 6 months ago

  By: Lowell

• Is SQL Profile able to provide resource usage stats?

  Hi folks, I'm running Microsoft Retail Management System as our POS solution across 20+ stores. The…

  Alex W. Caldas

  2 replies

  10 years, 7 months ago

  By: Alex W. Caldas

• can I use Profiler to capture the contents of dynamic SQL

  Hi We are moving over from sql2000 to 2005 on many of our production systems and I am coming to ter…

  Liam Willis

  4 replies

  10 years, 7 months ago

  By: jgaripalli

• Performance issue

  I have an web app using ASP and SqlServer. On my local and Dev version for same DB We don't get scr…

  SAnjy N

  8 replies

  10 years, 7 months ago

  By: rajkumarcse14

• How to reduce the size of MSDB database

  Hi, I am working with SQL server 2005 and the msdb database size has been increased to 16 GB. We …

  Narayana_17

  3 replies

  10 years, 7 months ago

  By: spaghettidba

• Deadlock during Bulk operations

  Hi, I am working on production environment of SQL Server 2012. .Net is used as front end apllicatio…

  nikhil.desai1

  1 replies

  10 years, 8 months ago

  By: spaghettidba

• its very urgent !! How to Improving Performance or Query Tuning of SQLView with Select Command,Please help me on this issue

  hello DBAs, I am trying to improve the performance of the following view, the Query is running more…

  Database admin(DBA)

  3 replies

  10 years, 8 months ago

  By: Sean Lange

• Creating new database with existing MDF(only MDF) file.

  Dear All, I have downloaded MDF of my database from live server to local server. Now I want to crea…

  Joy Smith San

  3 replies

  10 years, 8 months ago

  By: SQListic

• how will you come to know which index is missing in a table of sqlserver 2005

  how will you come to know which index is missing in a 1000 tables of sqlserver 2005 Thanks Naga.Roh…

  naga.rohitkumar

  1 replies

  10 years, 8 months ago

  By: Jeff Moden

• Performance tuning it so critical can any one plz figure it out urgent

  Hi all, Performance tuning it so critical can any one figure it out [there are no clients its a own…

  naga.rohitkumar

  4 replies

  10 years, 9 months ago

  By: Jeff Moden