Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vedjha
Posting Yak Master
228 Posts |
 Posted - 2009-09-22 : 08:13:09
|
| Hello Friends,I have a case study : to make more speed the performancecase study:I have a site which having approx 40,000 users and approx 5,000 user visits online simultaneously. User come on site, visit it, make Registration , see their Account and all that .As User Register on site There is Process of Querying Data and Transaction of data as(insert , delete, update) and simultaneously another user visit website and update there profile. and another way, Admin sail there Pin number online . there is a lots of (ad hoc query and transaction.)A lots of process going on simultaneously as Ad-hoc query, Views, Procedure are using .by these Process , Site become slow and it does not give performance.please give me suggestion to make performance of site from database side.Thank youVed Prakash Jha |
|
|
vedjha
Posting Yak Master
228 Posts |
Posted - 2009-09-22 : 09:57:45
|
| Plz give me suggestion , How to make speedVed Prakash Jha |
 |
|
|
|
|
|
Help me to make performance