September 25, 2018 at 1:53 am
Hi Experts,
We are a small e-commerce company, planning to start an offer in december. The offer would be online on some products. We are hoping many orders hitting the orders database. As a DBA, what should i do to make sure the sale goes without any issues.
September 25, 2018 at 2:13 am
Hi,
it depends. Do you know the workload of your database now?
How much orders will be more in december.
You should know your RAM consumption, your IO and your CPU workload.
Do you use a virtuell sql server, or a physical?
If you use a virtuell sql server, are you able to put more RAM, disk or cpu without reboot?
Kind regards,
Andreas
September 25, 2018 at 8:35 am
andreas.kreuzberg - Tuesday, September 25, 2018 2:13 AMHi,
it depends. Do you know the workload of your database now?
How much orders will be more in december.
You should know your RAM consumption, your IO and your CPU workload.
Do you use a virtuell sql server, or a physical?
If you use a virtuell sql server, are you able to put more RAM, disk or cpu without reboot?
Kind regards,
Andreas
Workload is normal now but we are expecting high workload in December. We use VM.
September 25, 2018 at 9:34 am
coolchaitu - Tuesday, September 25, 2018 1:53 AMHi Experts,
We are a small e-commerce company, planning to start an offer in december. The offer would be online on some products. We are hoping many orders hitting the orders database. As a DBA, what should i do to make sure the sale goes without any issues.
We've been through this a couple of months ago at the following post.
https://www.sqlservercentral.com/Forums/1991564/millions-of-users-hitting-our-database
Many recommendations were made. Since you weren't able to support a similar sale back then, what have you done to improve the system based on those recommendations since then?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 25, 2018 at 9:40 am
May not help right now, but you may want to look at JMeter for functional and load testing. I mention it as I am just now starting to learn this product where I work. It does require Java 8 or 9 (not 10) and FireFox. Beyond that, I can't tell you much more as I am behind the learning curve compared to a couple of coworkers who have started using it before me.
September 25, 2018 at 9:57 am
coolchaitu - Tuesday, September 25, 2018 1:53 AMHi Experts,
We are a small e-commerce company, planning to start an offer in december. The offer would be online on some products. We are hoping many orders hitting the orders database. As a DBA, what should i do to make sure the sale goes without any issues.
What does your current architecture look like? Single server? Availability group? As mentioned above, knowing your current workload and approximately how many orders you process regularly can help know your breaking point. If it's a VM and you have more resources available on the host server, it might warrant giving it extra cores and memory. Baselines are helpful in these situations. ie, what does CPU, Memory and Disk look like under "normal" workload.
September 26, 2018 at 12:30 pm
As Jeff probably hinted before, tune some code. Add indexes, get some consulting help if you don't know how to do this.
Also, if management is worried, get faster storage on the system, with some of the new 3D SSD drives and double or quadruple ram.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply