May 13, 2009 at 8:05 pm
Dear All,
I have a problems in my application, there are 30 million users in database and i don't have any idea for this problem. And now i'm finding an architecture for my database system.
Some ones can show me some solutions for my application ?
thanks so much.
May 14, 2009 at 4:37 am
Hi
30 million users? Congratulate to your sales management! 😛
I don't understand the specific problem. Do you have duplicates which have to be removed? Do you want to know how you should change the design for a better performance? If yes, which performance issue(s) do you have?
Greets
Flo
May 14, 2009 at 4:55 am
New database?
Existing database?
30 million concurrent users? If not, what's the estimate for concurrent users?
Expected database size?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 14, 2009 at 5:02 am
I hope you are not trrying to connect all users on a single instance of SQL Server . Only 32767 Users can be connected concurrently on SQL Server 2005. Normally, probability is very low that 32000 users accessing the SQL Server at the same time. But with 30 Million users, you might have the situation (assuming 30 million users at a time on a website).
Secondly, you will need a VERY SHARP SQL Developer as I think 70 - 80% performance issues can be resolved on the coding end.
May 14, 2009 at 6:25 am
linhdkl (5/13/2009)
Dear All,I have a problems in my application, there are 30 million users in database and i don't have any idea for this problem. And now i'm finding an architecture for my database system.
Some ones can show me some solutions for my application ?
thanks so much.
can you be a bit more specific about your issue? it's not clear what kind of issue you're experiencing: (e.g. perfromance issues on retrieving inforrmation, architecture issues due to concurrent connections... )
cheers,
Matt
May 14, 2009 at 6:42 am
Sounds like a good problem to have.
Buy a big box, with lots of memory... Sorry, but no one can help much past that without a lot more definition of the problem.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 14, 2009 at 6:51 am
and if you actually need speed....
- 64-bit
- CPU
- RAM
- SSD disk sistem (e.g. ramsan )
Start with asking a huge budget ( blanc cheque if you can :hehe: )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 14, 2009 at 7:24 am
I thought it's probably 30 million records, and not 30 million users, which I thought was on par witha Google sized-installation....but
just for fun, i searched for Google Searches per day...found a web site with some statistics:
for google alone, let alone other web sites:
they receive more than:
91,000,000 + searches per day (91 million for anyone whos eyes cross at more than 4 zeros)
63,000+ per minute
1000+ per second
Lowell
May 14, 2009 at 7:33 am
2 Big boxes?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 14, 2009 at 10:45 pm
@every body:
Thanks for your answer
But my question exactly is about architecture to design database system. When you have an application like that !
How do you organizer database ? (for best performance ofcouse )
thanks every body, but who body know any idea for my problem ?
May 14, 2009 at 10:54 pm
I'm still not sure what your problem is. Your statements are just too vague to know what your are actually asking us for. T make a simple guess, though, I'd say you need to hire a contractor. I don't think you are going to get much of an answer with a little as you are providing.
May 15, 2009 at 2:24 am
For systems like this, you have draw a visible line between OLTP and OLAP. You have to store Normalized data in one database and port it into OLAP database on defined periods.
Once again, Big efficient boxes and a sharp DBA required.
May 15, 2009 at 6:33 am
There just isn't enough information to really answer your question. I want to follow-up & seriously suggest you get someone with a bit more experience to help out.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2009 at 7:12 am
I asked a few questions earlier that haven't been answered.
There's no where near enough info to tell you anything useful. Furthermore, this isn't the kind of thing that you should be asking about on forums. If the DB is this busy, then you should really be getting a specialist in. Someone who knows what they're doing and can advise you as to design, hardware, etc, etc.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2009 at 4:38 am
hi every body !
thank every ones to answer my question, and now i find the solution for this problems, it is using Partitioned Tables and Indexes.
it's very very simple .... because I don't want anything more than a solution (other words you can call it's an idea). :w00t:
one again thank you.
:-D:-D:-D
Viewing 15 posts - 1 through 15 (of 23 total)
You must be logged in to reply to this topic. Login to reply