SQL Server 2005 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• DMV sys.dm_db_index_physical_stats

  while this query on production database its taking a lot of time to produce the results on fragment…

  Sharon Kumar

  3 replies

  15 years ago

  By: Nadrek

• Long query duration but no reads or CPU

  Hi, I have a very simple query that inserts one record (contains XML data stuffed in a varchar(max)…

  bpportman 52825

  2 replies

  15 years ago

  By: bpportman 52825

• Stored Proc: Fast in SSMS, Slow in ASP.Net

  I have a stored proc which runs in about 10 seconds on SSMS, but when I run it via ASP.Net (against…

  goksly

  8 replies

  15 years ago

  By: SQLRNNR

• Query of live data too slow

  First off - I apologize if this isn't the correct forum, but I have a question regarding a very slo…

  chugghin

  19 replies

  15 years ago

  By: Grant Fritchey

• Query takes too much time to fetch the record

  Hi, I have 40 gb database which have 5 years transaction record.and i cant delete any single reord.…

  pankaj.kuchaliya

  9 replies

  15 years ago

  By: quackhandle1975

• partition a table by date

  Hi, I have some confusion about the partitioning of tables.is it possible to partition a table on t…

  pankaj.kuchaliya

  1 replies

  15 years ago

  By: NickDBA

• Performance issues running SQL 2005 on VM ESXi

  One of my customer, due to organizational virutalization demands, have moved SQL 2005 running on a …

  G33kKahuna

  2 replies

  15 years ago

  By: TheSQLGuru

• Performance Issues

  Hello Gurus, In our environment, we have a new server with 24 processors, 12gigs memory. This is a…

  ALI SQLDBA

  11 replies

  15 years ago

  By: Toby Harman

• SORT_IN_TEMPDB index option

  Can anyone tell me where SQL Server stores this option? I have looked in sysindexes, sys.indexes an…

  rob.patterson-1085747

  9 replies

  15 years ago

  By: TheSQLGuru

• INDEX DISABLE/REBUILD ???

  Hi, i read many topics/articles about DISABLING/REBUILDING indexes but couldn't get it. can anybody…

  Bhuvnesh

  9 replies

  15 years ago

  By: Bhuvnesh

• Performance Tuning in SQL Server 2005

  Hi, I have idea about indexing and execution plans, but I don't know how to start with Performance …

  beejug1983

  4 replies

  15 years ago

  By: Gail Shaw

• CPU 100% and critical

  Can anyone offer any advice to why over the last 1.5 days server is flatlining at 100% CPU.. I have…

  oraculum

  35 replies

  15 years ago

  By: BJ Hermsen

• Index Defragmentation

  My production servers are not high OLTP system but i have to defragment some of the indexe's daily(…

  PradeepVallabh

  7 replies

  15 years, 1 month ago

  By: Bhuvnesh

• Date Conversion Fills the Transaction log

  I have 2 sql server 2005 instances running on 2 different boxes, one is 32 bit Win Server 2003, the…

  R0gu3Tr4d3r

  14 replies

  15 years, 1 month ago

  By: Jeff Moden

• How can CREATE INDEX be made more effecient

  OS: Windows Server 2003 (64bit) SP2 PLATFORM: SQL Server 2005 Ent Edit Is there anything one can …

  YSLGuru

  18 replies

  15 years, 1 month ago

  By: Stefan_G