maintenance

Does maintenance can reduce time to perform request '
I'm using sql server 2000 sp3 on windows 2003 server. My server worked well
and became so long day after day. Does it normal '
Does maintenance can reduce access time request ' Can I do maintenance when
server is working '
Regards,It is quite natural for performance to degrade over time as indexes become f
ragmented and forwarding pointers become more prevalent. These issues need t
o be maintained using DBCC INDEXDEFRAG (online) or DBCC DBREINDEX (offline).
Have a look in BOL for fur
ther syntax details.
HTH,
Paul Ibison|||Hi,
Performance will go down once the fragmentation become more. Fragmentation
occurs due to the modifications in table data with DML (Insert/upate
/delete).
How will you identify table is fragmented:
DBCC SHOWCONTIG('table_name')
Below is my maintenance schedule:
Daily - UPDATE STATISTICS
Weekly - DBCC DBREINDEX
Weekly :- DBCC CHECKDB, DBCC CHECKALLOC,DBCC CTALOG
I recommend you to do the maintenance when there is very less user activity.
Thanks
Hari
MCDBA
"lediteur" <anonymous@.discussions.microsoft.com> wrote in message
news:7306E525-C854-42D0-9566-08812DB33521@.microsoft.com...
> Does maintenance can reduce time to perform request '
> I'm using sql server 2000 sp3 on windows 2003 server. My server worked
well and became so long day after day. Does it normal '
> Does maintenance can reduce access time request ' Can I do maintenance
when server is working '
> Regards,