SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Performance issue with view

  I have a view which has joins with multiple tables and have some complex logic. I am facing weird p…

  sqlnaive

  8 replies

  11 years, 2 months ago

  By: sqlnaive

• Partitioned Table Practices

  Hi, When DBA's partition tables, what are some of the things they look at to determine the number o…

  smallmoney

  3 replies

  11 years, 2 months ago

  By: Gail Shaw

• Partitioned Table on same physical volume performance

  Is there any real advantage having a partitioned table with all files groups on the same disk?

  smallmoney

  3 replies

  11 years, 2 months ago

  By: Gail Shaw

• Best way to write stored procedures

  Hi, What is the best way to write stored procedures. Any tips on that also, I need to know how can …

  Sana4u

  7 replies

  11 years, 2 months ago

  By: Jeff Moden

• Need help on this SP Urgent

  I have been told to optimize this stored procedure :w00t: . Please view the attached database schem…

  Sana4u

  3 replies

  11 years, 2 months ago

  By: Sana4u

• Need help to understand these wait-types

  I have SQL 2008 R2, I see top ten cumulative wait events. Could you please which ones I need to be …

  bubby

  5 replies

  11 years, 2 months ago

  By: SQLRNNR

• TempDB Data Files - I/O Requests Taking Longer Than 15 Seconds To Complete

  Hi, Here's a little background of my environment. I am running SQL Server 2008 R2 SP2 64-bit on a …

  dajonx

  3 replies

  11 years, 2 months ago

  By: dajonx

• Deadlocks in replicated database

  We have an application that is experiencing deadlock issues with a SQL Server 2008 Standard databas…

  mayurkb

  2 replies

  11 years, 2 months ago

  By: mayurkb

• Optimizing ORDER BY query

  Hi, In my SSIS Package, I have a query which is using a combination of views to retrieve records t…

  arijit rath

  7 replies

  11 years, 2 months ago

  By: Jeff Moden

• CPU Usage reached 100%

  Hi All, There is almost 5 to 6 Database is there in SERVER. and server configuration is RAM: 16GB O…

  arooj300

  3 replies

  11 years, 2 months ago

  By: Sachin Nandanwar

• SQL Server 2008 R2 Memory

  Is my server under memory pressure? This is a standard edition, 64 GB of memory in 64-bit environme…

  Grace09

  4 replies

  11 years, 2 months ago

  By: Jack Corbett

• Query slow after VM migration (same install)

  I have a 'Process Cube' workload that has been running the same speed for several months. The serve…

  andrew-petre

  6 replies

  11 years, 2 months ago

  By: ROBERT WALLACE

• Query running for morethan 2Hours 30 min

  Hi This query takes morethan a 2 Hour to complete and also attached the exec plan The DML.Exceptio…

  Gangadhara MS

  5 replies

  11 years, 3 months ago

  By: MMartin1

• how to find what is causing the cpu spike using performance dashboard

  Hi, I am attaching the performance dashboard screen shot that I ran just now. I noticed that wait t…

  Sridhar-137443

  1 replies

  11 years, 3 months ago

  By: lorrin.ferdinand

• Non clustered Index taking up more space than data

  Hi all, I've tried adding a non-clustered index to some tables and while it has improved performanc…

  TheComedian

  7 replies

  11 years, 3 months ago

  By: george sibbald