SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Scheduler appears deadlocked due to a large number of worker threads

  I am seeing a lot of these messages in sql server error logs 2011-12-11 03:27:34.15 Server All…

  Benki Chendu

  4 replies

  13 years, 12 months ago

  By: Benki Chendu

• Question on index column ordering

  Please read the entire post, most of this is just background information: I have a very large table…

  dfrome

  22 replies

  13 years, 12 months ago

  By: Gail Shaw

• Need Help to configure restricted Access to SQL Servers in a Network.

  Dear All, I need to restrict access to my 3 SQL Servers databases installed in 3 different server m…

  balajipalakkattu

  6 replies

  13 years, 12 months ago

  By: Devendrakumar

• How to organize data & Log files

  I have two drive arrays in a server (C and D both of same size) and also have an application(report…

  ig_sql

  1 replies

  13 years, 12 months ago

  By: spaghettidba

• where does that estimated number come from?

  Dear all, I'm currently troubleshooting performance problem of our ERP software and using SQL trace…

  assistan11

  11 replies

  14 years ago

  By: Devendrakumar

• Model Database in SQL Server

  Hi , I just want to know Why the Model Database is in Full Recovery Model in SQL Server 2005.? Rega…

  venkatb.dba

  2 replies

  14 years ago

  By: Gail Shaw

• fetch from cursor seems to be much slower than original query

  We're currently trying to upgrade from version 7.7 to version 8.1 of Siebel (running on MSSQL2005)…

  marko61

  18 replies

  14 years ago

  By: Bronco

• Memory utilization

  Hi All, Which counters give the exact utilization of memory for SQL Servers ? I believe Total Serve…

  beejug1983

  1 replies

  14 years ago

  By: Grant Fritchey

• tempdb file placement

  Hi. I have a SAN with virtual arrays striped across all spindles. I have presented 2 * RAID 1 LUN'…

  2Tall

  10 replies

  14 years ago

  By: 2Tall

• DataBase Enging Tuning

  Hello when i use from Data Base Engine Tuning, it gives many suggestion about that we can better o…

  Farnaz Safaee Nik

  9 replies

  14 years ago

  By: Devendrakumar

• Query read values periodically go way up...

  I have a stored procedure that when viewed in profiler/trace base lines at about 20k reads. I have…

  DoubleEx

  5 replies

  14 years ago

  By: TheSQLGuru

• One to ponder - Why is this Execution Plan "randomly" changing?

  We have a SQL Server system which is used by BusinessObjects Data Services and exhibits an intermit…

  DanDensley

  5 replies

  14 years ago

  By: DanDensley

• link of exec plan's parts with running query

  Good Morning , is it possible to map estimated plan (its parts) to currently running query? for ex…

  den_sidr

  8 replies

  14 years ago

  By: Paul White

• T-SQL , Stored Procedures & Performance Tuning

  T-SQL , Stored Procedures & Performance Tuning: I need clear idea and good example for the abo…

  alaguganesha1983

  3 replies

  14 years ago

  By: Grant Fritchey

• SQL Server 2005 Enterprise High CPU Usage by Resource monitor

  [RESOLVED] Cause by large TokenAndPermUserStore. The high CPU was caused by excessive maintenance o…

  Seek-Kill

  4 replies

  14 years ago

  By: Seek-Kill