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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2011-11-11 : 08:10:20
|
| Hi Experts,I have a small doubt please clarify me. In one of my server in which i got more then 50 databases. In these there are some high availability (Logshipping)is configured. in this server they have not implemented any maintenance (i.e. Update stats, Rebuild Index & Shrink database) on this database's so they are facing performance issues on these all databases. Now my doubt is can we plan for any maintenance plan on these (Including Logshipping Databases) to over come performance issues...Please suggest me about it...Thanking you in advance. |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-11 : 12:28:54
|
| You should have plans for rebuilding indexes (this will also update the statistics). However, do not include shrink database in your plan. That's a bad practice. |
 |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2011-11-11 : 13:38:23
|
| Ok thank you Vikki. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-11-11 : 17:50:22
|
| Note that when you start the maintenance it may generate HUGE log files, which may cause network problems shipping to the remote servers.Ideally use "intelligent" maintenance which will only rebuild indexes that are badly fragmented, and perhaps generate log backups much more frequently than normal (we normally backup log files every 15 minutes, but during index rebuilds we increase that to ever 2 minutes - same total size of log backup files, but less "stress" on the LDF files) |
|
|
|
|
|
|
Maintenance Plan on Logshipping Database