March 4, 2010 at 2:03 pm
Hi All,
Just wanted to make sure im not crazy, i have been reading through this book and found information regarding SQL 2008 datacollector feature that just isnt true, unless someone can prove otherwise.
This is the statement.
Lesson 4: Working with the Performance
Data Warehouse
Question;
1. As part of a recent acquisition, Humongous Insurance now has SQL Server
instances from version 6.5 through 9.0. A variety of third-party products and
custom code has been used in the past to manage capacity across the SQL Server
environment. Your manager wants to consolidate everything into a single platform
that can be used to perform capacity management tasks and evaluate performance
against baselines. You need to implement a solution that has minimal cost and
requires the least amount of effort to confi gure and maintain. What solution should
you propose?
A. Install a SQL Server 2008 instance and implement policy-based management.
B. Install a SQL Server 2008 instance and implement a Performance Data Warehouse.
C. Install a SQL Server 2008 instance and rewrite everything using SSIS.
D. Implement Microsoft System Center Operations Manager 2007.
Answers:
1. Correct Answer: B
A. Incorrect: The policy-based management feature is used to check rules against instances,
not to gather space and performance information.
B. Correct: The Performance Data Warehouse in SQL Server 2008 allows you to confi gure
data collection quickly against SQL Server 6.5 through 9.0 to consolidate all the capacity
management, as well as performance baseline analysis.
C. Incorrect: Although you could rewrite all the code using SSIS packages, it requires more
effort than using the built-in capabilities of the Performance Data Warehouse.
D. Incorrect: System Center Operations Manager 2007
I dont beliveve it can be deployed against anything else apart from SQL server 2008
Or am i wrong?
March 4, 2010 at 2:40 pm
Have you tried it or even Googling it?
I believe that you can.
If you disagree e-mail the Author or better yet try it yourself.
I would not get hung against the axle for I never saw it on the Exam, however I took the upgrade Exam.
Goggle is your best friend. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 4, 2010 at 2:48 pm
From articles i have read they say it is only viable on sql server 2008, but i have tried searching with no luck.
It would be great if you could deploy perf collection across all versions of SQL server.
This explains why you cannot run on different instances
http://qa.sqlservercentral.com/articles/Product+Reviews/66278/
March 5, 2010 at 12:47 am
It looks like it has to be deployed on a SQL 2008 instance. The collection sets include scheduled SSIS packages which access objects like dm views so there is a good chance it will collect data from a 2005 instance. Additionally, you can create custom collection sets against anything you like..you just have to map the data properly into the Performance DW.
March 5, 2010 at 7:53 am
It would appear that you answered your own question, way to go bro!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 8, 2010 at 8:04 pm
Well I don’t think that’s the case at all.
Above you suggest to create a SSIS package to manually import data into the MDW from different versions of SQL, Yes you could create SSIS packages to do the job also a host of other methods to extract the data, while your at it you may as well create you own MDW it would be easier instead of having to reverse engineer the collection and upload process which the data collector uses.
I think at this point it’s out of the scope of the question which suggests using SQL 2008 data collector framework you can implement a monitoring solution for SQL server 6.5 up, not build a hack. There is nothing on BOL, I’m sure if you put enough effort you could get it working, it would be easier to create your own data collector solution.
Please refer me to some documentation that states other wise.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply