SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Enormous Page Life Expectancy (PLE)?

  I've been running perfmon and analysing the results on a production Windows 2008 R2 server running …

  mmcardle

  8 replies

  7 years, 9 months ago

  By: mmcardle

• SQL behaving strangely on different servers

  Hi All,I have a sql statement working on static tables (no Insert,Update,Delete) on our testing ser…

  nadersam

  27 replies

  7 years, 9 months ago

  By: Arsh

• Deducing from Wait Stats

  Hi Everybody,The wait stats on the database I am assigned for performance tuning , shows that the P…

  Arsh

  9 replies

  7 years, 9 months ago

  By: John Mitchell-245523

• Query Plan...

  Hi Everybody,In some query plans we see some iterators have a non-zero cost even when the query cos…

  Arsh

  2 replies

  7 years, 9 months ago

  By: Arsh

• How can I improve performance of this query further?

  Hi, I'm a DW/ETL developer and I've created a data load process to load an aggregated table in my d…

  nick.baker 64464

  8 replies

  7 years, 10 months ago

  By: nick.baker 64464

• Difference between stored procedure and view

  Hi All, I have a question please about caching and buffering.Is there a difference between how a vi…

  nadersam

  9 replies

  7 years, 11 months ago

  By: Gail Shaw

• Multiple Plan_Handles for Single sql_handle

  Hi I have some SQL code that is producing multiple execution plans. SQL Handle      …

  alex.palmer

  2 replies

  7 years, 11 months ago

  By: alex.palmer

• Slow Transaction Log Restores

  Hi!I'm investigating into some slow transaction log restores - mostly they are from the larger tran…

  melc

  9 replies

  7 years, 11 months ago

  By: Sue_H

• More than 100 ms different between sp_executesql and direct query

  Hello All, I'm tracking down a performance issue with merge replication. I found a query that is ex…

  mayurkb

  1 replies

  8 years ago

  By: mayurkb

• Performance issue due to index

  Hi All, Yesterday on a production environment we got complaints about very bad performance.I logged…

  nadersam

  5 replies

  8 years ago

  By: nadersam

• Performance issue in Prod compared to DR

  We just took over this SQL server application and have been working on the really bad queries. We t…

  narayankrishnan15

  1 replies

  8 years ago

  By: Gail Shaw

• Exploring Extended Events and Blocking sessions

  Dear colleagues,I am setting up extended events in a SQL Server 2008R2 SP3 with an interests in get…

  Lou

  5 replies

  8 years, 1 month ago

  By: Chris Harshman

• How did you deal with the pressure of a perf issue? (non-tech question)

  Hi all, I don't think there's a greater test of one being a DBA than being faced with a performance…

  JaybeeSQL

  5 replies

  8 years, 2 months ago

  By: JaybeeSQL

• tuning help

  following qry is taking more than 3 hrs to run , it has billion records in each table, is there an …

  Tara-1044200

  6 replies

  8 years, 2 months ago

  By: Gail Shaw

• Drop in performance after archiving database

  Hello, after having made an archive on a database (pruge outdated rows in tables), I have a query t…

  deleios

  10 replies

  8 years, 2 months ago

  By: Jeff Moden