April 13, 2009 at 2:06 pm
Hi,
Can someone please tell me after how long time a database has to be maintained.
Thanks for your help.
April 13, 2009 at 2:55 pm
Hi,
What did you mean by this? Are you asking about maintaining indexes?
Well Daily maintenance includes backing up the database, veryfying database backups, defragging/rebuilding indexes, Updating statistics etc..
April 13, 2009 at 3:08 pm
everything that can keep database in healthy
April 13, 2009 at 3:16 pm
Musène Jonas (4/13/2009)
everything that can keep database in healthy
It depends on your business model.
But a basic plan goes like this:
1.) Full backups Everyday or Weekend at off hours
2.) Differential backups to increase the recovery point
3.) Tlog backups to meet your SLA's
4.) Backup your system databases
5.) Verify backups
6.) DBCC integrity checks on databases
7.) Identify indexes that are Fragmented
8.) Defrag those indexes whose fragmentation <30%
9.) Update statistics to indexes identified at step 5
10.) Rebuild indexes whose fragmentation >30%
and add steps if u need any
April 13, 2009 at 3:25 pm
from step 5, i have to these tests each month, each week, each day. give me an answer please.
we invoice everyday from 8h to 14h
April 13, 2009 at 3:30 pm
Musène Jonas (4/13/2009)
from step 5, i have to these tests each month, each week, each day. give me an answer please.we invoice everyday from 8h to 14h
It depends, what are your business requirements? what kind of operations run against your database daily?
April 14, 2009 at 7:48 am
We make posting after invoicing, we e-mail statement, we have accountants that make they job on the database etc..
April 14, 2009 at 12:18 pm
Musène Jonas (4/14/2009)
We make posting after invoicing, we e-mail statement, we have accountants that make they job on the database etc..
More insight into this please? I mean have you got many inserts or how frequent your data gets fragmented that sort of thing..
April 14, 2009 at 12:41 pm
I have got many insert
April 14, 2009 at 12:52 pm
That doesn't tell us anything.
In fact, I can't give you a hard and fast number for how often anything should be done.
Backup frequency: depends on your SLAs and your acceptable data loss in the case of a disaster
Integrity check frequency: depends on youtr backup strategy. Often enough that you can always restore from backups
Defragmentation frequency: Depends on how fast your indexes fragment. Often enough that the fragmentation doesn't cause performance problems.
You're the one who knows that, you're the one who has to decide. We can advice, but we can't tell you a hard and fast number that will always be right.
How much DBA experience do you have? Is there a senior DBA around?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2009 at 1:13 pm
Musène Jonas (4/14/2009)
I have got many insert
Gail made it clear, that's what I wanted to ask. I thought probably you would of know what I meant.
Thanks a lot Gail.
April 14, 2009 at 1:35 pm
I have three years ofexperience and there is no senior DBA around
April 14, 2009 at 1:39 pm
Musène Jonas (4/14/2009)
I have three years ofexperience and there is no senior DBA around
Hello Musene,
Then can you please make your answer clear to what we have asked?
April 14, 2009 at 1:40 pm
Gail and Me have already advised you about the plans. Are you still not clear about it?
April 14, 2009 at 1:49 pm
I am so clear, but these check have to be made every week if i do not want to loss many data
Viewing 15 posts - 1 through 15 (of 31 total)
You must be logged in to reply to this topic. Login to reply