Thursday, March 8, 2012

Application slowing down

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,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,|||Is this table indexed? Reading an unindexed table can
cause progressively slower response as it grows.
>--Original Message--
>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 decrease 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 plent
No other application is running on this box apart from the midtier application
Regards
-- Schu wrote: --
How is your harddrive room? Performance of the database writes will decrease dramatically if you are getting closer to filling up your harddrive.

No comments:

Post a Comment