Timeline for Huge data and performance in SQL Server
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:23 | history | edited | CommunityBot |
added [query-performance] to 2412 questions - Shog9 (Id=1924)
|
|
| Feb 8, 2018 at 10:46 | answer | added | Goran Mancevski | timeline score: 1 | |
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Dec 15, 2015 at 17:24 | comment | added | Brandon | I've posted the execution plan. | |
| Dec 15, 2015 at 17:23 | history | edited | Brandon | CC BY-SA 3.0 |
added execution plan
|
| Dec 15, 2015 at 4:53 | history | edited | Paul White♦ | CC BY-SA 3.0 |
Incorporated clarifications from comments; updated tags
|
| Dec 15, 2015 at 0:01 | comment | added | usr | So far I don't think there is enough data here to find out what actually is consuming so much time. Is it CPU? Is it IO? Since you seem to be getting 30k rows per second it does not look like IO to me. Do I understand this right that you are quite close to achieving your perf goal? You need 50k rows per second, so one 100k batch every 2 seconds should suffice. Right now one batch seems to take 3 seconds. Post the actual execution plan of one representative run. Any suggestion that does not attack the most time consuming operations is moot. | |
| Dec 14, 2015 at 22:37 | answer | added | Kin Shah | timeline score: 8 | |
| Dec 14, 2015 at 18:30 | history | edited | Brandon | CC BY-SA 3.0 |
added 944 characters in body
|
| Dec 11, 2015 at 3:54 | answer | added | jyao | timeline score: 0 | |
| Dec 10, 2015 at 23:59 | history | tweeted | twitter.com/StackDBAs/status/675102464643870721 | ||
| Dec 10, 2015 at 23:12 | comment | added | paparazzo | What indexes were in place with slow production inserts? | |
| Dec 10, 2015 at 21:30 | comment | added | Martin Smith | Did you already experiment with delayed durability? | |
| Dec 10, 2015 at 21:18 | history | asked | Brandon | CC BY-SA 3.0 |