Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Small database with 1 million users Expand / Collapse
Author
Message
Posted Monday, October 15, 2012 7:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 8:11 AM
Points: 232, Visits: 818
Hi all,

We've a small database (1 GB) and SQL 2005 server is clustered one. Now Business is forecasting that database will be accessed by million users by early next year.

Currently there are only 300 users using the database .

How to plan the resources for such a massive requirement?

Any help would be appreciated

Thanks in advance


Cheers
Post #1372726
Posted Monday, October 15, 2012 7:43 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
what about windows group access if it requires only same level of access..

Regards
Durai Nagarajan
Post #1372729
Posted Monday, October 15, 2012 7:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 8:11 AM
Points: 232, Visits: 818
Thanks for your response but i am not worried about giving access through AD group.

My question is how much CPU, Disk etc is required so that users can access the database without any bottlenecks
Post #1372732
Posted Monday, October 15, 2012 7:52 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 6:00 AM
Points: 3,478, Visits: 1,074
What is the server meant for ? Reporting or transactions? What is the budget ?


Post #1372737
Posted Monday, October 15, 2012 7:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
but i am not worried about giving access through AD group.


what is the thing you are worried about?


Regards
Durai Nagarajan
Post #1372738
Posted Monday, October 15, 2012 7:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 8:11 AM
Points: 232, Visits: 818
This is a archived database and data is viewed via a managed solution. Budget is not an issue
Post #1372740
Posted Tuesday, October 16, 2012 5:44 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:01 AM
Points: 2,840, Visits: 3,968
..

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1373164
Posted Tuesday, October 16, 2012 5:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:01 AM
Points: 2,840, Visits: 3,968
Sqlsavy (10/15/2012)
How to plan the resources for such a massive requirement?
there is not any hard and fast rule for hardware upgradation , it depends on variuos factors like

no of concurrent users (in future)
Disaster recovery plan
data growth
how will you handle reports (same or different server ) in future
disk management
AND how much rich or complex application would be in future from resource comsumption point of view
etc etc


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1373165
Posted Tuesday, October 16, 2012 6:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 8:11 AM
Points: 232, Visits: 818
Thanks!
Post #1373195
Posted Tuesday, October 16, 2012 7:17 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:05 AM
Points: 4,364, Visits: 6,206
Sqlsavy (10/15/2012)
Hi all,

We've a small database (1 GB) and SQL 2005 server is clustered one. Now Business is forecasting that database will be accessed by million users by early next year.

Currently there are only 300 users using the database .

How to plan the resources for such a massive requirement?

Any help would be appreciated

Thanks in advance


Cheers


There are MANY factors that come into play when trying to get SQL Server to the extremes of scale. And they aren't all inside SQL Server or the Windows server itself either. Application connection pooling, network latency/bandwidth are two that come to mind outside the server. Networking stack configuration on the server will be key. Inside SQL, wow - the list of things that could be a bottleneck or may need to be tweaked is long, everything from latching issues to minimum memory per query.

You REALLY need to get an expert consultant involved sooner rather than later. You need a VERY VERY THOROUGH scalability testing plan, because I GUARANTEE you that you will run into things that will need to be dealt with. For example, I think you will need to avoid having a different login per user too - the login validation and security/access overhead would be overwhelming I think.

Honestly my gut says SQL Server cannot do 1M concurrent users on access regardless of hardware capabilities. I imagine you will need to have a scale-out approach if you need any reasonable fraction of those 1M users connected at the same time. Of course there is (currently) no version of SQL Server that can do this out of the box, so you will need to be creative.

In any case, best of luck with it, and please keep us apprised of your activities and how things go. I have helped some clients over the years get to extreme scale on SQL Server (7400+ databases on one server for example), and it is always interesting!! BTW, I would LOVE to help you try to get this to work.


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1373232
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse