SQL Server 2008 Performance Tuning

• Topics

  Started by

  Posts

  Last post

• Stored Proc hanging in SSIS, runs 20 secs in SSMS (2008 R2 SP1)

  Hi, We have a problem which we have hit a brick wall with, hopefully someone can offer some support…

  steven.oates

  3 replies

  10 years, 6 months ago

  By: Jeff Moden

• SSRS Performance on large table

  Hi, we have created ssrs report to show data from the very large table. Every hour the bulk insert …

  smanikandan23

  5 replies

  10 years, 6 months ago

  By: NachiM

• Corrupted Tables

  Hello Masters, Our SQL Server 2012 STD 64 bit STD edition are in cluster and databases used for Sha…

  jitendra.padhiyar

  2 replies

  10 years, 6 months ago

  By: spaghettidba

• what to do when we see multiple blocking chains?

  Hi All, How to troubleshoot blocking if u r seeing multiple blocking chains? Do I need to kill all…

  vsamantha35

  3 replies

  10 years, 6 months ago

  By: Jeff Moden

• LATCH_EX and CXPACKET waitstates are too high

  Hi Everyone, i have two problems: 1) i have set maxdop=8 to my sql instance , but when i am looking…

  aprathour.89

  3 replies

  10 years, 6 months ago

  By: aprathour.89

• After which period autoshrink event triggers

  Hi Everyone, i have set auto shrink option true for one of my database, i want to know after which …

  aprathour.89

  2 replies

  10 years, 6 months ago

  By: Gail Shaw

• SQL apparently not realising it should ditch a cached execution plan and make a new one

  I'm working on a reasonably complex database (i.e. many tables, SPs, UDFs, triggers and views). And…

  julian.fletcher

  11 replies

  10 years, 6 months ago

  By: alanspeckman

• running local or network DB's for speed

  Hi I'm looking at optimising access speed on some GIS databases by moving them to either their own …

  BRP

  3 replies

  10 years, 6 months ago

  By: BRP

• Logical reads aggregating when particular "if exists" stmt called multiple times inside proc

  HI, When analyzing the performance problem of a server process, I found that logical reads are very…

  vijayakumarn

  1 replies

  10 years, 6 months ago

  By: spaghettidba

• memory objects performance counter prepare values

  Hi all Please tell me the which values are best prepared value for given below memory objects Memo…

  hanumanth.jkc

  1 replies

  10 years, 7 months ago

  By: Stuart Davies

• how to create user

  Hi all Some developer asked me please create user for me for read to some application (XXX) please…

  hanumanth.jkc

  1 replies

  10 years, 7 months ago

  By: MyDoggieJessie

• sys.dm_db_index_physical_stats return wrong data

  Hi guys, Last night I had to rebuild two indexes on very large db (>1TB) Luckily I could do it i…

  b.ozga

  5 replies

  10 years, 7 months ago

  By: b.ozga

• Help diagnosing performance issue

  We have a nightly ETLV job that our 30 clients run every night. Depending on the size of the client…

  bgrossnickle

  4 replies

  10 years, 7 months ago

  By: jchapman

• How redefine transaction logfile initial size

  Hi, I have in the production environment a database with a transaction file who was defined with 8G…

  ico-601891

  1 replies

  10 years, 7 months ago

  By: JeremyE

• Multiple Indexes on the Same Column with Different Included Columns

  Our group's primary employee data table has a LOT of indexes. I noticed that, in some cases, more t…

  cherrygalaxy

  2 replies

  10 years, 7 months ago

  By: Gail Shaw