SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• SQL 2005 Standard only shows 8mb of RAM with AWE enabled at 2-4GB?

  Ok, so I am running SQL 2005 Standard edition. I am trying to schedule an application update with …

  jason2

  4 replies

  15 years ago

  By: Shawn Melton

• Running relog to convert perfmon binary to sql

  Newbie here.. I am running perfmon for about 22 canters and then plan on running relog against the …

  gus.debella

  2 replies

  15 years ago

  By: gus.debella

• ETL into database - auto update stats vs UPDATE STATISTICS

  I have a SQL 2005 database with tables that gets wiped every night (some tables TRUNCATE'd, others …

  mannaggia

  5 replies

  15 years ago

  By: PaulB-TheOneAndOnly

• Multiple execution plans for a stored procedure

  This just started recently on a few procedures that are running for a BI team. When a procedure via…

  fpniscott

  6 replies

  15 years ago

  By: Grant Fritchey

• Cost threshold for parallelism

  If I bump the cost threshold for parallelism from the default to something like 100 or 200 will que…

  Robert Frasca

  1 replies

  15 years ago

  By: Robert Frasca

• Buffer cache hit ratio low?

  One of our database instances has a buffer cache hit ratio that dips below 90% for 10 minute period…

  jhynes

  2 replies

  15 years ago

  By: mohd.sql

• sql server slow running.. Urgently..!

  Hi Last 3 on wads my report server transaction logs is is 90%, today when i saw, it was full, i mov…

  Sharon Kumar

  4 replies

  15 years ago

  By: steveb.

• Improving performance on Moving of data

  Hi I need some advice on a tricky situation. I am extracting a hell of a lot of data to a new datab…

  Andre 425568

  1 replies

  15 years ago

  By: spal-1065446

• Windows 2008 R2, SQL 2008 sp1 Slow Delivery of Results

  I have worked in the field of SQL Performance tuning for years, and this one is just perplexing. Ne…

  mindycurnutt

  24 replies

  15 years ago

  By: Johan Bijnens

• Clustered index degrades the performance

  I have a Deposits table which has approximately 270,000 rows in it. This table has a Clustered Inde…

  onurcivi

  6 replies

  15 years ago

  By: Leo.Miller

• Ledger Table: Improving Performance

  Firstly the core tables: EventTable: * Id (INT) * Moment (DATETIME) LedgerTable: * Id (INT) * Event…

  goksly

  4 replies

  15 years ago

  By: goksly

• sysprocesses blocked

  Hello, This morning deveploers complained that they are not able to select data from one particular…

  dallas13

  4 replies

  15 years ago

  By: dallas13

• High Avg. Disk Queue Length

  Hi all on a current logical volume in perfmon which is using a scalre of 100.00 my average reading …

  Kwisatz78

  5 replies

  15 years ago

  By: Ramji29

• does partitioning table need clustered Index?

  Does partitioning table need clustered Index on key( example Id or Date) If i have a table ( Articl…

  adnani

  2 replies

  15 years ago

  By: Paul White

• Clustered index on non-unique and non-increasing column

  I'm the dba on a SQL 2005 database for 3rd-party system which has a lot of tables with no clustered…

  James Lavery

  4 replies

  15 years ago

  By: Scott Coleman