Recommendations For Using the SQL Server 2005 Best Practices Analyzer
- by Scott Whigham on December 19, 2008 8:47 AMThe SQL 2005 BPA can be found here: SQL Server 2005 Best Practices Analyzer
Do:
- Take full, differential, and/or log backups (whichever is appropriate) before running the analyzer (so you don't get warnings/information messages that clutter the report)
- Prior to running the BPA, run DBCC CHECKDB commands on your DBs (if you don't, you'll again get cluttered reports)
- Install on a test server first just to get used to the output and understand everything
- Run this on your test and development servers as well as your production systems. It's funny to me how DBAs lock down production servers and leave dev/test servers wide open.
- Schedule recurring scans and compare to your baseline
Don't:
- Don't run this on a production machine in the middle of the work day - run it at off-peak times. It's the Uncertainty Principle: watching changes behavior. Running the Best Practices Analyzer will have an effect on performance. In the docs, MSFT says that the BPA will use 50 to 75 percent CPU capacity while the instance of SQL Server is being scanned. I don't see nearly this much on my servers (more like 10%-15%) but since they say it, I'm concerned about running it in the middle of the day.
- Don't run this at the same time that system maintenance jobs are being run. You don't want the BPA and your DBCC CHECKDB job to compete for system resources.
This site truly keeps getting more impressive every day. You should certainly be satisfied.
Fascinating write-up. Had been investigating this subject matter on google when I discovered your blog. A lot of great articles and other content on here. Most definately one for my bookmarks. Brian
Hey everybody! I am completely new of this Site and so i high hopes that any person may want to boost myself. I absolutely need a suitable system to be able to change pictures combined with panorama pictures. Maybe Photoshop can be a useful program, despite the fact that i usually do not understand or know if that system is generally too stressful relating to me personally. Merely because i have in no way worked by using a good computer program similar to that of this Photoshop by Adobe application. Have actually somebody a good notion which brand for pc program may be really good for a novice?
I just wanted to comment and say that I really enjoyed reading your blog post here. It was very informative and I also digg the way you write! Keep it up and I'll be back to read more in the future
Good stuff, as always.
This is a great post.
Which Golf Clubs Are Better - Steel or Graphite ?
Very Interesting Information! Thank You For Thi Information!
Awesome Blog. I add this Post to my bookmarks.
You certainly have some agreeable opinions and views. Your blog provides a fresh look at the subject.
Should I buy steel golf clubs or graphite ?
I just book marked your blog on Digg and StumbleUpon.I enjoy reading your commentaries.
I just book marked your blog on Digg and StumbleUpon.I enjoy reading your commentaries.
You certainly have some agreeable opinions and views. Your blog provides a fresh look at the subject.
hmmm... Give individual tips to some website constructed from warez haxors.Doesn't sound wise .If you have time.Please enter my blog build your own laptop
I'll be showing this article to all my friends. What a interesting read, I appreciate this information very much.Patent An Idea, Patent New Invention Thank you, Sincerely.
The Avengers Movie 2012 Cant wait. Its going to be one of the best movies ever. All the big actors will be staring in it. It will be amazing
I’ve been visiting your blog for a while now and I always find a gem in your new posts. Thanks for sharing.
I find myself coming to your blog more and more often to the point where my visits are almost daily now!
Should I buy steel golf clubs or graphite ?
I stumbled on a link to your blog on another site, and I should say... Your website is tons better. I understand it better now, thanks
Been lookin for some useful information for the past hour thanks for this!