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)
Corrupted Tables  

jitendra.padhiyar 2 47 2 days ago @ 1:58 AM
Last Post By: spaghettidba
Topic (New Replies)
what to do when we see multiple blocking chains?  

vsamantha35 3 98 Sunday, March 1, 2015 5:11 PM
Last Post By: Jeff Moden
Hot Topic (New Replies)
Super long running queries (bad users)  
jchapman 20 847 Friday, February 27, 2015 9:56 PM
Last Post By: Jeff Moden
Topic (New Replies)
LATCH_EX and CXPACKET waitstates are too high  

aprathour.89 3 97 Friday, February 27, 2015 6:57 AM
Last Post By: aprathour.89
Topic (New Replies)
Stored Proc hanging in SSIS, runs 20 secs in SSMS (2008 R2 SP1)  

steven.oates 1 73 Wednesday, February 25, 2015 5:02 AM
Last Post By: lmarkum
Topic (New Replies)
After which period autoshrink event triggers  

aprathour.89 2 53 Wednesday, February 25, 2015 2:37 AM
Last Post By: GilaMonster
Hot Topic (New Replies)
SQL apparently not realising it should ditch a cached execution plan and make a new one  
julian.fletcher 11 354 Tuesday, February 24, 2015 12:12 PM
Last Post By: alanspeckman
Topic (New Replies)
SSRS Performance on large table  

smanikandan23 3 79 Friday, February 20, 2015 7:24 AM
Last Post By: Koen Verbeeck
Topic (New Replies)
running local or network DB's for speed  

Bruce-12445 3 108 Thursday, February 19, 2015 9:06 PM
Last Post By: Bruce-12445
Topic (New Replies)
Error: 18056, Severity: 20, State: 46.  

aprathour.89 2 70 Thursday, February 19, 2015 7:19 AM
Last Post By: aprathour.89
Topic (New Replies)
Logical reads aggregating when particular "if exists" stmt called multiple times inside proc  

vijayakumarn 1 56 Wednesday, February 18, 2015 7:27 AM
Last Post By: spaghettidba
Topic (New Replies)
SQL Server 2008 Express R2 on Windows Server 2012 slow insert operation  

Filippo Menditto 0 64 Monday, February 16, 2015 9:32 AM
Last Post By: Filippo Menditto
Topic (New Replies)
How to grab the dependent objects and check if we have the below mentioned partition keys are used  

kbhanu15 0 37 Monday, February 16, 2015 2:53 AM
Last Post By: kbhanu15
Topic (New Replies)
RE: DATA_COMPRESSION = PAGE for all tables and indexes in a database.  

Eric M Russell 0 74 Wednesday, February 11, 2015 4:04 PM
Last Post By: Eric M Russell
Topic (New Replies)
memory objects performance counter prepare values  

hanumanth.jkc 1 78 Wednesday, February 11, 2015 1:10 AM
Last Post By: Stuart Davies
Topic (New Replies)
how to create user  

hanumanth.jkc 1 75 Tuesday, February 10, 2015 10:19 AM
Last Post By: MyDoggieJessie
Topic (New Replies)
sys.dm_db_index_physical_stats return wrong data  

b.ozga 5 220 Monday, February 9, 2015 6:54 AM
Last Post By: b.ozga
Topic (New Replies)
SQL Table to get system or memory page lock counters  

virgo 0 66 Thursday, February 5, 2015 3:10 AM
Last Post By: virgo
Topic (New Replies)
Help diagnosing performance issue  

bgrossnickle 4 350 Saturday, January 31, 2015 10:37 AM
Last Post By: jchapman
Topic (New Replies)
How redefine transaction logfile initial size  

ico-601891 1 102 Wednesday, January 28, 2015 3:15 PM
Last Post By: JeremyE


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