SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• separate disks for data / logs / tempdb / system

  I have 16 drives and one RAID controller. Performance is one big consideration, but storage space …

  inevercheckthis2002

  10 replies

  11 years, 11 months ago

  By: Steve Jones - SSC Editor

• Query Plans migrating from 2005 to 2008R2

  I'm migrating from a 2005 server to a 2008R2 Server on Windows 2012. I restore the backup to test …

  KTD

  35 replies

  11 years, 11 months ago

  By: KTD

• sql server blocking and biztalk

  I have developers who have build some inserts and extracts from BizTalk into some production sql se…

  timscronin

  3 replies

  11 years, 11 months ago

  By: sqlsurfing

• Outer Apply and Cross Apply performance hits

  I have a serch functionality that has a query based on search inputs given. Initially the query is…

  VickyDBA

  4 replies

  11 years, 11 months ago

  By: Bhuvnesh

• Creating Index on all FK (more than 15 per table)

  Hi, I have 2-3 huge tables (more than 20M rows, and more than 50 columns each). About 20 of these c…

  aleksandar.ivanovski

  8 replies

  11 years, 11 months ago

  By: Gail Shaw

• Data Engine tuning Advisor

  Hi, I am trying to make use of the Data Engine Tuning Advisor, but keep getting the following error…

  Fishbarnriots

  6 replies

  11 years, 11 months ago

  By: Fishbarnriots

• Need to set Max Memory?

  One item you often see in "best practices" articles about SQL is the need to configure Maximum Memo…

  dan-572483

  3 replies

  11 years, 11 months ago

  By: Kurt W. Zimmerman

• Query on identical objects different systems, A performs speedy with index seek, B performs poorly with clustered index scan

  Identical Query. A select with one column condition. Selecting from a view. The view is bad, joi…

  SQLBlimp

  18 replies

  11 years, 11 months ago

  By: logitestus

• cxpacket wait differences for same query on different cluster nodes

  Hey guys, We are running a 5 node windows server cluster with multiple SQL 2008 instances. 1 instan…

  sqlharmony

  9 replies

  11 years, 11 months ago

  By: sqlharmony

• Paritioning key column as an included column or trailing index column

  We know that, SQL Server automatically adds the partition column to a secondary nonunique index as …

  Preethi S Raj

  7 replies

  11 years, 11 months ago

  By: Preethi S Raj

• Tuning Advisor

  Dear Experts: I am new in using tuning advisor. I have created tuning trace file, after finishing, …

  zi

  2 replies

  11 years, 11 months ago

  By: zi

• How to go and troubleshoot Internal memory pressure

  Hi All, Can anyone share links/examples on how to identify and troubleshoot sql server internal mem…

  Oracle_91

  1 replies

  11 years, 11 months ago

  By: Bhuvnesh

• TempDB best practices - Doubt

  Hello guys, I have two doubt: -- 1 script: SELECT cpu_count AS [Logical CPU Count], hyperthread_rat…

  LOVER OF SQL

  1 replies

  11 years, 11 months ago

  By: Jeff Moden

• Sub partitions

  Hello there, Does SQL Server 2008 R2 support Sub partitions? Thanks

  Sunil.Aggusher

  11 replies

  11 years, 11 months ago

  By: Sunil.Aggusher

• Performance on 10 million row table

  Hello all, I have a table, which is destined to rapidly grow. To give you an idea, the table is : C…

  stergiazotali

  8 replies

  11 years, 11 months ago

  By: stergiazotali