Timeline for SQL server performance and tuning
Current License: CC BY-SA 3.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 1, 2016 at 15:53 | answer | added | Mark | timeline score: 0 | |
| Mar 16, 2013 at 7:40 | history | tweeted | twitter.com/#!/StackDBAs/status/312830675864649728 | ||
| Mar 15, 2013 at 20:47 | comment | added | DarthVader | I worked for Y!, amazon and ebay, none of them throw hardware at problems!!! | |
| Mar 15, 2013 at 15:30 | comment | added | Mark Storey-Smith | I'm inclined to agree with @HLGEM. 2TB and 40k requests/sec is not Q&A territory. Suggestions made here will be shots in the dark and you're likely to make matters worse by following them blindly. That said, stuffing the server full of RAM won't hurt. | |
| Mar 15, 2013 at 14:50 | comment | added | HLGEM | Step one hire a dba with experience in large systems. This isnot some easy questions that someone on the InNternet can answer. Likely there are many things including redesigning your database or rewriting your queries or redoing your indexes or updating your statistics that need to be done. You may need to look at partioning the data and hardware changes. | |
| Mar 15, 2013 at 14:44 | answer | added | granadaCoder | timeline score: 0 | |
| Mar 15, 2013 at 14:25 | comment | added | Stuart Ainsworth | can you post a sample of what you have tried? Have you looked at partitioned indexes or include indexes? | |
| Mar 15, 2013 at 13:40 | history | migrated | from stackoverflow.com (revisions) | ||
| Mar 15, 2013 at 13:31 | answer | added | Kenneth Fisher | timeline score: 3 | |
| Mar 15, 2013 at 13:27 | comment | added | DHN | Hmm, probably you could tweak the indexes. Perhaps you'll find a solution here | |
| Mar 15, 2013 at 13:18 | comment | added | DarthVader | @ypercube index fragmentation is always there. that s not a conclusion. | |
| Mar 15, 2013 at 13:16 | comment | added | ypercubeᵀᴹ | @DarthVader You have conclude that the SQL-Server and indexing is the bottleneck. How isn't it database realted? | |
| Mar 15, 2013 at 13:15 | comment | added | Xaqron | Without much data about app and with such a RAM, try to increase SQL buffer pool manually. | |
| Mar 15, 2013 at 13:15 | comment | added | DarthVader | @DHN i edited the question. | |
| Mar 15, 2013 at 13:15 | comment | added | DarthVader | why is this off topic? how is this related to database itself? | |
| Mar 15, 2013 at 13:12 | comment | added | Kermit | This not on-topic for StackOverflow. Voting to move to dba.se | |
| Mar 15, 2013 at 13:07 | comment | added | DHN | Can you explain the bottleneck? What's having a poor performance. Reading data, inserting data? | |
| Mar 15, 2013 at 13:02 | history | asked | DarthVader | CC BY-SA 3.0 |