Timeline for What are the performance implications of running multiple smaller DBs instead of a single larger DB on a server?
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 15, 2020 at 9:05 | history | edited | CommunityBot |
Commonmark migration
|
|
| Aug 16, 2012 at 1:48 | answer | added | Jon Seigel | timeline score: 0 | |
| Dec 7, 2011 at 18:12 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
Add ? to title, correct misspelled database (was databse); reformatted question to visiibly see the two questions in the Question Body
|
| Aug 30, 2011 at 9:04 | vote | accept | Dog Ears | ||
| Aug 29, 2011 at 0:34 | history | tweeted | twitter.com/#!/StackDBAs/status/107974381120143362 | ||
| Aug 28, 2011 at 14:36 | answer | added | Mark Storey-Smith | timeline score: 7 | |
| Aug 28, 2011 at 13:19 | answer | added | Mark S. Rasmussen | timeline score: 4 | |
| Aug 28, 2011 at 8:06 | answer | added | user507 | timeline score: 2 | |
| Aug 26, 2011 at 16:33 | comment | added | Dog Ears | @SBlackler - anything up to about 400GB each, with 10's of thousands of concurrently logged in users. | |
| Aug 26, 2011 at 15:27 | comment | added | Stuart Blackler | How big are the databases? How many concurrent users of the system are there? | |
| Aug 26, 2011 at 14:59 | comment | added | Dog Ears | @Surfer513 - what calculations and testing? Could you expand in an actual answer? thsi is a pretty basic question "Big v Multiple Small" - yet I can't seem to find anything specific on the inter-web. | |
| Aug 26, 2011 at 14:41 | comment | added | Thomas Stringer | This is one of those big "it depends" situations. Get a baseline for how hard the resources are getting hit by using perfmon, and through some calculations and testing you can get a pretty good idea before pushing this out to production. | |
| Aug 26, 2011 at 14:37 | history | edited | Dog Ears | CC BY-SA 3.0 |
edited the title slightly to emphasise the questions intent
|
| Aug 26, 2011 at 13:07 | comment | added | Dog Ears | These are fictitious figures we actually don't have customers, well, we have one customer, broken down into different regions and sub regions but the software can work with them split across DBs or in a single DB we have many physical boxes running multiple DBs. | |
| Aug 26, 2011 at 12:43 | comment | added | Mark Storey-Smith | Where you currently have 10 customers in each of 5 databases, how many physical servers and SQL instances are there? | |
| Aug 26, 2011 at 11:05 | history | asked | Dog Ears | CC BY-SA 3.0 |