SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Performance Impact of using Union in where clause

  please comment , I am not able to track what optimizer is doing differently in both Scenario 1 ta…

  sqldba.shafi

  4 replies

  9 years, 5 months ago

  By: Sergiy

• Disappointing Performance

  Hi, My first post here seeing as how I became the accidental admin for our databases. Learning a lo…

  c_wager

  9 replies

  9 years, 5 months ago

  By: rothj

• MD: database_id = 1 INVALID(INVALID)

  Hi All, I have a process that runs large batch operations from a Navision application server that s…

  HBomb

  4 replies

  9 years, 5 months ago

  By: HBomb

• Complicated performance issue

  Hi All, We have 2 live environments both with same database structure and application but there is …

  nadersam

  14 replies

  9 years, 5 months ago

  By: nadersam

• Advice on query optmization - Multiple Unions

  Hi, I'm trying to understand how this might be better optimized. I currently have these three diffe…

  ljp007

  7 replies

  9 years, 5 months ago

  By: MadAdmin

• sp_whoIsActive 101 help...

  I just downloaded this script. 1. Is there any documentation\tutorial explaining the meaning (and …

  Barkingdog

  6 replies

  9 years, 5 months ago

  By: Barkingdog

• AutoGrowth 1 MB

  I've been trying to help another DBA on his project. It has been in production for five years or m…

  Bill Talada

  4 replies

  9 years, 5 months ago

  By: Summer90

• Optimizing Queries

  Hi, I have some queries which are taking about 6 seconds to run against a table with 12,000,000 odd…

  Frank Cazabon

  13 replies

  9 years, 5 months ago

  By: Sergiy

• Report / Query performance problems...

  Quick background: Monthly scheduled reports are provided to our customers, using SSRS/SQL Server 20…

  bikerdadHLV

  3 replies

  9 years, 5 months ago

  By: bikerdadHLV

• Slow stored procedure on application side and not on SSMS

  We have a stored procedure(SP1) on a database on sQL SERVER 2008 R2 that has three input pararmeter…

  Aspet Golestanian Namagerdi

  3 replies

  9 years, 5 months ago

  By: Thomas Rushton

• Changing data type to optimize performance

  Hi All, I have read many articles recommending use of varchar instead on nvarchar as first one only…

  nadersam

  10 replies

  9 years, 6 months ago

  By: Gail Shaw

• How minimice the transaction log file growth during maintenance plain

  Hello, I have a database with the recovery mode defined as FULL. I have defined a index maintenanc…

  ico-601891

  10 replies

  9 years, 6 months ago

  By: Sergiy

• sys.dm_os_performance_counters - Lock Memory (KB)

  Hi We have a fairly highly intensive batch processing db. SQL 2008 R2 SP3 48CPU 512GB RAM +-5TB DB …

  dunno_developer

  1 replies

  9 years, 6 months ago

  By: r.dragoi-1095738

• disk perfmon counter "avg sec/write" values not looking consistent with graph

  Hi All, I had a support call to troubleshoot slow performance on the SQL server and I did see a lot…

  indianscorpion29

  5 replies

  9 years, 6 months ago

  By: Gail Shaw

• Help with performance (triggers)

  Hi, Actually i have a huge Production DB with different machines identified by an id (Machineid), s…

  sergio.arv

  3 replies

  9 years, 6 months ago

  By: spaghettidba