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 fragmented and forwarding pointers become more prevalent. These issues need to 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,
sql
Showing posts with label perform. Show all posts
Showing posts with label perform. Show all posts
Wednesday, March 21, 2012
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 fragmented and forwarding pointers become more prevalent. These issues need to be maintained using DBCC INDEXDEFRAG (online) or DBCC DBREINDEX (offline). Have a look in BOL for further 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,
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 fragmented and forwarding pointers become more prevalent. These issues need to be maintained using DBCC INDEXDEFRAG (online) or DBCC DBREINDEX (offline). Have a look in BOL for further 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,
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,
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,
Monday, March 12, 2012
maint plans xp_sqlmaint db bkups and using the backup commands
Is there a difference between performing a database back up using the maint
plan(xp_sqlmaint) or using the BACKUP command?
Does the xp_sqlmaint perform a FULL backup including the trans logs? And is
it performing a BACKUP LOG? (I would assume no it's not doing a backup log).
Is correct to say the both ways of db backups methods can be used to restore
a database to the point of that backup?
The only difference I note is that the main plans creates date/stamp and you
can keep several copies that you can see.
It does a backup log if you tell it to backup the log. Otherwise it doesn't
backup the log. It does a full backup when you tell it to backup the db.
In both cases it uses the same BACKUP DATABASE or BACKUP LOG command that
you would use.
Andrew J. Kelly SQL MVP
"Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in
message news:3B2752D3-94DC-4136-8069-E33833DA37C5@.microsoft.com...
> Is there a difference between performing a database back up using the
> maint
> plan(xp_sqlmaint) or using the BACKUP command?
> Does the xp_sqlmaint perform a FULL backup including the trans logs? And
> is
> it performing a BACKUP LOG? (I would assume no it's not doing a backup
> log).
> Is correct to say the both ways of db backups methods can be used to
> restore
> a database to the point of that backup?
> The only difference I note is that the main plans creates date/stamp and
> you
> can keep several copies that you can see.
plan(xp_sqlmaint) or using the BACKUP command?
Does the xp_sqlmaint perform a FULL backup including the trans logs? And is
it performing a BACKUP LOG? (I would assume no it's not doing a backup log).
Is correct to say the both ways of db backups methods can be used to restore
a database to the point of that backup?
The only difference I note is that the main plans creates date/stamp and you
can keep several copies that you can see.
It does a backup log if you tell it to backup the log. Otherwise it doesn't
backup the log. It does a full backup when you tell it to backup the db.
In both cases it uses the same BACKUP DATABASE or BACKUP LOG command that
you would use.
Andrew J. Kelly SQL MVP
"Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in
message news:3B2752D3-94DC-4136-8069-E33833DA37C5@.microsoft.com...
> Is there a difference between performing a database back up using the
> maint
> plan(xp_sqlmaint) or using the BACKUP command?
> Does the xp_sqlmaint perform a FULL backup including the trans logs? And
> is
> it performing a BACKUP LOG? (I would assume no it's not doing a backup
> log).
> Is correct to say the both ways of db backups methods can be used to
> restore
> a database to the point of that backup?
> The only difference I note is that the main plans creates date/stamp and
> you
> can keep several copies that you can see.
maint plans xp_sqlmaint db bkups and using the backup commands
Is there a difference between performing a database back up using the maint
plan(xp_sqlmaint) or using the BACKUP command?
Does the xp_sqlmaint perform a FULL backup including the trans logs? And is
it performing a BACKUP LOG? (I would assume no it's not doing a backup log)
.
Is correct to say the both ways of db backups methods can be used to restore
a database to the point of that backup?
The only difference I note is that the main plans creates date/stamp and you
can keep several copies that you can see.It does a backup log if you tell it to backup the log. Otherwise it doesn't
backup the log. It does a full backup when you tell it to backup the db.
In both cases it uses the same BACKUP DATABASE or BACKUP LOG command that
you would use.
Andrew J. Kelly SQL MVP
"Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in
message news:3B2752D3-94DC-4136-8069-E33833DA37C5@.microsoft.com...
> Is there a difference between performing a database back up using the
> maint
> plan(xp_sqlmaint) or using the BACKUP command?
> Does the xp_sqlmaint perform a FULL backup including the trans logs? And
> is
> it performing a BACKUP LOG? (I would assume no it's not doing a backup
> log).
> Is correct to say the both ways of db backups methods can be used to
> restore
> a database to the point of that backup?
> The only difference I note is that the main plans creates date/stamp and
> you
> can keep several copies that you can see.
plan(xp_sqlmaint) or using the BACKUP command?
Does the xp_sqlmaint perform a FULL backup including the trans logs? And is
it performing a BACKUP LOG? (I would assume no it's not doing a backup log)
.
Is correct to say the both ways of db backups methods can be used to restore
a database to the point of that backup?
The only difference I note is that the main plans creates date/stamp and you
can keep several copies that you can see.It does a backup log if you tell it to backup the log. Otherwise it doesn't
backup the log. It does a full backup when you tell it to backup the db.
In both cases it uses the same BACKUP DATABASE or BACKUP LOG command that
you would use.
Andrew J. Kelly SQL MVP
"Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in
message news:3B2752D3-94DC-4136-8069-E33833DA37C5@.microsoft.com...
> Is there a difference between performing a database back up using the
> maint
> plan(xp_sqlmaint) or using the BACKUP command?
> Does the xp_sqlmaint perform a FULL backup including the trans logs? And
> is
> it performing a BACKUP LOG? (I would assume no it's not doing a backup
> log).
> Is correct to say the both ways of db backups methods can be used to
> restore
> a database to the point of that backup?
> The only difference I note is that the main plans creates date/stamp and
> you
> can keep several copies that you can see.
Subscribe to:
Posts (Atom)