Friday, February 24, 2012

allround maintance plan for many small SQL2005 DB.

Hello
We got about 10 Std. SQL2005 server with maney small DB (from 256mb-2GB)
most are at 500mb
I would like to have a good allround maintance plan with a full backup to
..bak files each day.
But on some of the server we sometime got slow perf. what is best to rebuild
index or re org index in my maint plan ?
CK
Run your backups at night when nobody is working. You have to identify
fragmented tables ( make sure that those tables have at least 1000 pages)
and rebuild indexes on them.
"CK" <fhf@.ggg.lo> wrote in message
news:15AE7194-875D-47C0-A066-945A515D0F8D@.microsoft.com...
> Hello
> We got about 10 Std. SQL2005 server with maney small DB (from 256mb-2GB)
> most are at 500mb
> I would like to have a good allround maintance plan with a full backup to
> .bak files each day.
> But on some of the server we sometime got slow perf. what is best to
> rebuild index or re org index in my maint plan ?
>

No comments:

Post a Comment