《Microsoft SQL Server 2008 Analysis Services Step by Step》学习笔记十九：监视和管理工具进阶（本书完）
SQL Server 2008中SQL应用系列及BI笔记系列--目录索引导读:本文介绍Analysis Services中的监视和管理工具
本文将包括以下内容：
■1、使用Windows可靠性和性能监视器监视Analysis Services
■2、使用SQL Server Profler监视Analysis Services
■3、使用DMV检索Analysis Services元数据和性能信息
本文末尾提供两个项目源码：AdventureWorks_BI_Begin16和AdventureWorks_BI_End16，顾名思义，开始和完成。另外，包括数据库文件SSAS2008SBS_Data，请读者自行修改数据源ds的连接串。
1、使用Windows可靠性和性能监视器监视AS
Windows可靠性和性能监视器的详细说明，请参看MSDN（http://technet.microsoft.com/zh-cn/library/cc755081%28WS.10%29.aspx）
首先，在BIDS中部署项目，关闭BIDS。
然后，开始－－程序－－控制面板－－管理工具－－可靠性和性能监视器（或在运行中输入perfmon.msc /s，回车）
http://kdhfla.bay.livefilestore.com/y1p2Ze9MfAilpNoPRT9JVYL59WnpLPoc-a1pGiNLxA117e-u8q3m78oWGOCw9RpRFM2El-iwCXqieYJQdlL4IAFn3MspPiYIz7j/2011-6-6%2020-16-12.png?psid=1
sql server 2008的计数器为MSAS 2008，而sql server 2008 r2有计数器为MSOLAP
http://kdhfla.bay.livefilestore.com/y1pcWedzOKaUr5YsTk26kG7F5_VLRYs7hZa6PElki90qSPUX75i_usNJfdYtz3dS-7Y-Sxbc5rxBP2t-LSkil0uJn9MAODdMGRv/2011-6-6%2020-43-33.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pYhlkuaMDAXFwRfafAnZtL3Q9FPR9y1iQ8MebChhbicA3f46PlHzo1ri1vd2yBubnsGS0PVdKRotvhSuRGYQAoyKB8LL4v7K_/2011-6-6%2020-45-40.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pJ2LmXErXeYUvoRdKvy0HiSz9rrkgJQV41M-MagkdTN4KLRJMOomQkJ3YC9ginGvyLFaQ6aWjuuYJ7dG8A2qW6PA4IwMGxRKT/2011-6-6%2020-49-56.png?psid=1
http://kdhfla.bay.livefilestore.com/y1ps77Nt_1Lvi5UwLwSeaViv53DUKSzva4FDvI3bAAeA2_vixunTBnKNmTX24KhGlda1jrTKnED-QjOpBnoGscGbhwzfERcveqz/2011-6-6%2020-51-06.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pU6jYxJHdTlylCqMKqN4zFuATU3bYx5TUkGiIgDgXMZFH-PB-K4jdpVNpN6ct3n5_m3hsi6DKErH1JTBJg3kBkdypDPJm5leR/2011-6-6%2020-51-55.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pj49hDkHHNQiDVRFW1mkwGvbrmRjAbHno0qQTuI7C4VtwoiJbgWjCzKHqnzZTevKDncb4fcW6XM4temrsHLczHL6OLMN-SE_J/2011-6-6%2020-52-52.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pth4DuY-Y1oEHrMYi8j0a8YNDYwaQYe0NeA5CTsukNRuCxUuQjV2d6qDwmvdxdHnyybGWjlu-HLurygHZlw_AdMG5iTLWx0QU/2011-6-6%2020-57-17.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pkPGAAywWzXocJT2PRiMxywUobsuIsTJONETbTF2Liy54zo_bJnLhK-4cMX5IfAMoQN-FD3uKvXV1Lu_PvrB7zX1n0T13uA-K/2011-6-6%2020-59-02.png?psid=1
http://kdhfla.bay.livefilestore.com/y1po7B0L6HZ-64mxTD01PVu85r186j12-C5FkMyvKw4YKwrzmbkh1_LxVErdJBYGrhy1TJriQL40ccVA7QhYQOqBR3EnXErdE68/2011-6-6%2021-01-22.png?psid=1
切换到SSMS,
http://kdhfla.bay.livefilestore.com/y1p0yNGkDKcpTfvoL3PF2teTnQ7FbLFbwETmLxgMd4xGkPVq5ciMKgng_0AvQxsRj4d3OF4Q5h0Dph4tUR8W3HIJo2gfXjPzQGe/2011-6-6%2021-05-11.png?psid=1
切换到可靠性和性能监视器
http://kdhfla.bay.livefilestore.com/y1pEekTIcoYXUrywRJOcXVfCVJDGG0kGAEQoOx578UJw-Cu3rqQ6leC2VaZ3qK9u04vFI2HELij8QhFg5rwdrDzbcx69Pn7rBoj/2011-6-6%2021-06-33.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pnETy_RjDbWSpSsTLZiUnhbsW9e39Wb2h_s8pxnPwSfpP4bniWGIL8IRS_sszrdrRRcT5k1ogn-R-rIc8hW-fofXP7_4fz8WV/2011-6-6%2021-08-57.png?psid=1
切换到SSMS,
http://kdhfla.bay.livefilestore.com/y1phNn59wfPxPxYW8rzHZGu2b0O6OsGep4z5lEIL9D8H0OnzcV2arEJUymrGkf_51pxxPOgDV9X33jFumYa-5H-GpnNX8Vvpxhj/2011-6-6%2021-12-38.png?psid=1
切换到可靠性和性能监视器
http://kdhfla.bay.livefilestore.com/y1pQ4OOngUs_Eo8MaojhSgRWVq97VVRjb7wPF6vJrqzGU063U-vst5_6snvjp-MxcMTHPTh77TzUB6BXRIgLSaJDAqf4ySMnb1T/2011-6-6%2021-14-32.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pm5BdgDyxRuRStpzwEEoW7gaExmGaOqvty4TcJZpbyGVeBxgBOL6u3Op3kqsrMKIQoe0zF4gZwZJSImAQP1Wbj7dAalOFdaHI/2011-6-6%2021-15-51.png?psid=1
http://kdhfla.bay.livefilestore.com/y1p70XD_ilUqevRsjzKlWIm2rCkSybAkanFl-GFzFnZ7Ac7sMfeye7TdK_p20k6mFfMYL17mXjtvhnp9atvnFYe1jCByM9W2GBt/2011-6-6%2021-17-46.png?psid=1
切换到SSMS,关闭Process
切换到可靠性和性能监视器
http://kdhfla.bay.livefilestore.com/y1p70XD_ilUqevzSyyJ08sc--kSapuZ6Hgejwxjoz6_8zhYheUsP2CvDRP6GwnPKSQU5I0q2TdKtQWjaPUKgxSVz4bcJ6Yvpd6H/2011-6-6%2021-19-55.png?psid=1
http://kdhfla.bay.livefilestore.com/y1prDa_10K8THSRR48yOxXFSVlZv137J6nfKvbH_tLF5Y4dzxY5f0MRbKeMRlj7bHMtt7wN2YGovJWSZLKE9GVS5QN4zAr9dQMf/2011-6-6%2021-21-34.png?psid=1
下面从模板中创建数据收集器
http://kdhfla.bay.livefilestore.com/y1pZLakoypN-QvR3V-_cBN6wuYL5mdoK3eZQ23ngiop7trPef9C3Q32xjRO5pGeBAiMcB78rJz6HbkqvbKXyTR8Nr5G7U3uzuol/2011-6-6%2021-22-41.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pFadSZR-lK8vmFkWpcHmvuxBM6B1X5_jjO302jvzltr_CpHf-4qWAVM6V4eunzNVa0D2uPrbw4DckVnus7XYQEaLvxh-oGqs7/2011-6-6%2021-24-15.png?psid=1
http://kdhfla.bay.livefilestore.com/y1p1rUK9iV9vN4h32-t2bXKsILEFTnUT_TaKjjDAxF9gKDobZyVwzjwJTDWjHLmSK7H3A45KJyhlVc_Rij7j-dvgtx_aq0r_3Ew/2011-6-6%2021-26-01.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pVLdSMB6n9omgWzA5nHJa2Y01cUr5wxBgC4BXAzHKP6Vju6TqDnQlMACjgRVJaCMucd_hXeQSBhhvRlp4tz7st3lWzNBmMMPZ/2011-6-6%2021-29-29.png?psid=1
2、使用SQL Server Profler监视AS
开始－－程序－－Microsoft SQL Server 2008 R2－－Performance Tools－－SQL Profiler（或在运行中输入E:\Program Files\Microsoft SQL Server\100\Tools\Binn\PROFILER.EXE，回车）
新建一Trace
http://kdhfla.bay.livefilestore.com/y1pmzO3ZZCJO-SIi9SfAHu3Z88vwZuvunNDRnie_cLf7nYKtyUmfxhAGz2i_DXTWYLG7lNjYbmCDKAO8OPIZ4pQCgEZIqluBZnD/2011-6-6%2022-13-39.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pdxTAqBY7SmENXBrw9p8NBVHvPpxL54vxA5bUm5CV_UFjOe2-ueLH9u05V6Xhh9p5N43qr6UzJ-RBd2dQixD1nKkSeFAl4lm-/2011-6-6%2022-16-17.png?psid=1
切换到SSMS
http://kdhfla.bay.livefilestore.com/y1pPddCq5c9_buqeHSr-kc-cO-KRbFfVlYVKQ37Toc51pJvUU8V_Zo1XiyqJC8vfw2rnTBNTzSbYhKTCkVqGMuZVE2jypaDEcWw/2011-6-6%2022-08-00.png?psid=1
打开一个MdX查询
http://kdhfla.bay.livefilestore.com/y1pHhAUB77DMV3L0vOrCoACPwmxN1d7URhKpwQQTOQhDfJyUO5wKW8M4euERPHtiGAivKMujgbF10PEzVJAsPMXZrNz6Xejvbpg/2011-6-6%2022-21-39.png?psid=1
切换到SQL Server Profler
http://kdhfla.bay.livefilestore.com/y1pmieSoqg5-AIyu107jQv-DH1793PxlyouXV4BLt5fuj9BYoUfXP4jAfDZ2XNHmb9xVEznb1OXVw-QOyjDeIcKpBr02SB4114j/2011-6-6%2022-27-32.png?psid=1
http://kdhfla.bay.livefilestore.com/y1phxY3ptU4mCcwZW8_FZxO2FSpqSuxZHTXAC-UiWxc7LTDBBBR2Te58_SUVcr1MC7_yiEOZRRW7zf2X4G3OKl5VWhguqKkbG9l/2011-6-6%2022-33-09.png?psid=1
切换到SSMS
http://kdhfla.bay.livefilestore.com/y1p-wb5UuxpDnalfDZmbKwgxBRvrgNTseB1DGpOQs2YVa3Gz4LD3PIOdzR9m-vBgp0PxDxjBsvOzyKD8AmDR9uAnetSslWR9Wf1/2011-6-6%2022-47-02.png?psid=1
切换到SQL Server Profler
http://kdhfla.bay.livefilestore.com/y1paGE4udD9ftP4NAU1Q4nup9CNgxcOJT-eaf3gS7z-Wvu8JuNBogtJCzMfF-B1Isi-mgF0mv84_ksekXu0cvyXckD9tJNO-N9I/2011-6-6%2022-44-04.png?psid=1
切换到SSMS
http://kdhfla.bay.livefilestore.com/y1paGE4udD9ftO0TekFrgA-JWNhtXck_thRhmYgL5ys4RTtyFo9xMYT2fK_zy_gKil_6mTGFRUGL2XLXJr2ggF8abTDCrrkCqcZ/2011-6-6%2022-34-33.png?psid=1
切换到SQL Server Profler
文件－－另存为－－模板
http://kdhfla.bay.livefilestore.com/y1pgH_tqNJshP0Wq_VA7a2Et8Q2vD3Qoj8SphYLfBSyevRaE9YqI2ef6dTKmqKSMHXPSgSxQIMuVwjWX-PWgjrcv-g43W4xNAqA/2011-6-6%2022-49-45.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pl_DkEDYbM7cTt9pVSfyZuQRoD5BeodSzIrAY2fMhVrjtGrxIOwNRwZvYHW_4-74GVtMrBJbPJtNxkWvIXr1zlkuQeXfoeymO/2011-6-6%2022-50-36.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pgH_tqNJshP1SzYD4-NTo5WT242qc-P_qRWHpe35hSg6KD8fQEQt1aKsmMnFku5udLPcbzco1-mq4Kyk0YoCWTb37OLGKtJlm/2011-6-6%2022-51-17.png?psid=1
http://kdhfla.bay.livefilestore.com/y1pgH_tqNJshP3GxpuqJcy5P4pwYJVI720IbLm20ChOUaWxeBk41wEazsoc4HPcqn06udBiM4DJGHQHIgGosTEDjB0mfDWRBcPn/2011-6-6%2022-52-32.png?psid=1
http://kdhfla.bay.livefilestore.com/y1p2cl3u4XVHCtz9lhlUp_TjpX-_BXC3jjx7HWHlOHkLrlKIAq29_ewxcVNeMEBcKpjD61T8-DoTRDO6JsVV6EYvN5nj9HE6QQZ/2011-6-6%2022-53-34.png?psid=1
导出的模板可以导入，修改并反复使用。
3、使用DMV检索Analysis Services元数据和性能信息
与AS有关的DMV主要在$SYSTEM架构中。其中最重要的视图是DISCOVER_SCHEMA_ROWSETS（http://msdn.microsoft.com/zh-cn/library/ms126280.aspx）
MDX查询示例:
SELECT * FROM $SYSTEM.MDSCHEMA_DIMENSIONS
SELECT * FROM $SYSTEM.DISCOVER_SCHEMA_ROWSETS
切换到SSMS
http://jbw3ig.bay.livefilestore.com/y1pjWmNiZjWxaYTnJTEMqS34FV4n3MTlqt9B4jN2pNKy2UI6UQWxOdWcdP4Bk-liS-y2jX-jhD5EcZSBwWYHSpiz0REGqqQcL_g/2011-6-6%2023-21-13.png?psid=1
http://jbw3ig.bay.livefilestore.com/y1pjWmNiZjWxaZEj_xGteQMy2HSzBnq6Gwrb8ccM-WxwXNBP0-AFnEMRoL8ApTRvN_9jER_Cd5KFlCWYixQDYjdzwIB7xv_jsoV/2011-6-6%2023-18-25.png?psid=1
http://jbw3ig.bay.livefilestore.com/y1pjWmNiZjWxaYTnJTEMqS34FV4n3MTlqt9B4jN2pNKy2UI6UQWxOdWcdP4Bk-liS-y2jX-jhD5EcZSBwWYHSpiz0REGqqQcL_g/2011-6-6%2023-21-13.png?psid=1
http://jbw3ig.bay.livefilestore.com/y1p8AX-8DkFznmzDIdjDxurvv_xQpeFqogzZfsOiO_W91qnfr6SMs5opuK7qCldeDfvQ88-evtEhhJlU3Hd_Pz0ddYNYt9gj05e/2011-6-6%2023-22-36.png?psid=1
http://jbw3ig.bay.livefilestore.com/y1pJrYwNEfv095Q4BJlSZtZsFnKnbY31JYlfiIayjhKDDZDi1EMXEs19G7-UhpXAb__7GACnnW0wMczDRDz-NpNgPwuZNOEtX-2/2011-6-6%2023-23-25.png?psid=1
http://jbw3ig.bay.livefilestore.com/y1pbDqxHi6MPt9o8UFdcYX3w8m0N5QEBbCjX9IVJNcs45iVEYrOKCHew8JSslJUWHQnIDU__3d6rlhWj4gwExosohHeD-vBkIVe/2011-6-6%2023-24-48.png?psid=1
至此，本书的读书笔记结束，欢迎与邀月共同学习下本:《Microsoft SQL Server 2008 MDX Step by Step》
源码下载：
begin16
end16
数据库下载
参考资源：
1、SQL Server Analysis Services 官方教程
（http://technet.microsoft.com/zh-cn/library/ms170208.aspx）
页:
[1]