Application slowing down

We ahve an in house developpped applicatio running on SQL Server 2000, on Wi
ndows 200 server.
The DB is 600 Mo and one table is 410 Mo...This is the one which is the most
used (122 users).
the application is running slower and slower every day and we have to reboot
the server twice a week.
Could this be due to the size of that one table?
IT has been working ok in the past, but it looks as if the growth of this ta
ble is slowing down the application?
Thank you for your expertise.
Regards,If rebooting causes the app to speedup you are usually running out of memory
and start swapping with the OS. How much ram do you have and what are your
memory settings in SQL Server? What else is running on the box other than
SQL Server?
Andrew J. Kelly SQL MVP
"Arno" <anonymous@.discussions.microsoft.com> wrote in message
news:5D9A9E94-E7FE-4362-816F-74527C369EAC@.microsoft.com...
> We ahve an in house developpped applicatio running on SQL Server 2000, on
Windows 200 server.
> The DB is 600 Mo and one table is 410 Mo...This is the one which is the
most used (122 users).
> the application is running slower and slower every day and we have to
reboot the server twice a week.
> Could this be due to the size of that one table?
> IT has been working ok in the past, but it looks as if the growth of this
table is slowing down the application?
> Thank you for your expertise.
> Regards,|||How is your harddrive room? Performance of the database writes will decreas
e dramatically if you are getting closer to filling up your harddrive.|||Thank you all for your answers.
We have 3 Gb of RAM --> 2 Gb for SQL Server and it doesnot get fully used.
We have a 72 Gb hard drive (mirrored 2 x 72 Gb) --> so it is plenty
No other application is running on this box apart from the midtier applicati
on.
Regards,
-- Schu wrote: --
How is your harddrive room? Performance of the database writes will decreas
e dramatically if you are getting closer to filling up your harddrive.