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.i
f
possible you can arrange an file or image server and mapp them to applicatio
n.
"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:
[vbcol=seagreen]
> 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 applicat
ion.
>
> "Ian" wrote:
>|||Why is it not good practive to place pics in BLOBs?
Thanks again,
Ian
"Khwaja Arshaduddin" wrote:
[vbcol=seagreen]
> 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 applicat
ion.
>
> "Ian" 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
"Ian" wrote:
[vbcol=seagreen]
> Why is it not good practive to place pics in BLOBs?
> Thanks again,
> Ian
> "Khwaja Arshaduddin" 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...[vbcol=seagreen]
> 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:
>|||Hi
You may want to read
http://databases.aspfaq.com/databas...filesystem.html
As far as breaking point this is will be significntly dependent on the
hardware and application, therefore running your own performance/stress test
s
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/te...m/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:

> No , SQL Server stores it in BINARY format
>
>
> "Khwaja Arshaduddin" <KhwajaArshaduddin@.discussions.microsoft.com> wrote i
n
> message news:380520D9-7BEF-4CFF-82F8-486304BA5B38@.microsoft.com...
>
>|||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 ensur
e
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 s
o
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
>