Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On


SQL Server 2008 Performance Tuning Expand / Collapse
TitleStarted ByRepliesViewsLast Post
Topic (New Replies)
Stored proc never completes vs. T-SQL completes in 14 seconds  

notifications 61467 3 50 2 days ago @ 4:25 PM
Last Post By: Sean Lange
Topic (New Replies)
How to maintain the threshold for each job on execution time in DB  

New persopn 1 34 2 days ago @ 4:31 AM
Last Post By: HanShi
Topic (New Replies)
In vs =, performance considerations  

robolance 5 116 Friday, November 14, 2014 3:37 AM
Last Post By: Gazareth
Topic (New Replies)
SSAS job is running longer after STATS update  

v4vaas 19815 0 37 Tuesday, November 11, 2014 9:10 AM
Last Post By: v4vaas 19815
Topic (New Replies)
What is using resource if all sessions in runnable, suspended, or sleeping status?  

marina-r 3 142 Sunday, November 9, 2014 11:11 AM
Last Post By: marina-r
Topic (New Replies)
Drop All non-clustered Primary key and create Clustered  

Shahzadi 1 75 Thursday, November 6, 2014 7:33 AM
Last Post By: spaghettidba
Topic (New Replies)
Log Disk getting full while rebuilding indexes online  

dba.sql29 2 103 Thursday, November 6, 2014 5:35 AM
Last Post By: Shahzadi
Hot Topic (New Replies)
performance issue causing application failed to load  
halifaxdal 11 353 Tuesday, November 4, 2014 7:15 PM
Last Post By: halifaxdal
Topic (New Replies)
Lock Timeouts  

jamesforest 2 71 Tuesday, November 4, 2014 4:38 PM
Last Post By: jamesforest
Topic (New Replies)
Can we created composite NonClustered index on the columns INTETER and VARCHAR ?  

kbhanu15 2 83 Thursday, October 30, 2014 5:51 AM
Last Post By: Koen Verbeeck
Topic (New Replies)
Slow Server MSDB high disk activity  

Shahzadi 0 63 Thursday, October 30, 2014 4:57 AM
Last Post By: Shahzadi
Topic (New Replies)
LATCH_SH on audit table with frequent INSERTs  

Eliyahu 0 81 Saturday, October 25, 2014 3:58 PM
Last Post By: Eliyahu
Topic (New Replies)
Cause and solution to a wait type of: OBJECT: 32767:124607697:0 [COMPILE]  

dan.holmes 0 84 Thursday, October 23, 2014 2:02 PM
Last Post By: dan.holmes
Topic (New Replies)
Bad Query Plan Headache  

reachshaft 4 132 Thursday, October 23, 2014 10:11 AM
Last Post By: reachshaft
Topic (New Replies)
Memory and performance issues  

Ville-Pekka Vahteala 5 154 Wednesday, October 22, 2014 4:49 AM
Last Post By: GilaMonster
Topic (New Replies)
Recommended memory settings  

nikhil.desai1 5 252 Thursday, October 16, 2014 6:18 PM
Last Post By: davidwarner
Topic (New Replies)
Slow running SQL server.  

davidwarner 9 225 Thursday, October 16, 2014 4:15 PM
Last Post By: davidwarner
Topic (New Replies)
Tempdb grows from nothing to 10G in just a few seconds  

Vera-428803 3 331 Thursday, October 16, 2014 11:02 AM
Last Post By: MMartin1
Topic (New Replies)
Huge difference in query time when changing date range a few months. Code/exc plans included  
Has Attachments!
thomashohner 4 206 Saturday, October 11, 2014 1:34 PM
Last Post By: thomashohner
Topic (New Replies)
About DBCC and Statistics  

indra.dwi_nugroho 0 101 Friday, October 10, 2014 1:12 PM
Last Post By: indra.dwi_nugroho


Permissions Expand / Collapse

Topic Key Expand / Collapse
Topic (New Replies)  Topic (New Replies)
Topic (No New Replies)  Topic (No New Replies)
Hot Topic (New Replies)  Hot Topic (New Replies)
Hot Topic (No New Replies)  Hot Topic (No New Replies)
Poll (New Replies)  Poll (New Replies)
Poll (No New Replies)  Poll (No New Replies)
Closed Topic  Closed Topic
Moved Topic  Moved Topic