Breaking Point

Hi,
We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
2003 (Standard Ed, 32bit) for our company.
I would like to know the breaking point of the following so we can foresee
any problems and perhaps be able to avoid them.
There will be a huge amount of pictures to be stored in our server. Where
will pics be stored? as BLOBS in SQL or as files?
I am new to this and appreciate any info. We have been ripped off by an IT
consultant before so am trying to learn as well.
Thanks,
Ian
PhilippinesIt will not be good practice to place huge pictures in BLOBs in sql server.if
possible you can arrange an file or image server and mapp them to application.
"Ian" wrote:
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||If you can, place pictures in filesystem and links to them in database.
MC
"Ian" <Ian@.discussions.microsoft.com> wrote in message
news:DC7B1026-6DB6-493A-9B99-8CF719840007@.microsoft.com...
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||Thanks,
Do you know of any breaking points with SQL Server 2005 and WIndows Server
2003?
Ian
"Khwaja Arshaduddin" wrote:
> It will not be good practice to place huge pictures in BLOBs in sql server.if
> possible you can arrange an file or image server and mapp them to application.
>
> "Ian" wrote:
> > Hi,
> >
> > We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> > 2003 (Standard Ed, 32bit) for our company.
> > I would like to know the breaking point of the following so we can foresee
> > any problems and perhaps be able to avoid them.
> >
> > There will be a huge amount of pictures to be stored in our server. Where
> > will pics be stored? as BLOBS in SQL or as files?
> >
> > I am new to this and appreciate any info. We have been ripped off by an IT
> > consultant before so am trying to learn as well.
> >
> > Thanks,
> >
> > Ian
> > Philippines
> >|||Why is it not good practive to place pics in BLOBs?
Thanks again,
Ian
"Khwaja Arshaduddin" wrote:
> It will not be good practice to place huge pictures in BLOBs in sql server.if
> possible you can arrange an file or image server and mapp them to application.
>
> "Ian" wrote:
> > Hi,
> >
> > We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> > 2003 (Standard Ed, 32bit) for our company.
> > I would like to know the breaking point of the following so we can foresee
> > any problems and perhaps be able to avoid them.
> >
> > There will be a huge amount of pictures to be stored in our server. Where
> > will pics be stored? as BLOBS in SQL or as files?
> >
> > I am new to this and appreciate any info. We have been ripped off by an IT
> > consultant before so am trying to learn as well.
> >
> > Thanks,
> >
> > Ian
> > Philippines
> >|||As i posted earlier LARGE image file should not be loaded that is becuase
BLOBs store picture as text datatype u can find datatype in BOL .there will
be a severe impact on performance of database
"Ian" wrote:
> Why is it not good practive to place pics in BLOBs?
> Thanks again,
> Ian
> "Khwaja Arshaduddin" wrote:
> > It will not be good practice to place huge pictures in BLOBs in sql server.if
> > possible you can arrange an file or image server and mapp them to application.
> >
> >
> > "Ian" wrote:
> >
> > > Hi,
> > >
> > > We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> > > 2003 (Standard Ed, 32bit) for our company.
> > > I would like to know the breaking point of the following so we can foresee
> > > any problems and perhaps be able to avoid them.
> > >
> > > There will be a huge amount of pictures to be stored in our server. Where
> > > will pics be stored? as BLOBS in SQL or as files?
> > >
> > > I am new to this and appreciate any info. We have been ripped off by an IT
> > > consultant before so am trying to learn as well.
> > >
> > > Thanks,
> > >
> > > Ian
> > > Philippines
> > >|||> As i posted earlier LARGE image file should not be loaded that is becuase
> BLOBs store picture as text datatype u can find datatype in BOL .there
> will
> be a severe impact on performance of database
No , SQL Server stores it in BINARY format
"Khwaja Arshaduddin" <KhwajaArshaduddin@.discussions.microsoft.com> wrote in
message news:380520D9-7BEF-4CFF-82F8-486304BA5B38@.microsoft.com...
> As i posted earlier LARGE image file should not be loaded that is becuase
> BLOBs store picture as text datatype u can find datatype in BOL .there
> will
> be a severe impact on performance of database
> "Ian" wrote:
>> Why is it not good practive to place pics in BLOBs?
>> Thanks again,
>> Ian
>> "Khwaja Arshaduddin" wrote:
>> > It will not be good practice to place huge pictures in BLOBs in sql
>> > server.if
>> > possible you can arrange an file or image server and mapp them to
>> > application.
>> >
>> >
>> > "Ian" wrote:
>> >
>> > > Hi,
>> > >
>> > > We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS
>> > > Server
>> > > 2003 (Standard Ed, 32bit) for our company.
>> > > I would like to know the breaking point of the following so we can
>> > > foresee
>> > > any problems and perhaps be able to avoid them.
>> > >
>> > > There will be a huge amount of pictures to be stored in our server.
>> > > Where
>> > > will pics be stored? as BLOBS in SQL or as files?
>> > >
>> > > I am new to this and appreciate any info. We have been ripped off by
>> > > an IT
>> > > consultant before so am trying to learn as well.
>> > >
>> > > Thanks,
>> > >
>> > > Ian
>> > > Philippines
>> > >|||Hi
You may want to read
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
As far as breaking point this is will be significntly dependent on the
hardware and application, therefore running your own performance/stress tests
is about the only way you are really going to have some idea of what the
system is capable of. Products such as LoadRunner, Rational Performance
Tester, Visual Studio Team Edition for Software Testers
http://msdn2.microsoft.com/en-us/teamsystem/aa718823.aspx or Visual Studio
Team Suite can all help you performance test your web application(s).
John
"Ian" wrote:
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||yes uri is correct it is binary... thanks uri
"Uri Dimant" wrote:
> > As i posted earlier LARGE image file should not be loaded that is becuase
> > BLOBs store picture as text datatype u can find datatype in BOL .there
> > will
> > be a severe impact on performance of database
> No , SQL Server stores it in BINARY format
>
>
> "Khwaja Arshaduddin" <KhwajaArshaduddin@.discussions.microsoft.com> wrote in
> message news:380520D9-7BEF-4CFF-82F8-486304BA5B38@.microsoft.com...
> > As i posted earlier LARGE image file should not be loaded that is becuase
> > BLOBs store picture as text datatype u can find datatype in BOL .there
> > will
> > be a severe impact on performance of database
> >
> > "Ian" wrote:
> >
> >> Why is it not good practive to place pics in BLOBs?
> >>
> >> Thanks again,
> >>
> >> Ian
> >>
> >> "Khwaja Arshaduddin" wrote:
> >>
> >> > It will not be good practice to place huge pictures in BLOBs in sql
> >> > server.if
> >> > possible you can arrange an file or image server and mapp them to
> >> > application.
> >> >
> >> >
> >> > "Ian" wrote:
> >> >
> >> > > Hi,
> >> > >
> >> > > We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS
> >> > > Server
> >> > > 2003 (Standard Ed, 32bit) for our company.
> >> > > I would like to know the breaking point of the following so we can
> >> > > foresee
> >> > > any problems and perhaps be able to avoid them.
> >> > >
> >> > > There will be a huge amount of pictures to be stored in our server.
> >> > > Where
> >> > > will pics be stored? as BLOBS in SQL or as files?
> >> > >
> >> > > I am new to this and appreciate any info. We have been ripped off by
> >> > > an IT
> >> > > consultant before so am trying to learn as well.
> >> > >
> >> > > Thanks,
> >> > >
> >> > > Ian
> >> > > Philippines
> >> > >
>
>|||At my last job, we used the database to store tif images. The tifs were
images of mandates which had bank details on so it made sense to store them
in the database as opposed to the filesystem. We took steps to try and ensure
the best performance, such as putting the blob column into a seperate
filegroup which we put onto a seperate raid array to the main database. The
mandates were scanned in as tifs, inserted into the db, and were viewable
from an asp front end, and tbh the solution worked well.
From a performance pov it'll be down to the quality of product, and the spec
of the machine.. ..a decent storage solution for this is a must.. ..also
spend some time on capacity planning, you'll find the db will grow quickly so
spend some time setting it up properly from the start...
"Ian" wrote:
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>|||Ian:
You'll love my response. It's the same as pretty much all of my other
responses:
"It depends".
Do you need to store your images transactionally? That is, it
critically important that your images are there when the database SAYS
they're there? If so, put 'em in the database.
Do you need to read the files from something like a Web server which
serves up a lot of other static content? If so, lean towards the
filesystem.
How big are these files? "Huge" means something very different these
days vs. 5 years ago. What are your size projections? A couple of
gigs? No problem, either way. A couple of terabytes? Do you want to
minimize the load on the database when retrieving images? How many
users are you going to support? These are all considerations.
Note that you'll have to be much more careful about how you size your
database files with the images inside the DB. I'd (sometimes, it
depends) recommend putting the tables storing the images in a different
filegroup...
Also note that in SQL Server 2005, you should use VARBINARY(MAX) instead
of IMAGE. IMAGE and TEXT datatypes are deprecated as of the new version.
-Dave
Ian wrote:
> Hi,
> We recently bought MS SQL Server 2005 (Standard Ed, 32bit) and MS Server
> 2003 (Standard Ed, 32bit) for our company.
> I would like to know the breaking point of the following so we can foresee
> any problems and perhaps be able to avoid them.
> There will be a huge amount of pictures to be stored in our server. Where
> will pics be stored? as BLOBS in SQL or as files?
> I am new to this and appreciate any info. We have been ripped off by an IT
> consultant before so am trying to learn as well.
> Thanks,
> Ian
> Philippines
>
-Dave Markle
http://www.markleconsulting.com/blog