SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Planning Disk and File layout

  Hi all We are looking to migrate from a busy datawarehouse server to a new server and I have been t…

  Kwisatz78

  2 replies

  11 years, 4 months ago

  By: Modest DBA

• index advantage query

  could anny one please explain me the meaning of equality_columns, inequality_columns, included_c…

  IT researcher

  2 replies

  11 years, 4 months ago

  By: Gail Shaw

• CDC Growth and poor performance issues

  Hello Friends, In our Database we have enabled the CDC initially from the past 2 years it has grown…

  Saravanan_tvr

  4 replies

  11 years, 4 months ago

  By: Lowell

• Stored Procedure Performance

  I have one Stored procedure That takes around 2 hour to execute. it runs in 2 hours on server with …

  amardesai89

  1 replies

  11 years, 5 months ago

  By: Sean Lange

• All queries running slow after moving the db from staging server to production Server in SQL Server 2008 R2

  We have the db in staging server which runs in SQL 2008 R2 RTM version holding 32 GB of RAM. We hav…

  Kumar-386306

  6 replies

  11 years, 5 months ago

  By: BOR15K

• Sql Performance Tuning

  I am seeing something in Sql 2008 (Express and R2) that I do not totally understand, I am hoping so…

  stephenmbell

  3 replies

  11 years, 5 months ago

  By: stephenmbell

• Execution plan whose components add up to 248%

  I have attached an execution plan whose components are adding up to 248% Though I was able to resol…

  Kingston Dhasian

  2 replies

  11 years, 5 months ago

  By: Kingston Dhasian

• Need Sugestion on Which Columns I need To Create A NonClustered Index?

  I have a huge amount of data table EMP with 15 columns, and it has only one primary key with its cl…

  Anjan@Sql

  5 replies

  11 years, 5 months ago

  By: Neeraj Prasad Sharma

• SAN LUNs and disk striping

  Hello all, I was wondering if something that we do (as suggested by our partners) with HP-UX and Pr…

  felipe.braun

  1 replies

  11 years, 5 months ago

  By: Perry Whittle

• Non cluster index help required (3 questions) : SSMS 2008R2

  Hi Friends, I have table (Table_A (A_id int(PK), col1 nvarchar, col2 nvarchar, col3 nvarchar, col4 …

  chauhanparixit

  2 replies

  11 years, 5 months ago

  By: chauhanparixit

• Troubleshooting Blocking

  Hi All I am trying to figure out which queries have caused blocking on my system, or which queries …

  SQLSACT

  3 replies

  11 years, 5 months ago

  By: SQLSACT

• Batch Requests/Sec with Low-ish CPU spikes

  I am running SQL Server 2008 R2 (64-bit) standard on a Windows 2008 64-bit server. I typically noti…

  Rob Phillips

  1 replies

  11 years, 5 months ago

  By: SQLSACT

• advantage and disadvantage of table partation in sql server

  Whar are the advantage and disadvantage of table partation in sql server.

  saurabh.deshpande

  1 replies

  11 years, 5 months ago

  By: Gail Shaw

• help with stored procedure tuning.

  trying to fine tune a stored procedure it has 10 union all between select scripts..performance is v…

  Lucky9

  4 replies

  11 years, 5 months ago

  By: Sean Pearce

• SQL Profiler - Threshold values

  Hi, I hope you pro's could help me out with some performance issues I'm having.. Oke, so we have so…

  sqldkay

  7 replies

  11 years, 5 months ago

  By: Gail Shaw