SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Query tuning

  Dear experts, please help with the below sp fine tuning. DB: SQL Server 2005 (Size: 29GB). …

  Gangadhara MS

  4 replies

  14 years, 4 months ago

  By: Grant Fritchey

• Insert batches of 50-100 rows using UNION ALL - Huge hit on CPU

  Hello SQL Gurus, We are working on a project where we have a 6 flat files each with a header row, 1…

  Jared

  10 replies

  14 years, 4 months ago

  By: Ninja's_RGR'us

• creating filegroup

  1) how to create filegroups to distribute large tables over multiple drives and to separate indexes…

  rajeev-958491

  7 replies

  14 years, 4 months ago

  By: FTdenali

• Strange performance boost by query rewrite

  Hi folks. Being a complete newbie in sql query optimization, I'd like some help in understanding th…

  otykier

  16 replies

  14 years, 4 months ago

  By: otykier

• Database(Query) Optimization...

  Dear All, I explain more Details about my Project/database. i have develop on SMS System for one Ma…

  nirav.gandhi 50053

  1 replies

  14 years, 4 months ago

  By: Gail Shaw

• SQLserver 2005 Server side Tuning

  Hi I want to know about Server Side Tuning on SQL2k5. My Sqlserver configuration are given below: …

  kochu.vinod

  4 replies

  14 years, 4 months ago

  By: kochu.vinod

• Execution plan analysis

  I am basically a .NET developer and trying to troubleshoot the performance of a query I am noticing…

  sandyinfowave

  11 replies

  14 years, 4 months ago

  By: sandyinfowave

• Read Uncommitted - View to pull data

  Main Database and Database_Reporting. All reports views pull data from Database_Reporting and come …

  TRACEY-320982

  1 replies

  14 years, 4 months ago

  By: Grant Fritchey

• After SQL Server 2008 upgrade performance degraded.

  Hi, I have upgraded SQL server 2005 to SQL server 2008 in 32 bit platform in Production database. A…

  bidyendu

  2 replies

  14 years, 4 months ago

  By: Grant Fritchey

• Question about sys.dm_db_index_operational_stats

  Does the singleton_lookup_count number get re-set when an index gets rebuilt? I suspect it would, …

  Henry Treftz

  6 replies

  14 years, 5 months ago

  By: Jack Corbett

• can I tune this

  Hi All, I have a query where I am joining 6 tables and getting nearly 10,000 records in 1.30 minute…

  subrat_4ualways

  4 replies

  14 years, 5 months ago

  By: Grant Fritchey

• "A significant part of sql server process memory has been paged out. This may result in a performance degradation"

  Hello, I have the following problem: "A significant part of sql server process memory has been page…

  muruecos

  7 replies

  14 years, 5 months ago

  By: Gail Shaw

• SQL Server 2005 CPU bottleneck

  Hi, We have a MS SQL cluster 2005 with 4 CPUs dual core & 16GB RAM and currently host only 1 d…

  hooifong

  3 replies

  14 years, 5 months ago

  By: TheSQLGuru

• how to get the following result

  Hi All I'm new to sql server and I've a problem.I've two table table 1 …

  er.nawazish 37834

  3 replies

  14 years, 5 months ago

  By: Grant Fritchey

• identify long running queries sql server 2000 and send alert through Email

  Friends, I have to find out the long running queries in my servers and I need to send alerts throug…

  santu4bth

  1 replies

  14 years, 5 months ago

  By: Grant Fritchey