SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Stuck tracking down CXPACKET issue

  We have a server that often has the following happen: 1) It breaks a SPID down and assignes hundred…

  dwilliscp

  8 replies

  11 years, 10 months ago

  By: dwilliscp

• table locking issues

  I have an audit table that is written to and has records deleted from all the time through out day.…

  Lee Hopkins

  8 replies

  11 years, 10 months ago

  By: Lee Hopkins

• SQL Server Puzzling Performance

  Hi Guys, Been hanging around these forms for a very long time but never posted much. I am experienc…

  Francis Kioko

  11 replies

  11 years, 10 months ago

  By: Francis Kioko

• Index reorg taking too much time.

  Hi, We have a scheduled task that executes a stored proc that does few database maintenance tasks. …

  mayurkb

  4 replies

  11 years, 10 months ago

  By: mayurkb

• Proactive performance monitoring

  Hello there! I've been putting together a process to monitor potential performance issues with reg…

  DBAWaffle

  1 replies

  11 years, 10 months ago

  By: Gail Shaw

• Slow Query

  Hello I'm a bit of newbie when it comes to analysing a slow query, using a trace. Effectively, a us…

  wak_no1

  3 replies

  11 years, 10 months ago

  By: Alan Burstein

• SSRS 2008 R2 Report Query Generating ASYNC_NETWORK_IO

  Hello all, I have an issue with my report server in that it is struggling to process reports with l…

  SQLPhil

  3 replies

  11 years, 10 months ago

  By: colin.Leversuch-Roberts

• disk format cluster size

  HP Array Configuration Utility shows a strip size of 256 KB. Is it best to format the SQL data disk…

  inevercheckthis2002

  1 replies

  11 years, 10 months ago

  By: colin.Leversuch-Roberts

• Running out of workers

  Is there a way to set up a trace that will show why you are running out of workers? I know that I w…

  dwilliscp

  42 replies

  11 years, 10 months ago

  By: ELLEN-610393

• Exceptionally slow row addition or modification on table associated to indexed view.

  I have an index view (9M rows) based upon 2 cross joined tables. The storage of the index is in fil…

  Champagne Charly

  4 replies

  11 years, 10 months ago

  By: Champagne Charly

• Remote Scan via Linked Server

  Hi Gurus, I am having an issue with a query not using the cluster index. It is running a full scan…

  JohnDBA

  2 replies

  11 years, 10 months ago

  By: LutzM

• Indexing and Querying a Frequently Updated Table

  Apologies in advance if this is posted under the wrong heading - it's really a general performance …

  kabcampbell

  8 replies

  11 years, 11 months ago

  By: kabcampbell

• Slow execution in dynamic SQL with OR clause

  I have a stored procedure which accepts parameters and then builds the query and WHERE clause dynam…

  Casper101

  1 replies

  11 years, 11 months ago

  By: Gail Shaw

• Trouble shooting cursor

  I am wondering if Cursors translate query statements, I am getting alerts for high CPU usage(Sessio…

  TryingToLearn

  2 replies

  11 years, 11 months ago

  By: RTaylor2208

• Cannot write an XEL file to my C drive from an Extended Events session

  CREATE EVENT SESSION query_performance ON SERVER ADD EVENT sqlserver.sp_statement_completed( A…

  eddiecejb

  1 replies

  11 years, 11 months ago

  By: sqlsurfing