August 28, 2008 at 7:56 pm
Hi, i was a developer before had done little administeration but now i have task to do for maintenance plan. i have already create script or doing some defragmantation task update statistics but it is only for offline. i don't have more knowledge one things i can do while production is online. can i get any help on the process there something we can do without having downtime or i can work on and make improve on performance. and also DTA does is have any impact. just want wanted to know.
August 29, 2008 at 7:14 am
The single most important thing you have to have is a backup strategy aligned with business needs.
Once you have that in place the most important thing you have to remember is "if it's not broken don't try to fix it!"
Most performance issues can be traced to poorly written queries and lack of proper indexing; I would tackle "performance issues" as they come, one at a time. Identify the offending query, check execution plan, check index strategy.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 29, 2008 at 7:49 am
Spend some time on Paul Randal's web site and blog. http://www.sqlskills.com/default.asp
He and Kimberly Tripp (same site) have a whole series of posts and articles on the "Accidental DBA" which is exactly what you are now 😉
Additionally, if you are going to be responsible for administration for a long time you need to get one of the SQL admin books. WROX, OReilly, MS Press, SAMS, and others all have adequate titles to get you started.
Good luck.
August 29, 2008 at 9:06 am
Sagar (8/28/2008)
i have already create script or doing some defragmantation task update statistics but it is only for offline. i don't have more knowledge one things i can do while production is online.
I have a stored procedure that could help you with this.
http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
Please let me know if you have any questions.
Ola Hallengren
August 29, 2008 at 8:31 pm
thank you very very much it is big support..
thanks again to all, i will post later later for my query and informatinon till then
happy great great weekend
sagar
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply