question

chetanserantec avatar image
chetanserantec asked

How to handle 100000 users request with sql server which not decrease sql server performance? please guide me here.

How to handle 100000 users request with sql server which not decrease sql server performance? please guide me here.

performancesql server 2014performance-tuningsql server 2017
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Is that 100,000 active queries, or 100,000 simultaneously-connected users doing their thing so not necessarily hammering the snot out of the server?

0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered

The obvious is to throw hardware at the problem, so:

  • CPUs. Lot of 'em, as fast as possible
  • Memory. Lots of it, ditto
  • Disks. The fastest possible, as near to the server as possible
  • Network. The fastest possible, and lots of it.
  • Read-only stuff? Get that off that primary server and put it on a readable secondary

However, no amount of hardware is going to fix a badly-written application running against a badly-designed, inadequately-indexed database.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

chetanserantec avatar image
chetanserantec answered

actually users like on e shoping cart, cricket score application like all that who fetch data from database at same time like cricket score.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Live cricket scores? They're not so fast-moving that you can't get away with some decent caching algorithms. Historical scores can be offloaded onto a server away from the updating stuff.

e-shopping, though, that needs to be carefully designed, particularly if you're doing stock-checking at the same time.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.