SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Database Engine Tuning Advisor

  Hi, I have check the query in database engine tuning advisor, it display the recomendations.should …

  pankaj.kuchaliya

  6 replies

  15 years ago

  By: pankaj.kuchaliya

• Insertion problem

  Hi, I have schedule one procedure to execute with in every 15 minute to update the data. itakes th…

  pankaj.kuchaliya

  3 replies

  15 years ago

  By: pankaj.kuchaliya

• Query takes too much time

  hi, When i execute the query it takes 6-10 seconds some times more then that while it return 3122 …

  pankaj.kuchaliya

  4 replies

  15 years ago

  By: pankaj.kuchaliya

• Page FIle high

  My productions server is showing that page file utilization is very high, I check the processor in …

  Sharon Kumar

  3 replies

  15 years ago

  By: TheSQLGuru

• Query issues on tables where we altered column data types that were/are uses in indexes.

  Hi, We made some changes to our database over the weekend where we altered tables columns where we …

  gerbowers

  4 replies

  15 years ago

  By: Grant Fritchey

• executing a stored procedure whcih is kind of batch, throws Error - Exception of type 'System.OutOfMemoryException' was thrown

  This stored procedure (proc1) I am executing selects few records and iterate through it and execute…

  Praxo

  2 replies

  15 years ago

  By: Praxo

• Optimization of an sql proc stock [Beginner]

  Hye everybody, I am not a specialist in Sql server (like you ;)) and i have got a problem with a pr…

  novitito

  3 replies

  15 years ago

  By: novitito

• De-Duping runtime OLTP data

  Greetings good folks at SQLSeverCentral I am having some performance issues with a job which identi…

  anish_ns

  4 replies

  15 years ago

  By: anish_ns

• is performance can increase if existing database table moves into different file group

  Hi, Suppose I have database "test". And i have tables A,B,C,D A:- master table B:- transaction tabl…

  pankaj.kuchaliya

  16 replies

  15 years ago

  By: TheSQLGuru

• T-SQL code performance - am I missing something obvious

  I have a database of source records amount to currently 91 million records and I expect a similar g…

  Balance

  7 replies

  15 years ago

  By: ChrisM@Work

• Index

  Hi All, My database consists of 40 tables. I have analyzed those tables and picked out some c…

  balaji.ganga

  8 replies

  15 years ago

  By: Grant Fritchey

• Clustered Index Seek is limiting factor in query

  I'm having issues tuning a query and am hoping for some help. The below query takes between 35 and…

  dingels35

  13 replies

  15 years ago

  By: scott.pletcher

• Slow full text search

  Hello, We have 2 environments: test and production. Of course production environment is a much bett…

  elayevskiy

  7 replies

  15 years ago

  By: Nils Gustav Stråbø

• Scratching my head? Simple query takes minutes to run.

  Hi all, Following is a small portion of a larger procedure that recently timed out. There are two q…

  geerobg

  9 replies

  15 years ago

  By: Gail Shaw

• Need high resource expensive sql queries

  Hi All, I need sql queries or bad tsql code for producing high expensive resource utilization queri…

  sejal p gudhka

  6 replies

  15 years ago

  By: Jeff Moden