<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
The DBA Database
27 posts, Page 1 of 3
1
2
3
»
»»
The DBA Database
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Monday, July 30, 2012 9:12 PM
SSC-Dedicated
Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406,
Visits: 13,722
Comments posted to this topic are about the item
The DBA Database
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1337641
sugnu iu
sugnu iu
Posted Tuesday, July 31, 2012 4:28 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, May 10, 2013 10:01 AM
Points: 32,
Visits: 464
My company as a policy does not allow to build extra databases. So for me i built a CMS instance and use powershell to manage my instances
Post #1337770
dcaughill
dcaughill
Posted Tuesday, July 31, 2012 5:39 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 13, 2013 7:30 AM
Points: 4,
Visits: 135
My mentor and our Sr. DBA (wisely) put a DBA database in place for all critical environments. The setup gives us tables to audit/log DDL events, log certain other activity, monitor blocking, monitor statistics, and work with trace analysis and it has proven to be
extremely
valuable many times over! Couldn't agree more.
Post #1337806
nathaniel.drehmel
nathaniel.drehmel
Posted Tuesday, July 31, 2012 6:13 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 13, 2013 4:00 PM
Points: 3,
Visits: 27
Have you considered using the Management Data Warehouse feature available natively in SQL 2008 and higher?
http://msdn.microsoft.com/en-us/library/dd939169(v=SQL.100).aspx
We've found it to be quite useful for performance diagnostics, without the need for custom scripting. It's all built into SQL Server.
That said, we did build on Bill Ramos' excellent work to convert the reporting capability which ships with MDW to an SSRS based solution.
Post #1337832
Jim Sleeman-388184
Jim Sleeman-388184
Posted Tuesday, July 31, 2012 6:34 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, November 20, 2012 6:00 AM
Points: 100,
Visits: 176
Would / could you share the SSRS solution? I have been thinking about doing the samething, but just haven't found the time.
Jim
Post #1337852
Lian Pretorius
Lian Pretorius
Posted Tuesday, July 31, 2012 6:41 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:26 AM
Points: 1,138,
Visits: 1,106
In a perfect world MDW would be nice, but there will always be a couple of 2005 and/or 2000 instances floating around...
Post #1337854
nathaniel.drehmel
nathaniel.drehmel
Posted Tuesday, July 31, 2012 6:42 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 13, 2013 4:00 PM
Points: 3,
Visits: 27
I could, but would direct you to Bill's blog first:
http://blogs.msdn.com/b/billramo/
There's a six part series there on migrating MDW reports to SSRS. Bill's approach leverages a new query data collector to take advantage of the 'fingerprint' feature. As my organization already had a large deployment going, I had a need to build on Bill's work (or take away from you might say) by re-writing his reports to work with the out of the box query collector. If you have the ablity to deploy his query colelctor I would encourage you to go that route as the 'fingerprint' feature certainly adds value in aggregating similar, non-parameterized, queries by KPI.
Post #1337856
nathaniel.drehmel
nathaniel.drehmel
Posted Tuesday, July 31, 2012 6:46 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 13, 2013 4:00 PM
Points: 3,
Visits: 27
@Lian
Certainly true, but hopefully less and less. We (briefly) considered reverse engineering the SQL 2008 MDW / data collector solution to gather data from SQL 2005 instances, but then decided the effort outweighed the long term gains. Better to focus on moving those instances to SQL 2008 (or 2012, now).
@Jim
If after reading over Bill's blog you find you need query reports which work with the out of the box collectors let me know. That and an overview report which only displays instances to the end user to which they should have access are the two principal changes I've made to Bill's work. (So far)
Post #1337858
Eric Heilman
Eric Heilman
Posted Tuesday, July 31, 2012 6:49 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, April 10, 2013 9:36 AM
Points: 131,
Visits: 93
As part of a development team we have shared DBA resources, and cannot access most of the "good" stuff about the server ourselves. That being said, we do have a DBA-type database on each server as well as a centralized database where all the data is collected. We mainly store job run information so we can monitor the jobs and capture error information to help with error recovery rather than digging through the job history in SSMS. Using a query is much faster and much more informative.
Post #1337860
dcaughill
dcaughill
Posted Tuesday, July 31, 2012 6:52 AM
Forum Newbie
Group: General Forum Members
Last Login: Monday, May 13, 2013 7:30 AM
Points: 4,
Visits: 135
nathaniel.drehmel (7/31/2012)
I could, but would direct you to Bill's blog first:
http://blogs.msdn.com/b/billramo/
There's a six part series there on migrating MDW reports to SSRS. Bill's approach leverages a new query data collector to take advantage of the 'fingerprint' feature. As my organization already had a large deployment going, I had a need to build on Bill's work (or take away from you might say) by re-writing his reports to work with the out of the box query collector. If you have the ablity to deploy his query colelctor I would encourage you to go that route as the 'fingerprint' feature certainly adds value in aggregating similar, non-parameterized, queries by KPI.
Thanks for this - we've been doing a lot of SSRS work lately and I'd LOVE to harness this. Definitely going to check it out!
Post #1337865
« Prev Topic
|
Next Topic »
27 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
