SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Fastest Method to copy data Table to Table on the same Server

  I want to copy tables from one DB to another on the same server. Source Tables are non-unicode, tar…

  Christopher West

  7 replies

  16 years, 2 months ago

  By: Jeff Moden

• Need statistics update several times a day to prevent slow database

  Hi, I have a strange issue on an (Microsoft Dynamics 4) table. Here are the facts: - table has 1.56…

  Wilfred van Dijk

  8 replies

  16 years, 2 months ago

  By: matt stockham

• Polyserve physical nodes

  Hi all, I am developing a set of reports to check performance and tuning my instances inside a Poly…

  @fracionero

  1 replies

  16 years, 2 months ago

  By: BlackHawk-17

• SQL 2005 64-bit on Windows 2003 R2 Standard 64-bit and AWE/Lock Pages in Memory

  Hey Folks - I'm setting up a new production SQL 2005 64-bit server running on a dedicated Windows 2…

  David Rosenberg

  10 replies

  16 years, 2 months ago

  By: tavery_scigaj

• How many databases is too many

  I have an SQL instance we call a "shared" instance. We use it to host a variety of projects around …

  jsciii

  3 replies

  16 years, 2 months ago

  By: Grant Fritchey

• Unable to register sql server on sql 2000 enterprize manager

  I am trying to register my local Sql2000 server. I can connect to all remote servers with no issues…

  hydbadrose

  1 replies

  16 years, 2 months ago

  By: Elliott Whitlow

• How do index rebuilds, reorganize, defrag affect the caches?

  I ran a number of index rebuilds, and reorganizes (mostly online, a couple offline) last weekend, …

  sean_denney

  2 replies

  16 years, 2 months ago

  By: Marcin Gol

• Storage Decisions

  I have inherited a SQL Server 2005 that had been built and maintained by Windows admins who are not…

  ldstpete

  4 replies

  16 years, 2 months ago

  By: ldstpete

• Are my indexes wrong??

  Hi, I have a SQL Server 2005 database, the index usage statics report shows the following: Table …

  jflzc

  6 replies

  16 years, 2 months ago

  By: Gail Shaw

• Checking for Fragmentation level in sql server 2005 database

  Hi, We have 260MB database. We keep issuing one or two update statements for every one day or two …

  chiru_meher

  8 replies

  16 years, 2 months ago

  By: Wilfred van Dijk

• Data being written to LDF and periodically flushed to mdf causing dB to stop processing

  Setup: SQL Server 2005 (64bit)Clean dB instance created using all default settings except recovery …

  dublin

  3 replies

  16 years, 2 months ago

  By: Ian Scarlett

• %100 CPU and sys.dm_os_waiting_tasks

  Hi all As the title states I have an issue that occurs maxing out hte CPU. If I look in the DMV sy…

  Kwisatz78

  12 replies

  16 years, 2 months ago

  By: RBarryYoung

• 100% CPU utilisation

  Hi, I have a single duel core CPU with 4 GB RAM Windows2003SP2 with SQL2005SP2. After applying SP2 …

  chandu.ade

  1 replies

  16 years, 2 months ago

  By: Roy Ernest

• Advice on where to look.

  Hi, I have an issue at a customer site where our application is reportedly running slow. I have a t…

  Ronnie_Doggart

  5 replies

  16 years, 2 months ago

  By: Ronnie_Doggart

• URgent- Help needed on installing hot fix

  Currently my system is running sql 2000 sp4 with build 2195 and I need to install the hotfix (SQL S…

  hydbadrose

  2 replies

  16 years, 2 months ago

  By: hydbadrose