500 concurrent user SQL Server?

500 concurrent user SQL Server?

Post by yaels.. » Wed, 15 May 1996 04:00:00



We are new to the world of NT and SQL Server.
We are looking into build an application serving
500 concurrent users.

Is this feasible?
Should we play it safe and use UNIX...?

Help!

 
 
 

500 concurrent user SQL Server?

Post by Neil Pik » Thu, 16 May 1996 04:00:00


Quote:

> We are new to the world of NT and SQL Server.
> We are looking into build an application serving
> 500 concurrent users.

Perfectly feasible.  Look for machine with 2+ pentiums and 128Mb+ ram
(or an alpha box).  + a fast raid subsystem.

Neil Pike (MCSE)
Protech Computing Ltd (MS Solution Provider)

Using Virtual Access 3.20 build 117a (32-bit) on Tue, 14 May 96 19:33
GMT
On NT Server 3.51 SP4 / Windows 95 SP1

 
 
 

500 concurrent user SQL Server?

Post by Iván Mingo » Fri, 17 May 1996 04:00:00



> =

> > We are new to the world of NT and SQL Server.
> > We are looking into build an application serving
> > 500 concurrent users.

> =
> Perfectly feasible.  Look for machine with 2+ pentiums and 128Mb+ ram
> (or an alpha box).  + a fast raid subsystem.
> =
> Neil Pike (MCSE)
> Protech Computing Ltd (MS Solution Provider)

> Using Virtual Access 3.20 build 117a (32-bit) on Tue, 14 May 96 19:33
> GMT
> On NT Server 3.51 SP4 / Windows 95 SP1k

-- =

______Iv=E1n Mingot Latorre_______________________________________________

Centro de proceso de Datos               |http://www.ua.es/~Ivan.Mingot
Universidad de Alicante                  |
Alicante 03080   Espa=F1a/Spain            |     Un cordial saludo.
Telef / Phone: 96 590 34 00 Ext 3096     |         Iv=E1n.
Fax :  96 590 34 64                      |    =

________________________________________________________________________

 
 
 

500 concurrent user SQL Server?

Post by Olav Tollefs » Tue, 21 May 1996 04:00:00




> We are new to the world of NT and SQL Server.
> We are looking into build an application serving
> 500 concurrent users.

> Is this feasible?
> Should we play it safe and use UNIX...?

No problem we use it internally with more than 3000 concurrent users.

--
- Olav Tollefsen
- Microsoft Norway
-
- Author of News for Windows NT (http://www.ksedb.no/NTNews)
- Nothing I have written here is in any way, shape, or form official
- Microsoft policy or opinion, and should not be represented as such
- when quoted here or in any other forum.  

 
 
 

500 concurrent user SQL Server?

Post by Thom » Thu, 30 May 1996 04:00:00



>We are new to the world of NT and SQL Server.
>We are looking into build an application serving
>500 concurrent users.
>Is this feasible?
>Should we play it safe and use UNIX...?
>Help!

It is feasible and it is being done.  SQL Server's storage limitation
is 4 terabytes I think so the rest is a question of architecture.
There is actually a great article on this debate in last month's
edition of Byte magazine.
 
 
 

500 concurrent user SQL Server?

Post by Sameer Padhy » Sat, 01 Jun 1996 04:00:00




> >We are new to the world of NT and SQL Server.
> >We are looking into build an application serving
> >500 concurrent users.

> >Is this feasible?
> >Should we play it safe and use UNIX...?

> >Help!

> It is feasible and it is being done.  SQL Server's storage limitation
> is 4 terabytes I think so the rest is a question of architecture.
> There is actually a great article on this debate in last month's
> edition of Byte magazine.

Could you please mention the hardware configuration
of the machine which is supporting 500 concurrent
users.[I am assuming that concurrent means that all
of them show up as runnable/running in sp_who?].
Our system kinda starts slowing with 10 runnable
users at the same time.[I am aware that good
design, indexes, etc are important but I am still
interested in the hardware configuration.CPU,
memory, HD, striped or not, etc...]

Thank in Advance
Sameer

 
 
 

1. MS-SQL Server able to manage 500 GigaBytes with 400 concurrent users

Hello,

I'm looking for people who got experiences in the management of databases
with strong constraints (volume, number of concurrent users and response time).

Here are the caracteristics the database should respect :
        - Operating system : Windows NT (or Unix)
        - Database: either SQL Server6.5
                 or Oracle Server (or Oracle Enterprise Server).
        - Volume : 350 GigaBytes
        - Number of concurrent users : 100
        - Response time : < 1 secondes.

This database is connected to an Intranet with an access at 64 kbit/s.

Does someone already install a database with such constraints ?
I'm not sure that a Windows NT-based server with SQL Server is the right
choice since SQL Server6.5 seems to not respect the main constraints
(volume and number of concurrent users).

If anybody has already encounter this problem, I will appreciate his point of
view.

Laurent.

2. US-IL-Chicago Sybase DBA Position - 100K plus

3. MS-SQL Server able to manage 500 gigabytes with 400 concurrent users

4. Index causes incorrect results in SQL Server 2000 SP3

5. Sqlserver 2000 Hardware Requirements for 500 concurrent users.

6. Replication between Access and SQL Server

7. DBMS selection for 500+GB and 500+users

8. Block Corruptions

9. DBMS Selection for 500+GB data and 500+ Users

10. Looking for large (500+ user) SQL Server SMP UNIX Sites