Boyan Penev on Microsoft BI.A practical blog about Microsoft BI tools, techniques and practices written by a developer for other fellow developers.Career advice for the IT professional, as well as tips for SQL Server and Business Intelligence.Boyan Penev on Microsoft BI A practical blog about Microsoft BI tools, techniques and practices written by a developer for other fellow developers.When monitoring SSAS we can use a few tools to gain insight into what is happening on the instance.Perfmon is especially interesting as it shows us information about various aspects of the server we can see memory, disk, CPU and MDX counters out of the box.However, perfmon cannot show us how many queries were run on SSAS neither per period e.We have another counter, similar to a count of queries Storage Engine Query Total Queries Answered.This is not the same as the number of MDX queries answered, as if a query does not hit the Storage Engine SE, but the Formula Engine FE cache instead, it wont increment the counter.And, if a query needs to be answered by more than one Storage Engine requests, we will see that the counter gets incremented with more than 1.There are alternatives.We can try using the Query Log server settings and save queries to a database table automatically Unfortunately for us in this case, since the Query Log is typically used for Usage Based Optimisations UBO, it also shows SE requests, not the actual MDX queries issued.Hence, it suffers from the same drawback as the perfmon Total Queries Answered counter.The other alternative which comes to mind is SQL Server Profiler.After all it allows us to see what queries get sent to the server, along with lots of other useful information.If we are interested in the count of queries only, we can capture a trace which includes only the Query End event.Buy a EMC NetWorker Module for Microsoft SQL Server license 1 client or other Backup Software at CDW.VJYEIZ-nsc/hqdefault.jpg' alt='Install Multiple Instances Of Ssas Tabular' title='Install Multiple Instances Of Ssas Tabular' />
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |