Timeline for CXPACKET Waits performance tune for SQL Server 2008
Current License: CC BY-SA 3.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 28, 2013 at 0:16 | comment | added | Kin Shah |
@atommc dual cpu 32 bit W2K8 time to upgrade to 64Bit. Also, have you enabled /3GB switch along with AWE ?
|
|
| Nov 27, 2013 at 20:20 | answer | added | Tom McDonald | timeline score: 0 | |
| Jun 12, 2013 at 13:58 | answer | added | atommc | timeline score: 0 | |
| Nov 21, 2012 at 8:24 | comment | added | Holistic Developer | @atommc Did you resolve this issue? | |
| Oct 17, 2012 at 7:56 | answer | added | mceda | timeline score: 0 | |
| Oct 4, 2011 at 11:32 | comment | added | atommc | @aaron sorry, the 4.5 million number is correct, the earlier estimate was just a bad guess. | |
| Oct 4, 2011 at 10:02 | history | tweeted | twitter.com/#!/StackDBAs/status/121163359361052672 | ||
| Oct 3, 2011 at 21:22 | answer | added | mrdenny | timeline score: 10 | |
| Oct 3, 2011 at 20:33 | comment | added | Aaron Bertrand | @atommc can you clarify the last paragraph then? There it says #tradep has 100k-500k rows. | |
| Oct 3, 2011 at 17:02 | comment | added | atommc | the #tradep table has ~4.5 million records | |
| Oct 3, 2011 at 16:05 | answer | added | ConcernedOfTunbridgeWells | timeline score: 4 | |
| Oct 3, 2011 at 15:42 | comment | added | gbn | yes, size of data | |
| Oct 3, 2011 at 15:35 | comment | added | atommc | @gbn. It is a Vostro 420 Tower Desktop, 4GB RAM, Intel Core 2 Duo, it has dual core and, I assume, 2 sockets, but I'm not sure about the latter. en.wikipedia.org/wiki/Intel_Core_2 The Dell specs don't mention anything about hyperthreading so I assume it isn't support.dell.com/support/edocs/systems/vos220/en/sqrg/… I'm not sure what you mean about 'size of the data', but I think you mean the number of records in the #tradep and #ttcbm tables? | |
| Oct 3, 2011 at 12:14 | answer | added | Jimbo | timeline score: 5 | |
| Oct 3, 2011 at 11:54 | history | migrated | from stackoverflow.com (revisions) | ||
| Oct 3, 2011 at 11:40 | comment | added | gbn | Size of data? Amount of RAM? When you say "2 CPU", how many sockets, cores is this, and do you have hyperthreading? | |
| Oct 3, 2011 at 9:11 | history | asked | atommc | CC BY-SA 3.0 |