Timeline for Same restore file (.bak), huge difference of execution duration time on various computers
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Aug 31, 2012 at 21:41 | history | suggested | Hannah Vernon♦ | CC BY-SA 3.0 |
improved formatting and corrected grammar.
|
| Aug 31, 2012 at 21:11 | review | Suggested edits | |||
| S Aug 31, 2012 at 21:41 | |||||
| Feb 17, 2012 at 9:18 | comment | added | Simon Righarts | Save the query plan XML from the two computers and upload both of them somewhere. A minor difference in a query plan can make a massive difference in performance. | |
| Feb 17, 2012 at 8:18 | answer | added | gbn | timeline score: 4 | |
| Feb 16, 2012 at 15:13 | comment | added | jiangyan | I understand performance differences among computers, but not that much - 2 secs VS 26 secs, same query, same data, and even faster computer. btw, i can't see much difference in execution plans. | |
| Feb 16, 2012 at 15:07 | comment | added | Mark Storey-Smith | Usual shot in the dark would be different execution plan on each environment. For starters we need eyeballs on a) the query and b) execution plans for the query from each machine. | |
| Feb 16, 2012 at 14:37 | history | asked | jiangyan | CC BY-SA 3.0 |