Database size on IIS 5

Good Morning,
I have a web service developed using vb.net. The web
service returns xml from selected data (SQL SELECT
statement using XML AUTO) from SQL Server. The web service
runs properly on smaller databases on both IIS 5 (Windows
2000 Server) and IIS 6 (Windows 2003 Server), but returns
an error when run against larger databases on IIS 5. The
error has been 'out System.OutOfMemoryException'.
I am trying to figure out the difference between IIS 5 and
IIS 6 which is causing this, and a solution.I guess the database is too big for IIS5, so it can not run.
After all, when IIS5 design, no one can image a big database like we use
today.
I think If I am you, I will catch this exception and give the customer some
information to update the IIS.
Last: This is a problem of IIS, you may ask there

Database size on IIS 5

Good Morning,
I have a web service developed using vb.net. The web
service returns xml from selected data (SQL SELECT
statement using XML AUTO) from SQL Server. The web service
runs properly on smaller databases on both IIS 5 (Windows
2000 Server) and IIS 6 (Windows 2003 Server), but returns
an error when run against larger databases on IIS 5. The
error has been 'out System.OutOfMemoryException'.
I am trying to figure out the difference between IIS 5 and
IIS 6 which is causing this, and a solution.I guess the database is too big for IIS5, so it can not run.
After all, when IIS5 design, no one can image a big database like we use
today.
I think If I am you, I will catch this exception and give the customer some
information to update the IIS.
Last: This is a problem of IIS, you may ask there:)

Database Size is not grow automatically

Hi all,
One of my Database Size is not grow automatically (auto grow is set ON in
that DB).Help me to resolve this problem
B.Saminathan
Software Engineer
California Software Co. Ltd.
Elnet Software City, Taramani,
Chennai 600 113
saminathanb@.calsoft.co.in
tel: 22541464Hi
How do you know ?:-)
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>|||If the thread that forced the autogrow times out it can roll back the growth
as well. Never rely on Autogrow. If you know you need space then manually
grow the files at a proper time. All data and log files should have plenty
of free space at all times for proper operation.
Andrew J. Kelly SQL MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>|||Hi,
See if the hard drives where you placed the MDF and LDF have enough space
based on the growth rate (MB or %) you specified.
EG:- If you specify 1 GB growth and if you do not have 1 GB free in hard
disk then auto grow will not happen.
Thanks
Hari
SQL Server MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>

Database Size is not grow automatically

Hi all,
One of my Database Size is not grow automatically (auto grow is set ON in
that DB).Help me to resolve this problem
B.Saminathan
Software Engineer
California Software Co. Ltd.
Elnet Software City, Taramani,
Chennai 600 113
saminathanb@.calsoft.co.in
tel: 22541464
Hi
How do you know ?:-)
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>
|||If the thread that forced the autogrow times out it can roll back the growth
as well. Never rely on Autogrow. If you know you need space then manually
grow the files at a proper time. All data and log files should have plenty
of free space at all times for proper operation.
Andrew J. Kelly SQL MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>
|||Hi,
See if the hard drives where you placed the MDF and LDF have enough space
based on the growth rate (MB or %) you specified.
EG:- If you specify 1 GB growth and if you do not have 1 GB free in hard
disk then auto grow will not happen.
Thanks
Hari
SQL Server MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>
sql

Database Size is not grow automatically

Hi all,
One of my Database Size is not grow automatically (auto grow is set ON in
that DB).Help me to resolve this problem
B.Saminathan
Software Engineer
California Software Co. Ltd.
Elnet Software City, Taramani,
Chennai 600 113
saminathanb@.calsoft.co.in
tel: 22541464Hi
How do you know ?:-)
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>|||If the thread that forced the autogrow times out it can roll back the growth
as well. Never rely on Autogrow. If you know you need space then manually
grow the files at a proper time. All data and log files should have plenty
of free space at all times for proper operation.
--
Andrew J. Kelly SQL MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>|||Hi,
See if the hard drives where you placed the MDF and LDF have enough space
based on the growth rate (MB or %) you specified.
EG:- If you specify 1 GB growth and if you do not have 1 GB free in hard
disk then auto grow will not happen.
Thanks
Hari
SQL Server MVP
"Saminathan B" <saminathanb@.calsoft.co.in> wrote in message
news:ehuZFC9pFHA.364@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> One of my Database Size is not grow automatically (auto grow is set ON in
> that DB).Help me to resolve this problem
> B.Saminathan
> Software Engineer
> California Software Co. Ltd.
> Elnet Software City, Taramani,
> Chennai 600 113
> saminathanb@.calsoft.co.in
> tel: 22541464
>