Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nic
Posting Yak Master
209 Posts |
 Posted - 2009-01-28 : 12:10:30
|
| Hi,Our company acts as a vendor, which sells a workflow product to companies. The company is responsible for maintaining the database etc. For one client (our largest) there are ~ 1.5 million main records in the system (some child tables have up to 80 million records). There are a few thousand main records that are touched/added each day (and all the corresponding child records). The backup file is ~20GB (just to give an idea of the size of the datbase).Since the company maintains the database, they are responsible for maintenance. I have always believed, rebuilding indexes, reorganizing tables should be done on some consistent schedule during off hours (perhaps once a week at night?).This client does not perform any maintenance on the database (besides backing it up). They state since there aren't that many records touched a day, rebuilding indexes aren't necessary (technically it is a SQL2k db, so I understand performing maintenance will take the database down). BUT to NEVER reindex or perform any optimization routines? I understand maybe not once a week, but I would think at some point they should do this (maybe once a month?). I just don't see why you would never perform any maintenance besides just regular backups.Unfortunately I can't force them to run maintenance, but it would be helpful if I knew if I wasn't way off base.Thanks,Nic |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-28 : 12:18:42
|
| Check the Fragmentation of table with DBCC showcontig or DMV in SQL 2005 and that decides whether you need to Reorganize or Rebuild.We support 100s of GB of database and we have atleast weekly maintenance to Reorg or Rebuild index. |
 |
|
|
|
|
|
importance of maintenance?