Paul Pedersen wrote:
> I have a small (12 MB) database. I don't think it's full, but in any
> case it's set to grow without limit as necessary.
>
> It is accessed only by MSDE on the same machine, and then only by one
> application, via ODBC.
>
> Everything was working until about a month ago, when it became very
> slow. Even just connecting to it sometimes takes 30 seconds. It used
> to be instantaneous. Now sometimes it just times out.
>
> What could be going wrong?

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:49fkm4Fo8uirU1@individual.net...
> hi Paul,
> Paul Pedersen wrote:
>> I have a small (12 MB) database. I don't think it's full, but in any
>> case it's set to grow without limit as necessary.
>>
>> It is accessed only by MSDE on the same machine, and then only by one
>> application, via ODBC.
>>
>> Everything was working until about a month ago, when it became very
>> slow. Even just connecting to it sometimes takes 30 seconds. It used
>> to be instantaneous. Now sometimes it just times out.
>>
>> What could be going wrong?
>
> do you (regularly) defragment your machine?

> and do you (regularly) perform database maintenance and indexes
> defragmentation?

> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>