-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathfaq.html
More file actions
359 lines (348 loc) · 24.9 KB
/
faq.html
File metadata and controls
359 lines (348 loc) · 24.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
<!DOCTYPE html>
<!--[if IE 8]> <html lang="en" class="ie8"> <![endif]-->
<!--[if IE 9]> <html lang="en" class="ie9"> <![endif]-->
<!--[if !IE]><!-->
<html lang="en">
<!--<![endif]-->
<head>
<title>SSASQueryAnalyzer</title>
<!-- Meta -->
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<link rel="shortcut icon" href="favicon.ico">
<link href='https://fonts.googleapis.com/css?family=Roboto:400,400italic,500,500italic,700,700italic,900,900italic,300italic,300' rel='stylesheet' type='text/css'>
<link href='https://fonts.googleapis.com/css?family=Roboto+Slab:400,700,300,100' rel='stylesheet' type='text/css'>
<!-- Global CSS -->
<link rel="stylesheet" href="assets/plugins/bootstrap/css/bootstrap.min.css">
<!-- Plugins CSS -->
<link rel="stylesheet" href="assets/plugins/font-awesome/css/font-awesome.css">
<link rel="stylesheet" href="assets/plugins/flexslider/flexslider.css">
<!-- Theme CSS -->
<link id="theme-style" rel="stylesheet" href="assets/css/styles.css">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body class="technicalinfo-page">
<!-- ******HEADER****** -->
<header id="header" class="header navbar-fixed-top">
<div class="container">
<h1 class="logo">
<a href="index.html">
<span class="text">ASQA</span>
</a>
</h1><!--//logo-->
<nav class="main-nav navbar-right" role="navigation">
<div class="navbar-header">
<button class="navbar-toggle" type="button" data-toggle="collapse" data-target="#navbar-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button><!--//nav-toggle-->
</div><!--//navbar-header-->
<div id="navbar-collapse" class="navbar-collapse collapse">
<ul class="nav navbar-nav">
<li class="active nav-item"><a href="index.html">Home</a></li>
<li class="nav-item dropdown">
<a class="dropdown-toggle" data-toggle="dropdown" data-hover="dropdown" data-delay="0" data-close-others="false" href="#">Product<i class="fa fa-angle-down"></i></a>
<ul class="dropdown-menu">
<li><a href="features.html">Features</a></li>
<li><a href="faq.html">FAQ</a></li>
<li><a href="about.html">About</a></li>
</ul>
</li><!--//dropdown-->
<li class="nav-item dropdown">
<a class="dropdown-toggle" data-toggle="dropdown" data-hover="dropdown" data-delay="0" data-close-others="false" href="#">Support<i class="fa fa-angle-down"></i></a>
<ul class="dropdown-menu">
<li><a href="contact.html">Contact</a></li>
<li><a href="https://github.com/SSASQueryAnalyzer/SSASQueryAnalyzer" target="_blank">Source code</a></li>
</ul>
</li><!--//dropdown-->
</ul><!--//nav-->
</div><!--//navabr-collapse-->
</nav><!--//main-nav-->
</div><!--//container-->
</header><!--//header-->
<div class="headline-bg faq-headline-bg"> </div><!--//headline-bg-->
<section class="promo section section-on-bg">
<div class="container text-center">
<h7 class="title">Troubleshooting MDX queries has never been so easy!</h7>
<p class="intro">
<strong>SQL Server Management Studio</strong> + <strong>Analysis Services Query Analyzer</strong>
<br>One tool, one click … that’s all!
</p>
<p><a class="btn btn-cta btn-cta-secondary" href="https://github.com/SSASQueryAnalyzer/SSASQueryAnalyzer/releases" target="_blank" onclick="gaSendEventDownload('addin')">Download</a></p>
</div>
</section>
<div class="sections-wrapper">
<section class="section cta-section text-center home-cta-section" id="cta-section"
style="height: 1px; background-image: none; padding-top: 0px; padding-bottom: 0px; "></section>
<section class="section cta-section text-center home-cta-section" id="cta-section" style="background-image: none; background-color: #ffffff; color: #ec6952; padding-top: 10px; padding-bottom: 10px; ">
<img height="84" style="padding-top: 10px; padding-bottom: 10px; " src="assets\images\icons\ASQA_Logo_64x64.png">
<div class="container text-center">
<p class="title" style="padding-top: 0px; padding-bottom: 0px; font-size: 48px; margin-bottom: 0px;"><strong>Frequently Asked Questions</strong></p>
</div>
</section>
<section class="section cta-section text-center home-cta-section" id="cta-section"
style="height: 1px; background-image: none; padding-top: 0px; padding-bottom: 0px; "></section>
<!-- ******FAQ Section****** -->
<section class="faq section has-bg-color" style="padding-top: 30px; padding-bottom: 20px;">
<div class="container">
<div class="row">
<div class="col-md-8 col-sm-10 col-xs-12 col-md-offset-2 col-sm-offset-1 col-xs-offset-0">
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq01" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>What is <strong>ASQA</strong>?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq01">
<div class="panel-body">
<strong>Analysis Services Query Analyzer (ASQA)</strong> is a tool, integrated in <strong>SQL Server Management Studio</strong>,
for troubleshooting <strong>MDX queries</strong>. It automatically executes all the required tasks to collect performance data
and metrics of an <strong>MDX query</strong>, and presents results in a graphical and easy understandable way.
</div>
</div>
</div>
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq02" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>Is it FREE?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq02">
<div class="panel-body">
Yes! <strong>Analysis Services Query Analyzer (ASQA)</strong> is a complete FREE tool distributed under the
<a href="https://goo.gl/Dj9BJh" target="_blank">
MIT license
</a>
and its source code is published on GitHub in
<a href="https://goo.gl/7Se1kC" target="_blank">
this repository.
</a>
</div>
</div>
</div>
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq03" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>How does it work?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq03">
<div class="panel-body">
<strong>Analysis Services Query Analyzer (ASQA)</strong> is the combination of an <strong>Analysis Service custom assembly</strong>
and an <strong>SQL Server Management Studio Addin</strong> (technically speaking, the correct term is <strong>VS Package</strong>).
The former represents the engine of the tool and has the responsibility to execute all the required tasks to collect performance
data and metrics of an <strong>MDX query</strong> following and respecting all the best practices.
It must be installed on the same <strong>SSAS Multidimensional instance</strong> where the <strong>MDX query performance analysis</strong> will be executed.
The latter has the responsibility of calling the execution of the analysis and presenting the results inside <strong>SQL Server Management Studio</strong>.
</div>
</div>
</div>
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq04" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>Why <strong>ASQA</strong>?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq04">
<div class="panel-body">
Troubleshooting <strong>MDX queries</strong> is a complex and time-consuming activity that:
<ul>
<li>
<u>requires a strong knowledge of the <strong>MDX language</strong> and of the <strong>SSAS Multidimensional engine</strong></u>
(fundamental to try to understand what happens behind the scenes during the resolution of the <strong>MDX query</strong>
and to consequently identify where the bottlenecks, if any, can reside)
</li>
<li>
<u>implies the execution of many repetitive and manual tasks</u>
(needed to collect and analyze data and metrics about <strong>MDX query performance</strong>).
</li>
</ul>
If <strong>Analysis Services Query Analyzer (ASQA)</strong>, evidently, nothing can do about the first requirement,
it can tremendously help to simplify and speed up the latter.
</div>
</div>
</div>
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq05" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>Which versions of <strong>SQL Server</strong> are currently supported?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq05">
<div class="panel-body">
The current version of <strong>Analysis Services Query Analyzer (ASQA)</strong> fully supports all the versions of
<strong>Analysis Services Multidimensional</strong> starting from the <strong>2012 version (Build number: 11.0.x.x)</strong>, and the <strong>ASQA Addin</strong>
can be installed in all the versions of <strong>SQL Server Management Studio</strong> starting from the <strong>2012 version (Build number: 11.0.x.x)</strong>.
It can also save all the analyses results in a dedicated database hosted in any version of <strong>SQL Server</strong> on premise starting from the <strong>2012 version (Build number: 11.0.x.x)</strong>
as well as on <strong>Azure SQL Database</strong>.
</div>
</div>
</div>
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq06" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>Must <strong>SQL Server Management Studio</strong> be up and running until the end of the query?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq06">
<div class="panel-body">
Good point! This is what we call <strong>Live Mode</strong> execution and is the default execution mode.
But <strong>ASQA Assembly</strong> can also save all the results of an analysis in a dedicated
<strong>SQL Server database</strong> on premise or on Azure instead of sending them back to the client.
In this way, the client still needs to be up and running until the end of the analysis execution,
<u>but the client can be any software able to send a request of analysis to the <strong>ASQA Assembly</strong></u>!
We call it <strong>Batch Mode</strong> execution and it only requires installing the <strong>ASQA SQL Server database</strong>
(by simply using a specific menu item of the <strong>ASQA SSMS Addin</strong>).
</div>
</div>
</div>
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq07" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>How can I launch a <strong>Batch Mode</strong> analysis?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq07">
<div class="panel-body">
A <strong>Batch Mode</strong> analysis, obviously, can be executed from the <strong>ASQA SSMS Addin</strong>,
but can also be launched by a <strong>PowerShell script</strong> (the <strong>ASQA SSMS Addin</strong> has a
specific menu item to automatically generate a <strong>PowerShell script</strong> for this) whose execution
can be scheduled, for instance, during the night. In this way, it is also possible to execute analysis on an
entire set of <strong>MDX queries</strong> (by using a <strong>PowerShell script</strong>, provided in the
installation folder, that loops through all the <strong>MDX query scripts</strong> contained in a folder)
and stores all the results of the analyses in the <strong>ASQA SQL Server database</strong>.
</div>
</div>
</div>
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq08" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>How can the data stored on the <strong>ASQA SQL Server database</strong> be visualized?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq08">
<div class="panel-body">
By simply using the <strong>ASQA SSMS Addin</strong> that has a specific window to filter the records of the
<strong>ASQA SQL Server database</strong> and easily identifies the results of analysis we are interested in.
Then they could be loaded and visualized by <strong>ASQA SSMS Addin</strong> as they were generated by a
<strong>Live Mode</strong> execution.
</div>
</div>
</div>
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq09" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>Does <strong>ASQA</strong> also work with <strong>SSAS tabular instance</strong>?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq09">
<div class="panel-body">
The engine of <strong>Analysis Services Query Analyzer (ASQA)</strong> is an <strong>Analysis Service custom assembly</strong>
and since <u>
<strong>SSAS tabular instance</strong> does not support <strong>Analysis Service custom assemblies</strong>,
it cannot work with <strong>SSAS tabular instance</strong>
</u>. This is the main reason why
<strong>Analysis Services Query Analyzer</strong> does not support <strong>DAX query</strong>.
</div>
</div>
</div>
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq10" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>How many analyses can be executed concurrently?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq10">
<div class="panel-body">
The <strong>ASQA SSAS Assembly</strong> is forced to manage only one analysis at a time.
This makes perfect sense since two analyses running simultaneously on the same server would negatively influence each other
and, consequently, the results of both would not be accurate. Obviously, since it is possible to install the
<strong>ASQA SSAS Assembly</strong> into multiple <strong>SSAS Multidimensional instances</strong>, it is possible
to execute multiple analyses at the same time but only if they are executed on different
<strong>SSAS Multidimensional instances</strong>. This is true for both execution modes: <strong>Live Mode</strong>
and <strong>Batch Mode</strong>.
</div>
</div>
</div>
<div class="panel">
<div class="panel-heading">
<h4 class="panel-title">
<a class="panel-toggle" href="#faq11" data-toggle="collapse" data-parent="#accordion"><i class="fa fa-plus-square"></i>What’s next?</a>
</h4>
</div>
<div class="panel-collapse collapse" id="faq11">
<div class="panel-body">
We are planning to develop many new features like an <strong>ASQA Excel addin</strong> (coming very soon!), an <strong>ASQA Pdf report</strong> or
<strong>eXtended Events</strong> support, so … stay tuned!
</div>
</div>
</div>
</div>
</div>
<div class="contact-lead text-center" style="margin-top: 0px;">
<h4 class="title">More questions?</h4>
<a class="btn btn-cta btn-cta-secondary" href="contact.html">Get in touch</a>
</div>
</div>
</section>
</div>
<!-- ******FOOTER****** -->
<footer class="footer" style="padding-top: 0px;">
<div class="footer-content">
<div class="container">
<div>
<br />
<p class="text-center" style="color:whitesmoke;font-size:150%;">Do you like ASQA? Spread the word!</p>
<center>
<a class="btn btn-cta btn-cta-secondary" href="https://goo.gl/vSvBnr" target="_blank" onclick="gaSendEventDownload('gadget-video')">Download video</a>
<a class="btn btn-cta btn-cta-secondary" href="https://goo.gl/56Ks4B" target="_blank" onclick="gaSendEventDownload('gadget-outlook')">Download Outlook signature banner</a>
</center>
</div>
<div class="row" style="height: 140px; padding-top: 0px; padding-bottom: 0px;">
<div class="footer-col connect col-xs-12 col-md-12" style="margin-bottom: 10px;">
<div class="section cta-section text-center home-cta-section " id="cta-section" style="height: 100px; padding-top: 0px; padding-bottom: 0px; margin-top: 27px;"></div>
</div><!--//foooter-col-->
</div>
</div><!--//container-->
</div>
</footer><!--//footer-->
<!-- Javascript -->
<script type="text/javascript" src="assets/plugins/jquery-1.12.3.min.js"></script>
<script type="text/javascript" src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
<script type="text/javascript" src="assets/plugins/bootstrap-hover-dropdown.min.js"></script>
<script type="text/javascript" src="assets/plugins/back-to-top.js"></script>
<script type="text/javascript" src="assets/plugins/jquery-placeholder/jquery.placeholder.js"></script>
<script type="text/javascript" src="assets/plugins/FitVids/jquery.fitvids.js"></script>
<script type="text/javascript" src="assets/plugins/flexslider/jquery.flexslider-min.js"></script>
<script type="text/javascript" src="assets/js/main.js"></script>
<script>
(function (i, s, o, g, r, a, m) {
i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function () {
(i[r].q = i[r].q || []).push(arguments)
}, i[r].l = 1 * new Date(); a = s.createElement(o),
m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m)
})(window, document, 'script', 'https://www.google-analytics.com/analytics.js', 'ga');
ga('create', 'UA-83860081-1', 'auto');
ga('send', 'pageview');
</script>
<script>
var gaSendEventDownload = function (category) {
ga('send', 'event', {
eventCategory: category,
eventAction: 'download',
eventLabel: '',
transport: 'beacon'
});
}
</script>
</body>
</html>