How many binary downloads can SQL Server handle?

Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
download it.. can SQL Server handle that?
It's on a dedicated machine, just one server, no load balancing and such.Hi
It is not clear why you would want to hold such large binary files within
the database. The most likely bottleneck will be your network especially if
you only have one NIC.
John
"the friendly display name" wrote:
> Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> download it.. can SQL Server handle that?
> It's on a dedicated machine, just one server, no load balancing and such.|||It's not in our office, we're hosting externaly. So the network isn't the
problem.
Why are we doing it:
We offer files (self-made programs), the customer needs to be authorized to
be able to download them. We're offering currently over 20 files, each file
is in a certain group.. the customer can be in group 1, group 2, group 3...
and he can only download files, which are in the same group as him.
How to make that just with IIS? OK, forms auth., but you can only lock
certain folders, not files, and you can't do it programmaticaly, just with
web.config.
To offer them over the SQL Server.. I think it's the easiest way. If you
know better ways to do that, I'll listen.
"John Bell" wrote:
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
> > Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> > download it.. can SQL Server handle that?
> >
> > It's on a dedicated machine, just one server, no load balancing and such.|||Well, is SQL Server able to handle so many downloads with such configuration?
"John Bell" wrote:
> Hi
> It is not clear why you would want to hold such large binary files within
> the database. The most likely bottleneck will be your network especially if
> you only have one NIC.
> John
> "the friendly display name" wrote:
> > Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> > download it.. can SQL Server handle that?
> >
> > It's on a dedicated machine, just one server, no load balancing and such.|||Hi
It could, but you will have to do your own benchmark on your own servers to
see if your configuration is up to it. Your solution will not be as scalable
as one that only stores pointers in the database and restricting access via
what they can retrieve.
John
"the friendly display name" wrote:
> Well, is SQL Server able to handle so many downloads with such configuration?
> "John Bell" wrote:
> > Hi
> >
> > It is not clear why you would want to hold such large binary files within
> > the database. The most likely bottleneck will be your network especially if
> > you only have one NIC.
> >
> > John
> >
> > "the friendly display name" wrote:
> >
> > > Let's asume we saved a 40 MB file in SQL Server, and 100 people at once will
> > > download it.. can SQL Server handle that?
> > >
> > > It's on a dedicated machine, just one server, no load balancing and such.